Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 16:08:05 GMT


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


Subj:   BTEQ Export to Fastload in record mode is failing
 
From:   Donald Iuppa

Hi All,

I am trying to export a table using BTEC in record mode and load it using fastload into another remote database.

I can successfully EXPORT and IMPORT using BTEQ, so I know my exported file is OK.

Using BTEQ for the import is very very slow, not a surprise.

When I try to fastload it I get an error:

     *** 11:27:32 Starting to send to RDBMS with record 1
     *** 11:27:32 Bad file or data definition.
     *** 11:27:32 The length of: LATA_OF_SWITCH_LOCATION in row: 1 was greater than defined.
                  Defined: 5, Received: 13878

This is strange since I created the fastload script from the BTEC script as a starting point.

Is there some option I am missing to get fastload to recognize the format of this data?

I am using the "SET RECORD FORMATTED" Command.

I am not sure this is the best way to move this table but the manuals indicate that this should work and the export is fast enough for what I am doing.


Thank You,

--Don


The three scripts follow along with the output logs (the scripts are partly in ksh, please ignore that the ${macro}) stuff gets expanded out):

BTEQ Export Script: The output log is included below:

     .set session trans BTET;
     .logon ${TenE_TER_MACHINE}/${TenE_MASTER_USER},${TenE_MASTER_PASSWORD};
     .SET MAXERROR 08
     DATABASE ${TenE_LERG_DB};
     .EXPORT DATA FILE=T_TEMPORAL_NPANXXX_LKUP.exp
     SELECT * FROM T_TEMPORAL_NPANXXX_LKUP;
     .EXPORT RESET
     .LOGOFF
     .QUIT

