Data Stage 7.5 -SQL statement not updated in SQL Tab
Posted: Tue Aug 17, 2004 5:07 pm
Hi ,
I have a job.
OracleOCi8 ---- Transformer --- OracleOCi8
In the input stage, I select Fully generated SQL Query in Query type list box. Then I click Build.
I get Build Fully Genrated Query WIndow.
I select my table and click on Select to select columns.
I hit the query tab in above screen to view the query.
(select name from customer)
Then I hit Ok to close this screen.
Then I hit VIew Data and can correctly view it.
Now I want to change column name from name to email.
I go to OracleOCi8 stage.
Select the column tab. Click on Load tab.
Select column name email from list. Click on View Data.
(select email from customer)
It shows the data correctly.
When I click on SQL tab to view my SQL, it is old sql before i made the change.
(Select name from customer)
HAs anybody encountered this in DS 7.5?
Ketfos
I have a job.
OracleOCi8 ---- Transformer --- OracleOCi8
In the input stage, I select Fully generated SQL Query in Query type list box. Then I click Build.
I get Build Fully Genrated Query WIndow.
I select my table and click on Select to select columns.
I hit the query tab in above screen to view the query.
(select name from customer)
Then I hit Ok to close this screen.
Then I hit VIew Data and can correctly view it.
Now I want to change column name from name to email.
I go to OracleOCi8 stage.
Select the column tab. Click on Load tab.
Select column name email from list. Click on View Data.
(select email from customer)
It shows the data correctly.
When I click on SQL tab to view my SQL, it is old sql before i made the change.
(Select name from customer)
HAs anybody encountered this in DS 7.5?
Ketfos