Page 1 of 1
sql query
Posted: Thu Feb 24, 2005 9:01 am
by madhonrougeuri
Hi,
Does anyone have an idea why a sql query that works fine in SqlPlus doesnot work in Datastage(oci9)?
Thanks..
Posted: Thu Feb 24, 2005 9:10 am
by kduke
Post the SQL.
Posted: Thu Feb 24, 2005 9:12 am
by chulett
And then explain exactly what "doesn't work" means.
Posted: Thu Feb 24, 2005 9:19 am
by madhonrougeuri
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.
Posted: Thu Feb 24, 2005 9:35 am
by kduke
I would bet you have a metadata problem. Maybe the number of columns do not match the number returned.
Posted: Thu Feb 24, 2005 9:44 am
by madhonrougeuri
Thanks..i got it