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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN