Archives of the TeradataForum
Message Posted: Wed, 04 Jan 2006 @ 14:20:06 GMT
| Subj: | | Re: Help required with Mload! |
| |
| From: | | Jay.Munshi |
Hi Jason,
Thanks a Million for responding.
You are right, the table creation was not the error. I atleast could get a record in there.
Now making the slightly to resemble the real life scenario I am trying to import the following content
21|Creighton Bryden|5000
1|Rudolph Cheng|5000
3|Steve Willis|2000
4|Cyril Soga| 15000
5|Irene Bright|1000
With the following script.
.Logtable Logtable003;
.Logon dbc/sdm,sdm;
create table emp (empno integer format '9(2)',Ename varchar(20),sal
integer format '9(5)');
.Begin Import mload tables Emp;
.Layout Layoutname;
.Field Empno 1 varchar(2);
.Field Ename 2 varchar(20);
.Field Sal 3 varchar(5);
.DML Label inslbl;
insert into emp.*;
.Import Infile c:\multiload\insert.input
format vartext '|'
Layout LayoutName
Apply inslbl;
.End Mload;
.Logoff;
Following are the details of the tables created during the load.
select * from et_emp;
select * from et_emp;
$
*** Failure 3798 A column or character expression is larger than the max size.
Statement# 1, Info =0
*** Total elapsed time was 1 second.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
select * from logtable003
;
select * from logtable003
;
*** Query completed. 5 rows found. 22 columns returned.
*** Total elapsed time was 1 second.
LogType Seq ReqRC ReqType ReqLen ReqMsg
----------- ----------- ----------- ----------- ----------- --------
130 1 ? ? ? ?
0 ? ? ? ? ?
1 1 0 6 92 ?
130 1 ? ? ? ?
110 1 ? ? ? ?
BTEQ -- Enter your DBC/SQL request or BTEQ command:
select * from uv_emp;
select * from uv_emp;
*** Query completed. No rows found.
*** Total elapsed time was 1 second.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
select * from wt_emp;
select * from wt_emp;
*** Query completed. No rows found.
*** Total elapsed time was 1 second.
Following is the logfile:
------------------------------------------------------------------------
= =
= MultiLoad Utility Release MLOD.07.07.01.000 =
= Platform WIN32 =
= =
------------------------------------------------------------------------
= =
= Copyright 1990-2005, NCR Corporation. ALL RIGHTS RESERVED. =
= =
------------------------------------------------------------------------
**** 19:29:25 UTY2411 Processing start date: WED JAN 04, 2006
------------------------------------------------------------------------
= =
= Logon/Connection =
= =
------------------------------------------------------------------------
0001 .Logtable Logtable003;
0002 .Logon dbc/sdm,;
**** 19:29:27 UTY8400 Default character set: ASCII
**** 19:29:27 UTY8400 Current RDBMS has interval support
**** 19:29:27 UTY8400 Maximum supported buffer size: 1M
**** 19:29:27 UTY8400 Data Encryption supported by RDBMS server
**** 19:29:28 UTY6211 A successful connect was made to the RDBMS.
**** 19:29:28 UTY6217 Logtable 'SDM.Logtable003' has been created.
------------------------------------------------------------------------
= =
= Processing Control Statements =
= =
------------------------------------------------------------------------
0003 create table emp (empno integer format '9(2)',Ename varchar(20),sal integer
format '9(5)');
**** 19:29:29 UTY1016 'CREATE' request successful.
0004 .Begin Import mload tables Emp;
------------------------------------------------------------------------
= =
= Processing MultiLoad Statements =
= =
------------------------------------------------------------------------
0005 .Layout Layoutname;
0006 .Field Empno 1 varchar(2);
0007 .Field Ename 2 varchar(20);
0008 .Field Sal 3 varchar(5);
0009 .DML Label inslbl;
0010 insert into emp.*;
0011 .Import Infile c:\multiload\insert.input
format vartext '|'
Layout LayoutName
Apply inslbl;
0012 .End Mload;
------------------------------------------------------------------------
= =
= MultiLoad Initial Phase =
= =
------------------------------------------------------------------------
**** 19:29:29 UTY0829 Options in effect for this MultiLoad import task:
. Sessions: One session per available amp.
. Checkpoint: 15 minute(s).
. Tenacity: 4 hour limit to successfully connect load sessions.
. Errlimit: No limit in effect.
. AmpCheck: In effect for apply phase transitions.
**** 19:29:29 UTY0817 MultiLoad submitting the following request:
Select NULL from SDM.Logtable003 where (LogType = 125) and (Seq = 1) and
(MloadSeq = 0);
**** 19:29:29 UTY0817 MultiLoad submitting the following request:
Select NULL from SDM.Logtable003 where (LogType = 120) and (Seq = 1);
**** 19:29:30 UTY0815 MLOAD session(s) connected: 2.
**** 19:29:30 UTY0817 MultiLoad submitting the following request:
BEGIN MLOAD Emp WITH INTERVAL;
**** 19:29:30 UTY0817 MultiLoad submitting the following request:
INS SDM.Logtable003 (LogType, Seq, MLoadSeq)VALUES(130, 1, 10);
**** 19:29:30 UTY0817 MultiLoad submitting the following request:
MLOAD Emp with WT_Emp errortables ET_Emp, UV_Emp;
------------------------------------------------------------------------
= =
= MultiLoad DML Transaction Phase =
------------------------------------------------------------------------
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
BT;
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
USING EMPNO(VARCHAR(2)), ENAME(VARCHAR(20)), SAL(VARCHAR(5)) insert into
emp
VALUES(:empno, :Ename, :sal);
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
INS SDM.Logtable003 (LogType, Seq, MLoadSeq)VALUES(130, 1, 20);
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
ET;
------------------------------------------------------------------------
= =
= MultiLoad Acquisition Phase =
= =
------------------------------------------------------------------------
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 19:29:31 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 19:29:33 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 19:29:34 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INSERT SDM.Logtable003 (Logtype, Seq, MLoadSeq,
MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4,
MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,MLoadCkpt) VALUES (110, 1,
0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, :Ckpt);
**** 19:29:34 UTY4203 Attempted to access out of range input data in field 'ENAME', file
'c:\multiload\insert.input',record number '1'.
**** 19:29:34 UTY1803 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:........ 1.......1
Apply conditions satisfied:.......... 0.......0
Candidate records not applied:....... 0.......0
Candidate records rejected:.......... 0.......0
------------------------------------------------------------------------
= =
= Logoff/Disconnect =
= =
------------------------------------------------------------------------
**** 19:29:35 UTY6212 A successful disconnect was made from the RDBMS.
**** 19:29:35 UTY2410 Total processor time used = '0.421875 Seconds'
. Start : 19:29:25 - WED JAN 04, 2006
. End : 19:29:35 - WED JAN 04, 2006
. Highest return code encountered = '12'.
Please help me identify the problem.
Thanking you in advance,
Jay Munshi
| 
