Archives of the TeradataForum
Message Posted: Wed, 11 Jul 2007 @ 15:30:31 GMT
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.
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 );
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|