Ron, I am not really sure you even need a sort step to load into Tera data. I am not familiar with teradata load cards , but if it behaves anything like DB2, and your intention is to load only 5 bytes you can specify the start position to 11 (instead of 10) on your load card to load only the 5 bytes. Check out the examples here which shows how you can specify the positions of the data to be loaded.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGJ12/2.14.6 If you insist on using a sort step to copy then you can use the following. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DISP=SHR,DSN=Your input FB 80 byte file //SORTOUT DD SYSOUT=* //SYSIN DD * OPTION COPY OUTREC BUILD=(1,9,11,70,X) //* We will have a space at the end to account for the additional byte we dropped off. Kolusu DFSORT Development IBM Mainframe Discussion List <[email protected]> wrote on 09/12/2013 10:39:43 AM: > From: Ron Thomas <[email protected]> > To: [email protected], > Date: 09/12/2013 10:40 AM > Subject: SORT Help > Sent by: IBM Mainframe Discussion List <[email protected]> > > Hello > > We have a input file defintion as PIC S9(4)V9(5) COMP-3 & we are > modifying the same to PIC S9(5)V9(5) COMP-3. The file is created > with this new data definition. > > This modified file is fed to a third party application where we are > moving the data to teradata and here the data is defined as DECIMAL > (9,5). The file is 80 bytes in length and this fields starts in > position 10. We are thinking of putting a SORT step to do the > transformation so that data goes in the way it used to be. > > Once the teradata table is modifled at some point of time we will > remove the step. Pls some one let me know how SORT to be applied so > that data truncations will not come? > > Thanks > Ron T > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
