column ambiguously - table alias
Posted: Tue Jul 24, 2001 10:16 pm
Is there any way in DataStage, when it generate the query attached the table
alias with the column?
DSGenerate Query.
---------------
Selat a,a,b
from a,b
where a.a=b.a
Actual Query need is
--------------------
Select a.a,b.a,b.b
from a,b
where a.a=b.a
Workaround
-----------
In Colums tab, add alias to each line then I can get the results. But I have
too many fields.
above is the sample query, I have a long query where I have to add the table
alias.
Im using Oracle8 OCI
thanks in advance.
rahim
Rahim Ladha
e-mail : rahimladha@hotmail.com
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
alias with the column?
DSGenerate Query.
---------------
Selat a,a,b
from a,b
where a.a=b.a
Actual Query need is
--------------------
Select a.a,b.a,b.b
from a,b
where a.a=b.a
Workaround
-----------
In Colums tab, add alias to each line then I can get the results. But I have
too many fields.
above is the sample query, I have a long query where I have to add the table
alias.
Im using Oracle8 OCI
thanks in advance.
rahim
Rahim Ladha
e-mail : rahimladha@hotmail.com
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp