Sample TeraWin Output

CREATE TABLE ClaimHeader (
       TransactionControlNumber DECIMAL(17) NOT NULL TITLE 'TransactionControlNumber',
       ClaimType            CHAR(1) TITLE 'ClaimType',
       RecordCode           CHAR(2) TITLE 'RecordCode',
       RecipientID          CHAR(8) TITLE 'RecipientID',
       InputMediaType       CHAR(1) TITLE 'InputMediaType',
       AdjustmentReasonCode CHAR(3) TITLE 'AdjustmentReasonCode',
       PriorAuthorizationNumber DECIMAL(11) TITLE 'PriorAuthorizationNumber',
       AdjustReasonCodeDesc VARCHAR(20) TITLE 'AdjustReasonCodeDesc',
       ClaimStatus          CHAR(1) TITLE 'ClaimStatus',
       TotalClaimCharge     DECIMAL(11,2) TITLE 'TotalClaimCharge',
       ThirdPartyPmtAmt     DECIMAL(11,2) TITLE 'ThirdPartyPmtAmt',
       NetClaimCharge       DECIMAL(11,2) TITLE 'NetClaimCharge',
       ReimbursementAmount  DECIMAL(11,2) TITLE 'ReimbursementAmount',
       ReimbursementStatus  CHAR(1) TITLE 'ReimbursementStatus',
       AccountingCode       CHAR(1) TITLE 'AccountingCode',
       ReplacedByTCN        DECIMAL(17) TITLE 'ReplacedByTCN',
       TCNReplaced          DECIMAL(17) TITLE 'TCNReplaced',
       McareAmountPaid      DECIMAL(11,2) TITLE 'McareAmountPaid',
       BilledDate           DATE FORMAT 'mm/dd/yyyy' TITLE 'BilledDate',
       EntryDate            DATE FORMAT 'mm/dd/yyyy' TITLE 'EntryDate',
       SuspenseDate         DATE FORMAT 'mm/dd/yyyy' TITLE 'SuspenseDate',
       LastCycleDate        DATE FORMAT 'mm/dd/yyyy' TITLE 'LastCycleDate',
       AdjudicationDate     DATE FORMAT 'mm/dd/yyyy' TITLE 'AdjudicationDate',
       OriginalPayDate      DATE FORMAT 'mm/dd/yyyy' TITLE 'OriginalPayDate',
       DateToHistory        DATE FORMAT 'mm/dd/yyyy' TITLE 'DateToHistory'
)
       UNIQUE PRIMARY INDEX (
              TransactionControlNumber
       )
;        

Output CREATE TABLE and Fastload Script:

