IBM Mainframe Forum

Hi,

The input file we are reading, in that we have numbers.. That numbers i need to update to one of the column in DB2 table. The column is defined as integer. Could you please guide us how to write the JCL to update the DB2 table.

Num1 variable with defined as number with 8 digits.
colum1 column with defined as integer with 8 digits.

Thanks

Hello and welcome to the forum,

JCL will not do this. . . JCL executes programs. . .

Which program do you intend to use to update the table? Do you have some utility that is used on your system or will you write a program to do this?