CFF - Level 88

dsuser_cai · Post by **dsuser_cai** » 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

chulett · Post by **chulett** » Sat Mar 03, 2012 9:21 am

I for one am a little confused here... why are we mixing database terms like DB2 and stored procedure with CFF, copy book and 88 levels, which are COBOL related?

ray.wurlod · Post by **ray.wurlod** » Sat Mar 03, 2012 2:22 pm

Level 88 is working storage. It should not be exposed to ETL tools or, if it is, it should be ignored by them.