Archives of the TeradataForum

Message Posted: Wed, 14 Apr 2004 @ 07:18:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, April 14, 2004 00:14 -->

Hello,

Could you please help me here.

I am doing fastload . i have a COBOL REDEFINES class for the following fields. I loaded the data into the table by only defining the ACCT- SER-NO in the fastload script. Now from that table i need to pull the AMT-OF-CHK-CHR how i have to get this data, because AMT-OF-CHK-CHR data type is S9(05)V9(02) COMP-3. Normally for this type of data we have to have equilant data type is DECIMAL(7,2). This is the first time i am handling REDEFINES. Could you please let me know how i have to handle REDEFINES in FASTLOAD.

     03  ACCT-SER-NO                PIC X(8).

     03  V1-FILLER-3 REDEFINES ACCT-SER-NO.
       05  VER-CD                   PIC XX.
       05  FILLER                   PIC X(02).
       05  AMT-OF-CHK-CHRG          PIC S9(05)V9(02) COMP-3.

     03  V1-FILLER-4 REDEFINES ACCT-SER-NO.
       05  PCKD-VN-NBR              PIC S9(04) COMP-3.
       05  PCKD-TUS-CD              PIC S9(03) COMP-3.
       05  BUS-OFC-CD               PIC X(02).
       05  FILLER                   PIC X(01).

     03  VER-BLG-NBR REDEFINES ACCT-SER-NO.
       05  TOLL-ADJ-BLG-COC         PIC X(3).
       05  TOLL-ADJ-BLG-FLR         PIC X.
       05  TOLL-ADJ-BLG-LN-NBR      PIC X(4).

	<Prev	Next>		<<First	<Prev	Next>	Last>>