This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When connecting to Teradata with the Input Data tool in Designer, the following error occurs:
Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] The object name is too long in NFD/NFC.
There are SQL comments above the SELECT statement within the Connect In-DB or Input Data tool query box.ORThere are other Data Manipulation Language (DML) statements other than the SELECT statement in the main SQL query field. (i.e. UPDATE, CREATE, etc.)
Remove all comments from the SQL query or ensure there are no extra spaces before the SELECT statement.Specifically for the Input Data tool, if needing to put other DML statements such as an UPDATE statement, utilize the the Pre or Post SQL Statement fields in the properties section.