Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column name list longer than value list.

717169Nov 7 2009 — edited Nov 9 2009

Hi all,
Source(Flatfile)----------->Target(Teradata table).Using IKM-------->Teradata Control Append and LKM----->File to SQL.
One to one mapping.

Error:

706 : 42000 : com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 12.00.00.110] [Error 3706] [SQLState 42000] Syntax error: Column name list longer than value list.
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 12.00.00.110] [Error 3706] [SQLState 42000] Syntax error: Column name list longer than value list.

Please do the needful

Regards
Suresh

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2009

Added on Nov 7 2009

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

3,803 views