BTEQ IMPORT Script, The output log is included below:

     .set session trans BTET;
     .SET SESSIONS 10;
     .logon ${TenE_TER_MACHINE}/${TenE_MASTER_USER},${TenE_MASTER_PASSWORD};
     .SET REPEATSTOP ON;

     .REPEAT 10
     .SET MAXERROR 01;

     .REPEAT 10
     DATABASE ${TenE_LERG_DB};

     .REPEAT 10
     .SET QUIET ON;

     .REPEAT 10
     .SET TIMEMSG DEFAULT

     DELETE FROM T_TEMPORAL_NPANXXX_LKUP ALL;

     .IMPORT DATA FILE=T_TEMPORAL_NPANXXX_LKUP.exp;
     .REPEAT *;
     USING
          NPANXXX                  (CHAR(7)  ),
          EFF_DATE            (DATE          ),
          EXP_DATE            (DATE          ),
          END_DATE            (DATE          ),
          E_STATUS_DATE            (DATE          ),
          LAST_MOD_DATE            (DATE          ),
          NPA                 (CHAR(3)  ),
          NXX                 (CHAR(3)  ),
          BLOCK_ID            (CHAR(1)  ),
          STATE_PROV_TERRITORY_COUNTRY  (CHAR(2)  ),
          LATA_OF_SWITCH_LOCATION       (VARCHAR(5)    ),
          LATA_OF_RATE_CENTER_LOCATION  (VARCHAR(5)    ),
          LATA_NAME           (VARCHAR(20)   ),
          OCN                 (CHAR(4)  ),
          SWITCH                   (CHAR(11) ),
          LOCALITY_NAME            (VARCHAR(10)   ),
          LOCALITY_COUNTY               (VARCHAR(2)    ),
          ACCESS_TANDEM            (CHAR(2)  ),
          END_OFFICE               (CHAR(2)  ),
          COC_TYPE            (CHAR(3)  ),
          SPECIAL_SERVICE_CODE          (CHAR(4)  ),
          RATE_CENTER_NAME_ABBREVIATION (VARCHAR(10)   ),
          SWITCH_HOMING_ARRANGEMENT_IND (CHAR(2)  ),
          TEST_LINE_NUMBER         (SMALLINT ),
          THOUSANDS_BLOCK_POOLING_IND   (CHAR(1)  ),
          DIALABLE_IND             (CHAR(1)  ),
          PORTABLE_IND             (CHAR(1)  ),
          RATE_CENTER_TYPE         (CHAR(1)  ),
          COUNTRY                  (CHAR(7)  ),
          AOCN                (CHAR(4)  ),
          CATEGORY            (CHAR(10)      )

     INSERT INTO T_TEMPORAL_NPANXXX_LKUP (
          NPANXXX                  ,
          EFF_DATE            ,
          EXP_DATE            ,
          END_DATE            ,
          E_STATUS_DATE            ,
          LAST_MOD_DATE            ,
          NPA                 ,
          NXX                 ,
          BLOCK_ID            ,
          STATE_PROV_TERRITORY_COUNTRY  ,
          LATA_OF_SWITCH_LOCATION       ,
          LATA_OF_RATE_CENTER_LOCATION  ,
          LATA_NAME           ,
          OCN                 ,
          SWITCH                   ,
          LOCALITY_NAME            ,
          LOCALITY_COUNTY               ,
          ACCESS_TANDEM            ,
          END_OFFICE               ,
          COC_TYPE            ,
          SPECIAL_SERVICE_CODE          ,
          RATE_CENTER_NAME_ABBREVIATION ,
          SWITCH_HOMING_ARRANGEMENT_IND ,
          TEST_LINE_NUMBER         ,
          THOUSANDS_BLOCK_POOLING_IND   ,
          DIALABLE_IND             ,
          PORTABLE_IND             ,
          RATE_CENTER_TYPE         ,
          COUNTRY                  ,
          AOCN                ,
          CATEGORY
     )

     VALUES (
          :NPANXXX                 ,
          :EFF_DATE           ,
          :EXP_DATE           ,
          :END_DATE           ,
          :E_STATUS_DATE           ,
          :LAST_MOD_DATE           ,
          :NPA                ,
          :NXX                ,
          :BLOCK_ID           ,
          :STATE_PROV_TERRITORY_COUNTRY ,
          :LATA_OF_SWITCH_LOCATION      ,
          :LATA_OF_RATE_CENTER_LOCATION ,
          :LATA_NAME               ,
          :OCN                ,
          :SWITCH                  ,
          :LOCALITY_NAME           ,
          :LOCALITY_COUNTY              ,
          :ACCESS_TANDEM           ,
          :END_OFFICE              ,
          :COC_TYPE           ,
          :SPECIAL_SERVICE_CODE         ,
          :RATE_CENTER_NAME_ABBREVIATION     ,
          :SWITCH_HOMING_ARRANGEMENT_IND     ,
          :TEST_LINE_NUMBER        ,
          :THOUSANDS_BLOCK_POOLING_IND  ,
          :DIALABLE_IND            ,
          :PORTABLE_IND            ,
          :RATE_CENTER_TYPE        ,
          :COUNTRY                 ,
          :AOCN                    ,
          :CATEGORY
     );

     .EXPORT RESET;
     .LOGOFF;
     .QUIT;

FASTLOAD Script, The output log is included below:

     sessions 1;

     errlimit 10000000;

     DATEFORM ANSIDATE;

     logon ${TenE_TER_MACHINE}/${TenE_MASTER_USER},${TenE_MASTER_PW};

     DATABASE  ${TenE_LERG_DB};

     SET RECORD FORMATTED ;

     DEFINE
          NPANXXX                       (CHAR(7)  ),
          EFF_DATE                      (DATE          ),
          EXP_DATE                      (DATE          ),
          END_DATE                      (DATE          ),
          E_STATUS_DATE                 (DATE          ),
          LAST_MOD_DATE                 (DATE          ),
          NPA                           (CHAR(3)  ),
          NXX                           (CHAR(3)  ),
          BLOCK_ID                      (CHAR(1)  ),
          STATE_PROV_TERRITORY_COUNTRY  (CHAR(2)  ),
          LATA_OF_SWITCH_LOCATION       (VARCHAR(5)    ),
          LATA_OF_RATE_CENTER_LOCATION  (VARCHAR(5)    ),
          LATA_NAME                     (VARCHAR(20)   ),
          OCN                           (CHAR(4)  ),
          SWITCH                        (CHAR(11) ),
          LOCALITY_NAME                 (VARCHAR(10)   ),
          LOCALITY_COUNTY               (VARCHAR(2)    ),
          ACCESS_TANDEM                 (CHAR(2)  ),
          END_OFFICE                    (CHAR(2)  ),
          COC_TYPE                      (CHAR(3)  ),
          SPECIAL_SERVICE_CODE          (CHAR(4)  ),
          RATE_CENTER_NAME_ABBREVIATION (VARCHAR(10)   ),
          SWITCH_HOMING_ARRANGEMENT_IND (CHAR(2)  ),
          TEST_LINE_NUMBER              (SMALLINT ),
          THOUSANDS_BLOCK_POOLING_IND   (CHAR(1)  ),
          DIALABLE_IND                  (CHAR(1)  ),
          PORTABLE_IND                  (CHAR(1)  ),
          RATE_CENTER_TYPE              (CHAR(1)  ),
          COUNTRY                       (CHAR(7)  ),
          AOCN                          (CHAR(4)  ),
          CATEGORY                      (CHAR(10)      )
          FILE=$FILE_NAME;

     SHOW;

     BEGIN LOADING t_temporal_npanxxx_lkup
           ERRORFILES t_temporal_npanxxx_lkup_et, t_temporal_npanxxx_lkup_uv;

     INSERT INTO T_TEMPORAL_NPANXXX_LKUP(
          NPANXXX                  ,
          EFF_DATE            ,
          EXP_DATE            ,
          END_DATE            ,
          E_STATUS_DATE            ,
          LAST_MOD_DATE            ,
          NPA                 ,
          NXX                 ,
          BLOCK_ID            ,
          STATE_PROV_TERRITORY_COUNTRY  ,
          LATA_OF_SWITCH_LOCATION       ,
          LATA_OF_RATE_CENTER_LOCATION  ,
          LATA_NAME           ,
          OCN                 ,
          SWITCH                   ,
          LOCALITY_NAME            ,
          LOCALITY_COUNTY               ,
          ACCESS_TANDEM            ,
          END_OFFICE               ,
          COC_TYPE            ,
          SPECIAL_SERVICE_CODE          ,
          RATE_CENTER_NAME_ABBREVIATION ,
          SWITCH_HOMING_ARRANGEMENT_IND ,
          TEST_LINE_NUMBER         ,
          THOUSANDS_BLOCK_POOLING_IND   ,
          DIALABLE_IND             ,
          PORTABLE_IND             ,
          RATE_CENTER_TYPE         ,
          COUNTRY                  ,
          AOCN                ,
          CATEGORY
     )

     VALUES (
          :NPANXXX                 ,
          :EFF_DATE           ,
          :EXP_DATE           ,
          :END_DATE           ,
          :E_STATUS_DATE           ,
          :LAST_MOD_DATE           ,
          :NPA                ,
          :NXX                ,
          :BLOCK_ID           ,
          :STATE_PROV_TERRITORY_COUNTRY ,
          :LATA_OF_SWITCH_LOCATION      ,
          :LATA_OF_RATE_CENTER_LOCATION ,
          :LATA_NAME               ,
          :OCN                ,
          :SWITCH                  ,
          :LOCALITY_NAME           ,
          :LOCALITY_COUNTY              ,
          :ACCESS_TANDEM           ,
          :END_OFFICE              ,
          :COC_TYPE           ,
          :SPECIAL_SERVICE_CODE         ,
          :RATE_CENTER_NAME_ABBREVIATION     ,
          :SWITCH_HOMING_ARRANGEMENT_IND     ,
          :TEST_LINE_NUMBER        ,
          :THOUSANDS_BLOCK_POOLING_IND  ,
          :DIALABLE_IND            ,
          :PORTABLE_IND            ,
          :RATE_CENTER_TYPE        ,
          :COUNTRY                 ,
          :AOCN                    ,
          :CATEGORY
     );


     END LOADING;

     LOGOFF;

