First of all... I have seen many related discussions to the error I am getting, but none of them could really help me and that's the reason why I am posting this again.
I am using Datastage 8.1 parallel.
I have an SQL which is quite complex with multiple inner joins and calculations, but perfectly runs in Teradata SQl assistant.However, when I try to view the data using the same query in Teradata Enterprise stage it is given me many errors like below.
TeraUtils:DB Call Failure(success check) Info = 13300, Code = 3707, Message = Syntax error, expected something like a name or a Unicode delimited identifier or '(' between the 'FROM' keyword and ';'.
<_PEEK_IDENT_> Input dataset does not have field: "<columnname>".
<main_program> Could not check all operators because of previous error(s)
When checking operator: The modify operator has a binding for the non-existent output field "<columnname>".
I have 17 fields and getting the same errors as above for all of them.I have specified the Database name, datatypes of input and output columns are matching,
I believe that TDE stage is efficient enough to run complex queries....(correct me if I am wrong).
Please help!!!!
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)