Thanks a bunch Kolusu..
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>>fyi , we are using DFSORT and not Syncsort .
Well that is good news. On that note then here is the solution.
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
US1234567897272
//SORTOUT DD SYSOUT=*
//SYSINDD *
OPTION COPY
OUTFIL BUILD=(C'UPDATE K1GHGMT.RTALABLE_ITKM_SG'
ok thanks a lot Kolusu.fyi , we are using DFSORT and not Syncsort .
Regards
Ron T
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> Could some let me know how this can be done using SORT (DFSORT) jcl.
Ron,
Your shop has other competitive product to DFSORT and yet you request the
solution for DFSORT. The control cards may run fine with both products,
but the least you can do is mention the right product. Moreover this is on
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