Here is the BTEQ export output Log:

     BTEQ 08.02.01.00 Mon May 16 10:54:32 2005

     +---------+---------+---------+---------+---------+---------+---
     --.SESSION trans ansi
     .set session trans BTET;
     +---------+---------+---------+---------+---------+---------+---
     .logon TENETEST/xxx,

      *** Logon successfully completed.
      *** Transaction Semantics are BTET.
      *** Character Set Name is 'ASCII'.

      *** Total elapsed time was 2 seconds.

     +---------+---------+---------+---------+---------+---------+---
     .SET MAXERROR 08
     +---------+---------+---------+---------+---------+---------+---
     DATABASE LERG_2005_05;

      *** New default database accepted.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+---
     --COMMIT WORK;
     --.SET RECORDMODE ON;
     --.SET FORMAT OFF;
     .EXPORT DATA FILE=T_TEMPORAL_NPANXXX_LKUP.exp
      *** To reset export, type .EXPORT RESET
     +---------+---------+---------+---------+---------+---------+---
     SELECT * FROM T_TEMPORAL_NPANXXX_LKUP sample 1000;

      *** Success, Stmt# 1 ActivityCount = 1000
      *** Query completed. 1000 rows found. 31 columns returned.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+---
     .EXPORT RESET
      *** Output returned to console.
     +---------+---------+---------+---------+---------+---------+---
     .LOGOFF
      *** You are now logged off from the DBC.
     +---------+---------+---------+---------+---------+---------+---
     .QUIT


     The BTEQ import Log:

     BTEQ 08.02.01.00 Mon May 16 11:22:19 2005

     +---------+---------+---------+---------+---------+---------+---
     --.SESSION trans ansi
     .set session trans BTET;
     +---------+---------+---------+---------+---------+---------+---
     .SET SESSIONS 10;
     +---------+---------+---------+---------+---------+---------+---
     .logon TENETEST/TenE,

      *** Logon successfully completed.
      *** 10 Sessions logged on.
      *** Transaction Semantics are BTET.
      *** Character Set Name is 'ASCII'.

      *** Total elapsed time was 3 seconds.

     +---------+---------+---------+---------+---------+---------+---
     .SET REPEATSTOP ON;
     +---------+---------+---------+---------+---------+---------+---

     .REPEAT 10
     +---------+---------+---------+---------+---------+---------+---
     .SET MAXERROR 01;
     +---------+---------+---------+---------+---------+---------+---

     .REPEAT 10
     +---------+---------+---------+---------+---------+---------+---
     DATABASE eMMediate_table;
      *** Starting at Mon May 16 11:22:22 2005


      *** Ok, Session 43504, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43496, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43500, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43502, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43503, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43498, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43505, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43497, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43501, Request 3, Statement# 1
      *** New default database accepted.

      *** Ok, Session 43499, Request 3, Statement# 1
      *** New default database accepted.

      *** Finished at Mon May 16 11:22:22 2005
      *** Total number of statements: 10,  Accepted : 10,  Rejected : 0

      *** Total elapsed time was 1 second.

      *** Total requests sent to the DBC = 10
      *** Successful requests per second = 10.000

     +---------+---------+---------+---------+---------+---------+---

     .REPEAT 10
     +---------+---------+---------+---------+---------+---------+---
     .SET QUIET ON;
      *** Type QUIET OFF; to resume output.
     +---------+---------+---------+---------+---------+---------+---

     .REPEAT 10
     +---------+---------+---------+---------+---------+---------+---
     .SET TIMEMSG DEFAULT
     +---------+---------+---------+---------+---------+---------+---

     --COMMIT WORK;
     DELETE FROM T_TEMPORAL_NPANXXX_LKUP ALL;
      *** Starting at Mon May 16 11:22:22 2005


      *** Finished at Mon May 16 11:22:22 2005
      *** Total number of statements: 10,  Accepted : 10,  Rejected : 0

      *** Total elapsed time was 1 second.

      *** Total requests sent to the DBC = 10
      *** Successful requests per second = 10.000

     +---------+---------+---------+---------+---------+---------+---

     .IMPORT DATA FILE=T_TEMPORAL_NPANXXX_LKUP.exp;
     +---------+---------+---------+---------+---------+---------+---
     .REPEAT *;
     +---------+---------+---------+---------+---------+---------+---
     USING
     NPANXXX    (CHAR(7) ),
     EFF_DATE   (DATE   ),
     EXP_DATE   (DATE   ),
     END_DATE   (DATE   ),
     E_STATUS_DATE   (DATE   ),
     LAST_MOD_DATE   (DATE   ),
     NPA    (CHAR(3) ),
     NXX    (CHAR(3) ),
     BLOCK_ID   (CHAR(1) ),
     STATE_PROV_TERRITORY_COUNTRY (CHAR(2) ),
     LATA_OF_SWITCH_LOCATION  (VARCHAR(5) ),
     LATA_OF_RATE_CENTER_LOCATION (VARCHAR(5) ),
     LATA_NAME   (VARCHAR(20) ),
     OCN    (CHAR(4) ),
     SWITCH    (CHAR(11) ),
     LOCALITY_NAME   (VARCHAR(10) ),
     LOCALITY_COUNTY   (VARCHAR(2) ),
     ACCESS_TANDEM   (CHAR(2) ),
     END_OFFICE   (CHAR(2) ),
     COC_TYPE   (CHAR(3) ),
     SPECIAL_SERVICE_CODE  (CHAR(4) ),
     RATE_CENTER_NAME_ABBREVIATION (VARCHAR(10) ),
     SWITCH_HOMING_ARRANGEMENT_IND (CHAR(2) ),
     TEST_LINE_NUMBER  (SMALLINT ),
     THOUSANDS_BLOCK_POOLING_IND (CHAR(1) ),
     DIALABLE_IND   (CHAR(1) ),
     PORTABLE_IND   (CHAR(1) ),
     RATE_CENTER_TYPE  (CHAR(1) ),
     COUNTRY    (CHAR(7) ),
     AOCN    (CHAR(4) ),
     CATEGORY   (CHAR(10)  )
     INSERT INTO T_TEMPORAL_NPANXXX_LKUP (
     NPANXXX    ,
     EFF_DATE   ,
     EXP_DATE   ,
     END_DATE   ,
     E_STATUS_DATE   ,
     LAST_MOD_DATE   ,
     NPA    ,
     NXX    ,
     BLOCK_ID   ,
     STATE_PROV_TERRITORY_COUNTRY ,
     LATA_OF_SWITCH_LOCATION  ,
     LATA_OF_RATE_CENTER_LOCATION ,
     LATA_NAME   ,
     OCN    ,
     SWITCH    ,
     LOCALITY_NAME   ,
     LOCALITY_COUNTY   ,
     ACCESS_TANDEM   ,
     END_OFFICE   ,
     COC_TYPE   ,
     SPECIAL_SERVICE_CODE  ,
     RATE_CENTER_NAME_ABBREVIATION ,
     SWITCH_HOMING_ARRANGEMENT_IND ,
     TEST_LINE_NUMBER  ,
     THOUSANDS_BLOCK_POOLING_IND ,
     DIALABLE_IND   ,
     PORTABLE_IND   ,
     RATE_CENTER_TYPE  ,
     COUNTRY    ,
     AOCN    ,
     CATEGORY
     )
     VALUES (
     :NPANXXX    ,
     :EFF_DATE   ,
     :EXP_DATE   ,
     :END_DATE   ,
     :E_STATUS_DATE   ,
     :LAST_MOD_DATE   ,
     :NPA    ,
     :NXX    ,
     :BLOCK_ID   ,
     :STATE_PROV_TERRITORY_COUNTRY ,
     :LATA_OF_SWITCH_LOCATION  ,
     :LATA_OF_RATE_CENTER_LOCATION ,
     :LATA_NAME   ,
     :OCN    ,
     :SWITCH    ,
     :LOCALITY_NAME   ,
     :LOCALITY_COUNTY   ,
     :ACCESS_TANDEM   ,
     :END_OFFICE   ,
     :COC_TYPE   ,
     :SPECIAL_SERVICE_CODE  ,
     :RATE_CENTER_NAME_ABBREVIATION ,
     :SWITCH_HOMING_ARRANGEMENT_IND ,
     :TEST_LINE_NUMBER  ,
     :THOUSANDS_BLOCK_POOLING_IND ,
     :DIALABLE_IND   ,
     :PORTABLE_IND   ,
     :RATE_CENTER_TYPE  ,
     :COUNTRY    ,
     :AOCN    ,
     :CATEGORY
     );
     *** Starting Row 0 at Mon May 16 11:49:20 2005

      *** Starting Row 100 at Mon May 16 11:49:22 2005

      *** Starting Row 200 at Mon May 16 11:49:23 2005

      *** Starting Row 300 at Mon May 16 11:49:25 2005

      *** Starting Row 400 at Mon May 16 11:49:26 2005

      *** Starting Row 500 at Mon May 16 11:49:27 2005

      *** Starting Row 600 at Mon May 16 11:49:28 2005

      *** Starting Row 700 at Mon May 16 11:49:29 2005

      *** Starting Row 800 at Mon May 16 11:49:30 2005

      *** Starting Row 900 at Mon May 16 11:49:31 2005

      *** Starting Row 1000 at Mon May 16 11:49:32 2005

      *** Warning: Out of data.
      *** Finished at input row 1000 at Mon May 16 11:49:32 2005
      *** Total number of statements: 1000,  Accepted : 1000,  Rejected : 0

      *** Total elapsed time was 12 seconds.

     +---------+---------+---------+---------+---------+---------+---
     .EXPORT RESET;
      *** Output returned to console.
     +---------+---------+---------+---------+---------+---------+---
     .LOGOFF;
      *** You are now logged off from the DBC.
     +---------+---------+---------+---------+---------+---------+---
     .QUIT;
      *** Exiting BTEQ...
      *** RC (return code) = 0

