CFF - Level 88
Posted: Sat Mar 03, 2012 7:39 am
Hi
I have a DB2 stored procedure that i need to call from DataStage.
It has 2 parameters (1 input - 150 char length and 1output - 29500 length).
I checked the copy book and I see records with level 88. Also when I call the SP from DataStage, I can see only the first few characters (its the point before the 'OCCURS' statement starts). Anything after that is just spaces.
When the mainframe team calls the stored procedure with the same parameters (as i use) they are able to see the entire output.... Im afraid in going wrong somewhere... can somebody help me with this. Please let me know if you need more information.
Thanks
Karthick
I have a DB2 stored procedure that i need to call from DataStage.
It has 2 parameters (1 input - 150 char length and 1output - 29500 length).
I checked the copy book and I see records with level 88. Also when I call the SP from DataStage, I can see only the first few characters (its the point before the 'OCCURS' statement starts). Anything after that is just spaces.
When the mainframe team calls the stored procedure with the same parameters (as i use) they are able to see the entire output.... Im afraid in going wrong somewhere... can somebody help me with this. Please let me know if you need more information.
Thanks
Karthick