|
|
|
 |
 |
Archives of the TeradataForumMessage Posted: Mon, 16 May 2005 @ 16:08:05 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||
| | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
| Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
