DSXchange

Hi all;

I am facing a very strange problem .
I am using a TERADATA API stage in a datastage job .
In the API stage , I am using a USER-DEFINED SQL , where I am joing 3 tables and retriving the data.
But when I am trying to view data from the SQL , that time the following error is coming."GENERATED SQL requires a TABLE name ".
But I am not using GENERATED SQL , SO I should not need any table name to put.
Can you please any one help me where is my error is ?

Thanks to all.

It keeps the original generated SQL anyway. Just to keep it happy, preserve your user-defined SQL, switch back to generated SQL, fill in one or more table names, then switch back to user-defined SQL, reinstating your SQL if necessary. That should make it happy.

Thanks Ray

it seems you have left bank for the table name field, property in the API stage.

HI Keshav;

As I am using a user defined query , do i need to give table name ?

Theoretically no. Practically yes, because it complains if you don't.