MVSFORUMS.com

viswanathan · Beginner Joined: 17 Jan 2006 Posts: 26 Topics: 13

Hi All,

I have to load a DB2 Table with LOB datatypes. We have to populate values for all the columns in the DB2 Table and have to load the file using DSNUTIL utility. Could someone help me on how to populate the values for CLOB/BLOB Dataype columns in the table.

Note: These fields defined as BLOB/CLOB as they can hold >32KB data

Regards,
Vishwa.

kolusu · Posted: Tue Jun 07, 2011 9:24 am Post subject:

viswanathan,

Check this Unloading and Loading LOB data in DB2 for z/OS becomes reality

Kolusu

viswanathan · Beginner Joined: 17 Jan 2006 Posts: 26 Topics: 13

Hi Kolusu,

Thanks for the doc.

My understanding from the doc, I should be able to load the LOB datatype with CHAR field. As the process followed for my current shop does not allow me to write a COBOL program for this load.

Could you please confirm my understanding?

Many thanks

Viswanathan

bauer · Posted: Thu Jun 16, 2011 5:37 pm Post subject:

Other doc.

IBM redbook, SG24-7270-00, LOBs with DB2 for z/OS:
Stronger and Faster.

bauer