sql query

madhonrougeuri · Post by **madhonrougeuri** » Thu Feb 24, 2005 9:01 am

Hi,
Does anyone have an idea why a sql query that works fine in SqlPlus doesnot work in Datastage(oci9)?
Thanks..

kduke · Post by **kduke** » Thu Feb 24, 2005 9:10 am

Post the SQL.

chulett · Post by **chulett** » Thu Feb 24, 2005 9:12 am

And then explain exactly what "doesn't work" means.

madhonrougeuri · Post by **madhonrougeuri** » Thu Feb 24, 2005 9:19 am

query is like this;
select a.*,b.x from zzz a,yyy b where a.cc=b.cc;
This query appends a column 'x' in the table 'a' when i run it in sql plus but does not in datastage.

kduke · Post by **kduke** » Thu Feb 24, 2005 9:35 am

I would bet you have a metadata problem. Maybe the number of columns do not match the number returned.

madhonrougeuri · Post by **madhonrougeuri** » Thu Feb 24, 2005 9:44 am

Thanks..i got it