Here is what I have that is causing the error........
CREATE MULTISET TABLE DLAB_MARKETING.Click,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
PRIMARY INDEX (AccountID);
Te problem is with the column name TriggeredSendDefinitionObjectID , this has more than 30 characters.
3737 - Name is longer than 30 characters.
Hi my table name is 26 characters and my column names are not more than 30 chars.
but I got this error :[Error 3737] [SQLState 42000] Name requires more than 30 bytes in LATIN
Your tablename is probably too long, when you check http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABIIEAG you'll findJDBC FastLoad creates two temporary error tables with the following naming convention: ._ERR_1 and ._ERR_2
andThe name of the destination table in the Teradata Database that is to be used by JDBC FastLoad CSV must not exceed 24 characters because of the name of the two error tables created by JDBC FastLoad CSV
If this was a standard FastLoad i would simply add ERRORTABLES and use my own error table names, but this seems not to be available in JDBC FastLoad. So your only option is to create the table with a shorter name, FastLoad it and thensubmit a RENAME TABLE.
My Largets column name is 29 char long. still i am facing the same error.
SELECT Failed 3737: Name requires more than 30 bytes in LATIN internal form.thanks.
Name requires more than 30 bytes in LATIN internal form.
Based on the error message this seems to be a SELECT, could you show it (or at least the column names/aliases used)?