Hi
Trying to create a simple job where i move data from oracle to netezza.
Running the query
SELECT "DMDUNIT", "DMDGROUP", "LOC", "STARTDATE", "DUR","TYPE","FCSTID", "QTY" AS ANT, "MODEL" AS MODELL, "LEWMEANQTY","MARKETMGRVERSIONID"
FROM "db1"."production" WHERE ROWNUM < 10
fail with the following error
TR_Transformer: Error when checking operator: Could not find input field "ANT".
Error when checking operator: Could not find input field "MODELL".
Running the same query directly to oracle works, but in datastage it fail.
I do not understand what happends
Please advise
Dan
Error reading input field
Moderators: chulett, rschirm, roy