UniData 6 stage - need info
Posted: Wed Mar 15, 2006 10:18 am
Our DataStage ETL jobs were set up a couple of years ago by developers that no longer work here, so one of our big challenges is figuring out what they did and how they did it so we can make changes as necessary.
We have 2 UniData 6 database servers, development and production, and we are successfully doing a number of daily extracts. Some use the ODBC driver, and some the UniData 6 driver.
Our UniData guy and I are puzzled by the DataStage UniData 6 stage. On one job, for example, we're pulling data from table A, which contains a foreign key to table B. This works in both environments.
The SELECT statement contains a couple of fields from table B, but there is no explicit JOIN between the 2 tables. Like this:
SELECT ID, DESCRIPTION, TABLE_B_FUNKYDATE
FROM TABLE_A
TABLE_B_FUNKYDATE is a field in TABLE_B.
How does this work? Is the sql passed to UniData or is it translated to something else when it hits the UniData machine?
Basically, I want to know how I can run the SQL statement on the UniData side and FTP the file to another machine.
Thanks,
gregdmorey@yahoo.com
We have 2 UniData 6 database servers, development and production, and we are successfully doing a number of daily extracts. Some use the ODBC driver, and some the UniData 6 driver.
Our UniData guy and I are puzzled by the DataStage UniData 6 stage. On one job, for example, we're pulling data from table A, which contains a foreign key to table B. This works in both environments.
The SELECT statement contains a couple of fields from table B, but there is no explicit JOIN between the 2 tables. Like this:
SELECT ID, DESCRIPTION, TABLE_B_FUNKYDATE
FROM TABLE_A
TABLE_B_FUNKYDATE is a field in TABLE_B.
How does this work? Is the sql passed to UniData or is it translated to something else when it hits the UniData machine?
Basically, I want to know how I can run the SQL statement on the UniData side and FTP the file to another machine.
Thanks,
gregdmorey@yahoo.com