Archives of the TeradataForum

Message Posted: Wed, 11 Jul 2007 @ 15:30:31 GMT

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

I am getting an error running the following SQL in bteq, but I don't get an error in SQL Assistant.

     SELECT length(tracking_no_merge)
     FROM orderstat.tracking_no_TMP
     WHERE length(tracking_no_merge) > 200;

     *** Failure 3706 Syntax error: Data Type "tracking_no_merge"
             does not match a Defined Type name.

The SQL seems pretty simple. Below is the syntax of the table if it helps.

I looked in the messages manual but the error didn't seem to match the one listed in the manual.

Any help would be greatly appreciated.

Thanks

Craig

     CREATE MULTISET TABLE orderstat.tracking_no_TMP ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           ConfirmationNum VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
           linenum VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
           tracking_no_merge VARCHAR(5000) CHARACTER SET LATIN
                  NOT CASESPECIFIC)
     PRIMARY INDEX ( ConfirmationNum );

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