ODBCEvents: Connected to Microsoft SQL Server, version 12.00.4100 through driver <driver>.DLL.
The driver does not support quoted identifiers in SQL statements
External schema field, name: <field name>, type: INT32 was not found in the design schema
Design schema field, name: <field name>, type: INT32 was not referenced in the SQL statement
Error when checking operator: Could not find input field "<field name>".
main_program: Could not check all operators because of previous error(s)
main_program: Creation of a step finished with status = FAILED.
Doesn't that error message say exactly why? Sure looks like it does to me. And it doesn't have anything to do with creating a sequential file, looks to be all about the ODBC source extract.
-craig
"You can never have too many knives" -- Logan Nine Fingers
hmmmmm, i fixed problem by following exactly what you said.
the select statement has one field name mismatch with output table definitions name.
thanks, and this is lead to another 2 questions:
1. why sql field name have to match with table definition for ODBC stage? from my experience as long as their positions are match, the stage should work.
2. if i change the sql stage to a peek stage, the old job still works, why?
Your stated experience about order relates only to parameter markers, and these are not used in SELECT statements.
In SELECT statements you must precisely what values you wish to see, either via column names or SQL expressions in the SELECT clause, and the source of those values, such as table or view names, in the FROM clause.
The is the "structured" part of Structured Query Language.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.