TERADATA API

saugat_1982 · Post by **saugat_1982** » Wed Aug 08, 2007 8:22 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 08, 2007 8:56 pm

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.

saugat_1982 · Post by **saugat_1982** » Thu Aug 09, 2007 3:10 am

Thanks Ray

keshav0307 · Post by **keshav0307** » Thu Aug 09, 2007 4:01 am

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

saugat_1982 · Post by **saugat_1982** » Thu Aug 09, 2007 8:17 pm

HI Keshav;

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

ray.wurlod · Post by **ray.wurlod** » Thu Aug 09, 2007 8:46 pm

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