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.
TERADATA API
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
TERADATA API
Saugat Dey
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: