Issue with importing cobol definition

senthil_tcs · Post by **senthil_tcs** » Wed Sep 23, 2009 5:29 am

when i try importing cobol copy book, DS throws error for PIC BLOB and PIC LONG and states invalid string datatype. I understand these datatypes are not supported by DS. I just wanted to check if someone has faced issue with such kind of datatype . If yes please let me know how i can resolve this issue. As this cobol cpy book is created by executing oracle DDL.

Can anyone please help me with equivalent cobol definition for datatype BLOB and LONG which is of Oracle.

Thanking in advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Sep 23, 2009 5:44 am

That is from Pro*COBOL. It also have features for communication area who is restricted to Oracle.

DataStage supports MainFrame COBOL.

Better check the header files.

senthil_tcs · Post by **senthil_tcs** » Wed Sep 23, 2009 9:12 am

thanx for the reply.

There is no header file that i am aware of. I have been given this cobol definition file that i was trying to import in DS. As mentioned before this cobol definition is created by executing oracle DDL statements. There are around 50 tables. 4 Tables with datatype BLOB and LONG are throwing error message and unable to import and remaining ones are sucessfully imported.

Can you please explain little more in detail. I used cobol definitions before without any issues but this one is for binary files that's the only difference

chulett · Post by **chulett** » Wed Sep 23, 2009 9:21 am

As you noted, those BLOB and LONG data types are not supported so your best bet is to stay with an Oracle solution, probably PL/SQL.