Hello
We have input file with around 6500 rows as below and would need to build a
control card to update the DB
US1234567897272 -(1st 2 bytes countrycode,next 9 bytes item number ,next 4
bytes PLU nbr)
I need to generate a SQL UPDATE code generator like below. ("?" need to be
pulled from the file )
UPDATE K1GHGMT.RTALABLE_ITKM_SG
SET LAST_CHG_TIMESTAMP = CURRENT TIMESTAMP
, LAST_CHANGE_USERID = 'WKYT'
WHERE COUNTRY_CODE = ?
and PLU_ITEM_NBR =?
and item_nbr = ?
commit ;
Could some let me know how this can be done using SORT (DFSORT) jcl.
Regards
Ron T
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
