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
