Hello- I am creating a dynamic SFTP sortcard using DFSORT, here in the Input file the Store_nbr is at position 40. I need the file to created as
SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_33.csv but the issue is the store_nbrs are of different length, the .csv is not getting created correctly . Could some one let me know how we can append the .csv also when the store is of variable length Input File ---+----1----+----2----+----3----+----4----+ ******************************** Top of Data ITEM_NBR } ITEM_DESC1 } STORE_NBR } 500849599 }ENT MASSA TORTA 2 KG }33 500878286 }CAST DE CAJU TS 120G }331 500862526 }MTR MASS LASANH SECA }3 500877131 }PERU INTEIR C MIUDOS }3323 500034169 }ACUC FIT UNIAO }3311 500832360 }AMPOLA PANTENE UNIDA }33 output card generated SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_33 SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_331 SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_3 SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_3323 SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_3311 SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_33 Control Card used SORT FIELDS=COPY OUTREC BUILD=(1:C'SPUT ', 6:C'''',7:C'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01', 41:C'''', 43:C'FUTRETAIL_', 53:DATE1(-)-1,63:C'_',64:40,4,21X) Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
