Re: Sort Jcl to build a Update table control card

2020-07-02 Thread Ron Thomas
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

Re: Sort Jcl to build a Update table control card

2020-07-01 Thread Sri h Kolusu
>>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'

Re: Sort Jcl to build a Update table control card

2020-07-01 Thread Ron Thomas
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

Re: Sort Jcl to build a Update table control card

2020-07-01 Thread Sri h Kolusu
> 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

Sort Jcl to build a Update table control card

2020-07-01 Thread Ron Thomas
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