/* FastLoad Script Generated by TeraWin             */
/*       Version: 4.0a                              */
/* Registered to: Don Look                          */
/*       Company: DFL Designs                       */
/*          Date: 11/15/1997 13:32                  */
/*    Input File: C:\VB\APPS\TERAWIN\TABLES.SQL     */
/*   Output File: c:\vb\apps\terawin\tables.tfl     */
/*     Target DB: Teradata Version 2                */
/*         Table: ClaimHeader                       */
/*      Row Size: 138 (Raw Data) +  21 (Overhead) =  159 Bytes */
DROP TABLE DonsDB.ClaimHeader;
CREATE TABLE DonsDB.ClaimHeader, MAXIMUM DATABLOCKSIZE
     (
     TransactionControlNumber  DECIMAL (17) NOT NULL
                               TITLE 'TransactionControlNumber',
     ClaimType                 CHAR (1) TITLE 'ClaimType',
     RecordCode                CHAR (2) TITLE 'RecordCode',
     RecipientID               CHAR (8) TITLE 'RecipientID',
     InputMediaType            CHAR (1) TITLE 'InputMediaType',
     AdjustmentReasonCode      CHAR (3) TITLE 'AdjustmentReasonCode',
     PriorAuthorizationNumber  DECIMAL (11) TITLE 'PriorAuthorizationNumber',
     AdjustReasonCodeDesc      VARCHAR (20) TITLE 'AdjustReasonCodeDesc',
     ClaimStatus               CHAR (1) TITLE 'ClaimStatus',
     TotalClaimCharge          DECIMAL (11,2) TITLE 'TotalClaimCharge',
     ThirdPartyPmtAmt          DECIMAL (11,2) TITLE 'ThirdPartyPmtAmt',
     NetClaimCharge            DECIMAL (11,2) TITLE 'NetClaimCharge',
     ReimbursementAmount       DECIMAL (11,2) TITLE 'ReimbursementAmount',
     ReimbursementStatus       CHAR (1) TITLE 'ReimbursementStatus',
     AccountingCode            CHAR (1) TITLE 'AccountingCode',
     ReplacedByTCN             DECIMAL (17) TITLE 'ReplacedByTCN',
     TCNReplaced               DECIMAL (17) TITLE 'TCNReplaced',
     McareAmountPaid           DECIMAL (11,2) TITLE 'McareAmountPaid',
     BilledDate                DATE FORMAT 'mm/dd/yyyy' TITLE 'BilledDate',
     EntryDate                 DATE FORMAT 'mm/dd/yyyy' TITLE 'EntryDate',
     SuspenseDate              DATE FORMAT 'mm/dd/yyyy' TITLE 'SuspenseDate',
     LastCycleDate             DATE FORMAT 'mm/dd/yyyy' TITLE 'LastCycleDate',
     AdjudicationDate          DATE FORMAT 'mm/dd/yyyy'
                               TITLE 'AdjudicationDate',
     OriginalPayDate           DATE FORMAT 'mm/dd/yyyy' TITLE 'OriginalPayDate'
                              ,
     DateToHistory             DATE FORMAT 'mm/dd/yyyy' TITLE 'DateToHistory'
     )

       UNIQUE PRIMARY INDEX (
              TransactionControlNumber
)
;
DROP TABLE    DonsErrorDB.ClaimHeader_ERR1;
DROP TABLE    DonsErrorDB.ClaimHeader_ERR2;
SET RECORD UNFORMATTED;
DEFINE
     TransactionControlNumber                (DECIMAL (17)),
     ClaimType                               (CHAR    (1)),
     RecordCode                              (CHAR    (2)),
     RecipientID                             (CHAR    (8)),
     InputMediaType                          (CHAR    (1)),
     AdjustmentReasonCode                    (CHAR    (3)),
     PriorAuthorizationNumber                (DECIMAL (11)),
     AdjustReasonCodeDesc                    (CHAR    (20)),
     ClaimStatus                             (CHAR    (1)),
     TotalClaimCharge                        (DECIMAL (11,2)),
     ThirdPartyPmtAmt                        (DECIMAL (11,2)),
     NetClaimCharge                          (DECIMAL (11,2)),
     ReimbursementAmount                     (DECIMAL (11,2)),
     ReimbursementStatus                     (CHAR    (1)),
     AccountingCode                          (CHAR    (1)),
     ReplacedByTCN                           (DECIMAL (17)),
     TCNReplaced                             (DECIMAL (17)),
     McareAmountPaid                         (DECIMAL (11,2)),
     BilledDate                              (CHAR    (10)),
     EntryDate                               (CHAR    (10)),
     SuspenseDate                            (CHAR    (10)),
     LastCycleDate                           (CHAR    (10)),
     AdjudicationDate                        (CHAR    (10)),
     OriginalPayDate                         (CHAR    (10)),
     DateToHistory                           (CHAR    (10)),
     END_OF_RECORD_CHAR                      (CHAR    (1)),
     FILE=%pathname%;
 
SHOW;
 
BEGIN LOADING DonsDB.ClaimHeader
   ERRORFILES DonsErrorDB.ClaimHeader_ERR1,
              DonsErrorDB.ClaimHeader_ERR2;
RECORD 1;
INSERT INTO DonsDB.ClaimHeader
  VALUES(
         :TransactionControlNumber,
         :ClaimType,
         :RecordCode,
         :RecipientID,
         :InputMediaType,
         :AdjustmentReasonCode,
         :PriorAuthorizationNumber,
         :AdjustReasonCodeDesc,
         :ClaimStatus,
         :TotalClaimCharge,
         :ThirdPartyPmtAmt,
         :NetClaimCharge,
         :ReimbursementAmount,
         :ReimbursementStatus,
         :AccountingCode,
         :ReplacedByTCN,
         :TCNReplaced,
         :McareAmountPaid,
         :BilledDate,
         :EntryDate,
         :SuspenseDate,
         :LastCycleDate,
         :AdjudicationDate,
         :OriginalPayDate,
         :DateToHistory
        );
END LOADING;