Archives of the TeradataForum

Message Posted: Thu, 19 Jan 2012 @ 08:09:52 GMT

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

Hi All,

We do data copy from prod to dev box using FEXP and FASTLOAD, while loading the table into DEV table its giving error as below.

     14:27:34 RDBMS error 3707: Syntax error, expected something like a
                   name or a Unicode delimited identifier or an
                   'UDFCALLNAME' keyword between ',' and the 'DOMAIN'
                   keyword

Please let me know how to avoid this error. what i know is the column (domain) should be in double quotes and its already there in defination.

FYI: I have used arcmain and completed the data copy, i need any solution other than arcmain.

Table defination:

     CREATE MULTISET TABLE IQSRD.AT_PTTREG ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           RECORD_TYPE CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           EVENT_TIMESTAMP TIMESTAMP(0),
           MSISDN VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           NAME VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           "DOMAIN" INTEGER,
           STATUS INTEGER,
           DATE_CREATED_DT DATE FORMAT 'YYYY-MM-DD',
           DATE_CREATED_TM TIME(0),
           DATE_UPDATED_DT DATE FORMAT 'YYYY-MM-DD',
           DATE_UPDATED_TM TIME(0),
           ANNIVERSARY_DT DATE FORMAT 'YYYY-MM-DD',
           ANNIVERSARY_TM TIME(0),
           FOLDER VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           open_dt DATE FORMAT 'YYYY-MM-DD' NOT NULL,
           close_dt DATE FORMAT 'YYYY-MM-DD' NOT NULL COMPRESS (DATE '2899-12-31'))
     PRIMARY INDEX ( MSISDN );

Thanks

Sridhar kola

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