I have a stored procedure in Oracle that is being executed from a Cobol program through Federation Server. In the stored procedure, I have one input parameter (VARCHAR2) and one output parameter (DECIMAL). When the nickname is created on the DB2 side, they show up as VARCHAR and DOUBLE. I've tried changing the definition on the Oracle side to DECIMAL, NUMBER, and INTEGER but on the DB2 side, it always shows as DOUBLE.
Is there a way to change this. I'm returning up to a 12 digit integer value.