Number to update the value in DB2 table.



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Number to update the value in DB2 table.

Postby guru_vadiraja » Tue Jun 22, 2010 9:08 pm

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
guru_vadiraja
 
Posts: 1
Joined: Fri May 28, 2010 12:21 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Number to update the value in DB2 table.

Postby dick scherrer » Tue Jun 22, 2010 11:20 pm

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6269
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post