FASTLOAD LOG:

     -------------------------------------------------------------------
     -                                                                 -
     -          FASTLOAD UTILITY     VERSION 07.05.02.000              -
     -                                                                 -
     -------------------------------------------------------------------

     -------------------------------------------------------------------
     -                                                                 -
     -          PLATFORM WIN32                                         -
     -                                                                 -
     -------------------------------------------------------------------

     **** 11:27:29 Processing starting at: Mon May 16 11:27:29 2005


     0001    sessions 1;

     **** 11:27:29 FDL4866 SESSIONS command accepted


     0002    errlimit 10000000;

     **** 11:27:29 Error limit set to: 10000000


     0003    DATEFORM ANSIDATE;

     **** 11:27:29 Date/Time Format set to ANSIDATE
     **** 11:27:29 Command completed successfully


     -------------------------------------------------------------------
     -                                                                 -
     -          Logon/Connection                                       -
     -                                                                 -
     -------------------------------------------------------------------

     0004    logon TENETEST/XXX,

     **** 11:27:32 Current CLI or RDBMS allows maximum row size: 64K
     **** 11:27:32 Character set for this job: ASCII
     **** 11:27:32 Number of FastLoad sessions requested = 1
     **** 11:27:32 Number of FastLoad sessions connected = 1
     **** 11:27:32 FDL4808 LOGON successful


     0005    DATABASE  eMMediate_table;

     **** 11:27:32 Command completed successfully


     0006    SET RECORD FORMATTED ;

     **** 11:27:32 Now set to read 'FORMATTED' records
     **** 11:27:32 Command completed successfully


     0007    DEFINE
                     NPANXXX                         (CHAR(7)        ),
                     EFF_DATE                        (DATE           ),
                     EXP_DATE                        (DATE           ),
                     END_DATE                        (DATE           ),
                     E_STATUS_DATE                   (DATE           ),
                     LAST_MOD_DATE                   (DATE           ),
                     NPA                             (CHAR(3)        ),
                     NXX                             (CHAR(3)        ),
                     BLOCK_ID                        (CHAR(1)        ),
                     STATE_PROV_TERRITORY_COUNTRY    (CHAR(2)        ),
                     LATA_OF_SWITCH_LOCATION         (VARCHAR(5)     ),
                     LATA_OF_RATE_CENTER_LOCATION    (VARCHAR(5)     ),
                     LATA_NAME                       (VARCHAR(20)    ),
                     OCN                             (CHAR(4)        ),
                     SWITCH                          (CHAR(11)       ),
                     LOCALITY_NAME                   (VARCHAR(10)    ),
                     LOCALITY_COUNTY                 (VARCHAR(2)     ),
                     ACCESS_TANDEM                   (CHAR(2)        ),
                     END_OFFICE                      (CHAR(2)        ),
                     COC_TYPE                        (CHAR(3)        ),
                     SPECIAL_SERVICE_CODE            (CHAR(4)        ),
                     RATE_CENTER_NAME_ABBREVIATION   (VARCHAR(10)    ),
                     SWITCH_HOMING_ARRANGEMENT_IND   (CHAR(2)        ),
                     TEST_LINE_NUMBER                (SMALLINT       ),
                     THOUSANDS_BLOCK_POOLING_IND     (CHAR(1)        ),
                     DIALABLE_IND                    (CHAR(1)        ),
                     PORTABLE_IND                    (CHAR(1)        ),
                     RATE_CENTER_TYPE                (CHAR(1)        ),
                     COUNTRY                         (CHAR(7)        ),
                     AOCN                            (CHAR(4)        ),
                     CATEGORY                        (CHAR(10)       )
                     FILE=T_TEMPORAL_NPANXXX_LKUP.exp;

     **** 11:27:32 FDL4803 DEFINE statement processed


     0008    SHOW;

     FILE = T_TEMPORAL_NPANXXX_LKUP.exp
     NPANXXX                          OFFSET =      0 LEN =     7 CHAR
     EFF_DATE                         OFFSET =      7 LEN =    10 CHAR
     EXP_DATE                         OFFSET =     17 LEN =    10 CHAR
     END_DATE                         OFFSET =     27 LEN =    10 CHAR
     E_STATUS_DATE                    OFFSET =     37 LEN =    10 CHAR
     LAST_MOD_DATE                    OFFSET =     47 LEN =    10 CHAR
     NPA                              OFFSET =     57 LEN =     3 CHAR
     NXX                              OFFSET =     60 LEN =     3 CHAR
     BLOCK_ID                         OFFSET =     63 LEN =     1 CHAR
     STATE_PROV_TERRITORY_COUNTRY     OFFSET =     64 LEN =     2 CHAR
     LATA_OF_SWITCH_LOCATION          OFFSET =     66 LEN =     5 VARCHAR
     LATA_OF_RATE_CENTER_LOCATION     OFFSET =     73 LEN =     5 VARCHAR
     LATA_NAME                        OFFSET =     80 LEN =    20 VARCHAR
     OCN                              OFFSET =    102 LEN =     4 CHAR
     SWITCH                           OFFSET =    106 LEN =    11 CHAR
     LOCALITY_NAME                    OFFSET =    117 LEN =    10 VARCHAR
     LOCALITY_COUNTY                  OFFSET =    129 LEN =     2 VARCHAR
     ACCESS_TANDEM                    OFFSET =    133 LEN =     2 CHAR
     END_OFFICE                       OFFSET =    135 LEN =     2 CHAR
     COC_TYPE                         OFFSET =    137 LEN =     3 CHAR
     SPECIAL_SERVICE_CODE             OFFSET =    140 LEN =     4 CHAR
     RATE_CENTER_NAME_ABBREVIATION    OFFSET =    144 LEN =    10 VARCHAR
     SWITCH_HOMING_ARRANGEMENT_IND    OFFSET =    156 LEN =     2 CHAR
     TEST_LINE_NUMBER                 OFFSET =    158 LEN =     2 SMALLINT
     THOUSANDS_BLOCK_POOLING_IND      OFFSET =    160 LEN =     1 CHAR
     DIALABLE_IND                     OFFSET =    161 LEN =     1 CHAR
     PORTABLE_IND                     OFFSET =    162 LEN =     1 CHAR
     RATE_CENTER_TYPE                 OFFSET =    163 LEN =     1 CHAR
     COUNTRY                          OFFSET =    164 LEN =     7 CHAR
     AOCN                             OFFSET =    171 LEN =     4 CHAR
     CATEGORY                         OFFSET =    175 LEN =    10 CHAR
     TOTAL RECORD LENGTH = 185


     0009    BEGIN LOADING t_temporal_npanxxx_lkup
                   ERRORFILES t_temporal_npanxxx_lkup_et, t_temporal_npanxxx_lkup_uv;

     **** 11:27:32 Number of AMPs available: 4
     **** 11:27:32 BEGIN LOADING COMPLETE


     -------------------------------------------------------------------
     -                                                                 -
     -          Insert Phase                                           -
     -                                                                 -
     -------------------------------------------------------------------

     0010    INSERT INTO T_TEMPORAL_NPANXXX_LKUP(
                NPANXXX                         ,
                EFF_DATE                        ,
                EXP_DATE                        ,
                END_DATE                        ,
                E_STATUS_DATE                   ,
                LAST_MOD_DATE                   ,
                NPA                             ,
                NXX                             ,
                BLOCK_ID                        ,
                STATE_PROV_TERRITORY_COUNTRY    ,
                LATA_OF_SWITCH_LOCATION         ,
                LATA_OF_RATE_CENTER_LOCATION    ,
                LATA_NAME                       ,
                OCN                             ,
                SWITCH                          ,
                LOCALITY_NAME                   ,
                LOCALITY_COUNTY                 ,
                ACCESS_TANDEM                   ,
                END_OFFICE                      ,
                COC_TYPE                        ,
                SPECIAL_SERVICE_CODE            ,
                RATE_CENTER_NAME_ABBREVIATION   ,
                SWITCH_HOMING_ARRANGEMENT_IND   ,
                TEST_LINE_NUMBER                ,
                THOUSANDS_BLOCK_POOLING_IND     ,
                DIALABLE_IND                    ,
                PORTABLE_IND                    ,
                RATE_CENTER_TYPE                ,
                COUNTRY                         ,
                AOCN                            ,
                CATEGORY
        )
        VALUES (
                :NPANXXX                                ,
                :EFF_DATE                       ,
                :EXP_DATE                       ,
                :END_DATE                       ,
                :E_STATUS_DATE                  ,
                :LAST_MOD_DATE                  ,
                :NPA                            ,
                :NXX                            ,
                :BLOCK_ID                       ,
                :STATE_PROV_TERRITORY_COUNTRY   ,
                :LATA_OF_SWITCH_LOCATION                ,
                :LATA_OF_RATE_CENTER_LOCATION   ,
                :LATA_NAME                      ,
                :OCN                            ,
                :SWITCH                         ,
                :LOCALITY_NAME                  ,
                :LOCALITY_COUNTY                        ,
                :ACCESS_TANDEM                  ,
                :END_OFFICE                     ,
                :COC_TYPE                       ,
                :SPECIAL_SERVICE_CODE           ,
                :RATE_CENTER_NAME_ABBREVIATION  ,
                :SWITCH_HOMING_ARRANGEMENT_IND  ,
                :TEST_LINE_NUMBER               ,
                :THOUSANDS_BLOCK_POOLING_IND    ,
                :DIALABLE_IND                   ,
                :PORTABLE_IND                   ,
                :RATE_CENTER_TYPE               ,
                :COUNTRY                                ,
                :AOCN                           ,
                :CATEGORY
        );

     **** 11:27:32 Number of recs/msg: 355
     **** 11:27:32 Starting to send to RDBMS with record 1
     **** 11:27:32 Bad file or data definition.
     **** 11:27:32 The length of: LATA_OF_SWITCH_LOCATION in row: 1 was
                   greater than defined.
                   Defined: 5, Received: 13878
     -------------------------------------------------------------------
     -                                                                 -
     -          Logoff/Disconnect                                      -
     -                                                                 -
     -------------------------------------------------------------------

     **** 11:27:32 Logging off all sessions
     **** 11:27:33 Total processor time used = '0.109375 Seconds'
          .        Start : Mon May 16 11:27:29 2005
          .        End   : Mon May 16 11:27:33 2005
          .        Highest return code encountered = '12'.
     **** 11:27:33 FastLoad Paused

Don Iuppa
Engineering Development Director
10eSolutions LLC



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016