MVSFORUMS.com

[ramu_mohan21]

HI Board,

We have a DB2 table consisting of Columns as type ROW-ID and CLOB. When we generated DCLGEN with Language COBOL option we got

10 ROW-ID USAGE SQL TYPE IS ROWID.
10 SAVE-AREA USAGE SQL TYPE IS CLOB-LOCATOR.

Can we have ROWID and CLOB-LOCATOR types in COBOL. If yes how can we use ROWID while inserting a new row in that table?
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

[kolusu]

ramu_mohan21,


Check this link for a detailed explanation of Determining equivalent SQL and COBOL data types

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/2.4.3.7?SHELF=&DT=20010710165542&CASE=


Check this link for a detailed explanation about Inserting data into a ROWID column

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/1.2.3.1.2?SHELF=&DT=20010710165542&CASE=


Check this link for a detailed explanation of Programming for large objects (LOBs)

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/3.2?DT=20010710165542

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[ramu_mohan21]

Thanks Kolusu. This helps me alot.
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer