Fastlload: maximum columns

Tools & Utilities
Enthusiast

Fastlload: maximum columns

Hi

I was trying to import my data by fastload. I have sample data that has 1000 columns (actually they are test data and need to have large number of columns) and I am using teradata demo version. But it seems that fastload goes to infinite loop with the importing script. But it works with test data that has 500 columns. If anyone know whether the limitation is inside demo version, and it will work in the actual version.

Here is the output from fasload:

===================================================================
= =
= FASTLOAD UTILITY VERSION 07.05.01.000 =
= =
===================================================================

===================================================================
= =
= PLATFORM WIN32 =
= =
===================================================================

**** 16:16:06 Processing starting at: Thu Oct 19 16:16:06 2006

0001 SESSIONS 10;

**** 16:16:06 FDL4866 SESSIONS command accepted

===================================================================
= =
= Logon/Connection =
= =
===================================================================

0002 LOGON demotdat/dbc,

**** 16:16:06 Current CLI or RDBMS allows maximum row size: 64K
**** 16:16:06 Character set for this job: ASCII
**** 16:16:07 Number of FastLoad sessions requested = 10
**** 16:16:07 Number of FastLoad sessions connected = 2
**** 16:16:07 FDL4808 LOGON successful

0003 DATABASE test2;

**** 16:16:07 Command completed successfully

/*********************************************/*
0004 SHOW VERSIONS;

FastLoad Version 07.05.01.000 for Win 32 running Windows Sockets
FastLoad : 07.05.01.03
FastCmds : 07.04.00.06
FastIO : 07.04.00.01
FastMBCS : 07.05.01.01
FastNtfy : 07.02.00.01
FastPars : 07.04.00.01
FastSQL : 07.05.01.03
FastUtil : 07.05.00.02
PMPROCS : 02.00.00.04
PMRWFMT : 02.00.00.02
PMTRCE : 02.00.00.02
PMMM : 02.00.00.01
PMHEXDMP : 02.00.00.01
PMUNXDSK : 02.00.00.03
CLIV2 : 04.07.00.26
MTDP : 04.07.00.11
MOSIos : 04.07.00.09
MOSIDEP : 04.07.00.05
OSENCRYPT : N/A
OSERR : 04.07.00.03

FastLoad linking date: Sep 13 2002

0005 SHOW;

TOTAL RECORD LENGTH = 0

0006 SET RECORD VARTEXT ";";

**** 16:16:07 Now set to read 'Variable-Length Text' records
**** 16:16:07 Delimiter character is set to ';'
**** 16:16:07 Command completed successfully

0007 drop table fld_err_tb1;

**** 16:16:07 RDBMS error 3807: Table/view/trigger/procedure
'fld_err_tb1' does not exist.

0008 drop table fld_err_tb2;

**** 16:16:07 RDBMS error 3807: Table/view/trigger/procedure
'fld_err_tb2' does not exist.

0009 drop table ints10k_1000;

**** 16:16:07 RDBMS error 3807: Table/view/trigger/procedure
'ints10k_1000' does not exist.

0010 CREATE SET TABLE ints10k_1000(
int_1 INTEGER DEFAULT NULL,
int_2 INTEGER DEFAULT NULL,
int_3 INTEGER DEFAULT NULL,
int_4 INTEGER DEFAULT NULL,
int_182 INTEGER DEFAULT NULL,
int_183 INTEGER DEFAULT NULL,
int_184 INTEGER DEFAULT NULL,
int_185 INTEGER DEFAULT NULL,
....,
int_1000 INTEGER DEFAULT NULL
);

**** 16:16:13 Command completed successfully

0011 DEFINE
int_1(varchar(11), nullif ='\N'),
int_2(varchar(11), nullif ='\N'),
int_3(varchar(11), nullif ='\N'),
int_4(varchar(11), nullif ='\N'),
int_5(varchar(11), nullif ='\N'),
int_589(varchar(11), nullif ='\N'),
int_590(varchar...
.......
...
----->
-----> it goes infinite loop here, run the define statements again and again, does not complete define statement.