IBM Support

Known Issue: Teradata load utilities (FastLoad, MultiLoad, Basic Teradata Query Facility) do not support delimited identifier column names.

Troubleshooting


Problem

Attempt to load to Teradata database failed, due to a delimited column name in the data to be loaded. Teradata load utilities do not support column names that include delimited identifiers.

Symptom

Error messages are displayed. For example:

MLOAD Error:
**** 18:14:53 UTY0817 MultiLoad submitting the following request:
USING DUMMY(VARCHAR(1)), COL1(VARCHAR(11)), "COL2(VARCHAR(32)) INSERT INTO
natesh.DelimitedCol VALUES (:col1, :"col2 two");
**** 18:14:53 UTY0805 RDBMS failure, 3707: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between ',' and the string 'COL2(VARCHAR(32)) INSERT INTO' keyword

FASTLOAD Error:
0009 DEFINE dummy (varchar(1)),
col1 ( VARCHAR(11)),
"col2 two" ( VARCHAR(32))
FILE = C:\Optim\Data\TD13\delimcal.000;

**** 18:33:56 FDL4822 DEFINE statement rejected.
**** 18:33:56 Definition syntax error for: "COL2

[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Solution for Data Growth- Data Privacy- and Test Data Management","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 July 2021

UID

swg21578967

Page Feedback