|
|
|
 |
 |
Archives of the TeradataForumMessage Posted: Fri, 27 May 2005 @ 19:45:18 GMT
Hi all, i am working on a Fast load script to Load data from a text file "data.txt". I am getting the following problem. The Fast load is getting paused with return code 12, which is a fatal error. Can anybody tell me where i am going wrong?? Thanks Pratap
C:\PROGRA~1\NCR\TERADA~1\bin>fastload < fload_script
-------------------------------------------------------------------
- -
- FASTLOAD UTILITY VERSION 07.04.00 -
- -
-------------------------------------------------------------------
**** 13:44:22 Processing starting at: Fri May 27 13:44:22 2005
MOSI: Can't access C:\Documents and Settings\Pratap\Desktop - logging disabled
**** 13:44:22 Character set has been set to: ASCII
**** 13:44:22 Tenacity Enabled: 3 hour(s)
**** 13:44:22 Sleep Minutes Set: 5 minute(s)
**** 13:44:22 Buffer size has been set to 48 KBytes
0001 SHOW VERSION;
FastLoad Version 07.04.00 for Win 32 running Windows Sockets
FastLoad : 07.04.00.03
FastCmds : 07.04.00.06
FastIO : 07.04.00.01
FastMBCS : 07.04.00.03
FastNtfy : 07.02.00.01
FastPars : 07.04.00.01
FastSQL : 07.04.00.08
FastUtil : 07.04.00.02
PMPROCS : 01.04.00.03
PMRWFMT : 01.04.00.03
PMTRCE : 01.01.00.01
PMMM : 01.01.00.01
PMHEXDMP : 01.01.00.01
PMUNXDSK : 01.04.00.02
CLIV2 : 04.06.00.08
MTDP : 04.06.00.05
MOSIos : 04.06.00.05
MOSIDEP : 04.06.00.01
OSENCRYPT : N/A
OSERR : 04.05.00.00
FastLoad linking date: Jun 20 2001
0002 SESSION 2;
**** 13:44:22 FDL4800 Invalid FastLoad statement
0003 ERRLIMIT 25;
**** 13:44:22 Error limit set to: 25
-------------------------------------------------------------------
- -
- Logon/Connection -
- -
-------------------------------------------------------------------
0004 LOGON teradata/pratap,
**** 13:44:24 Current CLI or RDBMS allows maximum row size: 64K
**** 13:44:24 Character set for this job: ASCII
**** 13:44:27 Number of FastLoad sessions connected = 4
**** 13:44:27 FDL4808 LOGON successful
0005 DATABASE Fast;
**** 13:44:27 Command completed successfully
0006 Drop Table test;
**** 13:44:29 Command completed successfully
0007 drop table err_1;
**** 13:44:30 Command completed successfully
0008 drop table err_2;
**** 13:44:31 Command completed successfully
0009 CREATE TABLE TEST ( A char(2), B char(2), C char(2), D char(2), M integer);
**** 13:44:35 Command completed successfully
0010 set record unformatted;
**** 13:44:35 Now set to read 'UNFORMATTED' records
**** 13:44:35 Command completed successfully
0011 define delim0(char(1)), A(char(2)),
delim1(char(1)), B(char(2)),
delim2(char(1)), C(char(2)),
delim3(char(1)), D(char(2)),
delim4(char(1)), M(char(2)),
newlinechar(char(1))
file = Dataset.txt;
**** 13:44:35 FDL4803 DEFINE statement processed
0012 show;
FILE = Dataset.txt
DELIM0 OFFSET = 0 LEN = 1 CHAR
A OFFSET = 1 LEN = 2 CHAR
DELIM1 OFFSET = 3 LEN = 1 CHAR
B OFFSET = 4 LEN = 2 CHAR
DELIM2 OFFSET = 6 LEN = 1 CHAR
C OFFSET = 7 LEN = 2 CHAR
DELIM3 OFFSET = 9 LEN = 1 CHAR
D OFFSET = 10 LEN = 2 CHAR
DELIM4 OFFSET = 12 LEN = 1 CHAR
M OFFSET = 13 LEN = 2 CHAR
NEWLINECHAR OFFSET = 15 LEN = 1 CHAR
TOTAL RECORD LENGTH = 16
0013 begin loading Fast.Test errorfiles err_1, err_2;
**** 13:44:38 Number of AMPs available: 4
**** 13:44:38 BEGIN LOADING COMPLETE
-------------------------------------------------------------------
- -
- Insert Phase -
- -
-------------------------------------------------------------------
0014 insert into Fast.Test (A,B,C,D,M) Values (:A,:B,:C,:D,:M);
**** 13:44:38 Number of recs/msg: 2230
**** 13:44:38 Starting to send to RDBMS with record 1
**** 13:44:38 EOF encountered while processing record
Record: 60
Column: DELIM2
-------------------------------------------------------------------
- -
- Logoff/Disconnect -
- -
-------------------------------------------------------------------
**** 13:44:38 Logging off all sessions
**** 13:44:39 Total processor time used = '0.109375 Seconds'
. Start : Fri May 27 13:44:22 2005
. End : Fri May 27 13:44:39 2005
. Highest return code encountered = '12'.
**** 13:44:39 FastLoad Paused
C:\PROGRA~1\NCR\TERADA~1\bin>
Here is the Fast load script .... Fload_script file:
SHOW VERSION;
SESSION 2;
ERRLIMIT 25;
LOGON teradata/pratap,password;
DATABASE Fast;
Drop Table test;
drop table err_1;
drop table err_2;
CREATE TABLE TEST ( A char(2), B char(2), C char(2), D char(2), M integer);
set record unformatted;
define delim0(char(1)), A(char(2)),
delim1(char(1)), B(char(2)),
delim2(char(1)), C(char(2)),
delim3(char(1)), D(char(2)),
delim4(char(1)), M(char(2)),
newlinechar(char(1))
file = Dataset.txt;
show;
begin loading Fast.Test errorfiles err_1, err_2;
insert into Fast.Test (A,B,C,D,M) Values (:A,:B,:C,:D,:M);
end loading;
logoff;
A Sample Text File.....Data.txt
Text File: (sample)
|a2 |b3 |c3 |d1 |9
|a4 |b3 |c3 |d1 |9
|a4 |b3 |c4 |d2 |9
|a3 |b1 |c2 |d1 |3
|a2 |b1 |c4 |d2 |2
|a3 |b1 |c2 |d2 |8
| ||||||||||||||||||||||||||||||||||||||||||||||
| | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
| Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
