Archives of the TeradataForum

Message Posted: Thu, 26 Feb 2009 @ 23:26:08 GMT

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

Hello,

I am getting an error while running fastload. Pls check belw fast load script and table DDL. Not sure why I am getting this error:

     **** 16:01:20 FDL4822 DEFINE statement rejected.
     **** 16:01:20 Invalid type for: INS_DTTM

Did I missed some thing here.

Your assistance is greatly appreciated!

FastLoad Script:

     .LOGTABLE PARTY_ROLE_fload ;
     LOGON TELCDB99/MDGS99,mdgs99;
     BEGIN LOADING PARTY_ROLE
     ERRORFILES SErr1, SErr2;

     set record unformatted;

     DEFINE
     PARTY_ROLE_CD (CHAR(6)),
     DESC_TXT (VARCHAR(1000)),
     INS_DTTM (TIMESTAMP(0)),
     LAST_UPDT_DTTM (TIMESTAMP(0)),
     LAST_ACTION_TP_CD (CHAR(1))

     FILE=C:\Rao\PARTY_ROLE.txt;

     show;

     begin loading PARTY_ROLE ERRORFILES SErr1, SErr2;

     INSERT INTO EADWCore.PARTY_ROLE VALUES (
     :PARTY_ROLE_CD
     ,:DESC_TXT
     ,:INS_DTTM
     ,:LAST_UPDT_DTTM
     ,:LAST_ACTION_TP_CDTS
     );

     END LOADING;
     LOGOFF;

Table DDL:

     PARTY_ROLE_CD CHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Party Role
     Cd' NOT NULL,
     DESC_TXT VARCHAR(1000) CHARACTER SET LATIN NOT CASESPECIFIC TITLE
     'Description Text',
     INS_DTTM TIMESTAMP(0) TITLE 'Insert Dttm' NOT NULL,
     LAST_UPDT_DTTM TIMESTAMP(0) TITLE 'Last Update Dttm',
     LAST_ACTION_TP_CD CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Last
     Action Type Cd' NOT NULL

LOG:

     0003 BEGIN LOADING PARTY_ROLE
     ERRORFILES SErr1, SErr2;

     **** 16:01:20 FastLoad is continuing a multifile job
     **** 16:01:20 Number of AMPs available: 9
     **** 16:01:20 BEGIN LOADING COMPLETE


     0004 set record unformatted;

     **** 16:01:20 Now set to read 'UNFORMATTED' records
     **** 16:01:20 Command completed successfully


     0005 DEFINE
     PARTY_ROLE_CD (CHAR(6)),
     DESC_TXT (VARCHAR(1000)),
     INS_DTTM (TIMESTAMP(0)),
     LAST_UPDT_DTTM (TIMESTAMP(0)),
     LAST_ACTION_TP_CD (CHAR(1))

     FILE=C:\Rao\PARTY_ROLE.txt;

     **** 16:01:20 FDL4822 DEFINE statement rejected.
     **** 16:01:20 Invalid type for: INS_DTTM
     --------------------------------------------------------
     =
     = Logoff/Disconnect
     =
     --------------------------------------------------------

     **** 16:01:20 Logging off all sessions
     **** 16:01:21 Total processor time used = '0.703125 Seconds'
     . Start : Thu Feb 26 16:01:16 2009
     . End : Thu Feb 26 16:01:21 2009
     . Highest return code encountered = '8'.

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