Call sql from remote location into ETL

pavan_test · Post by **pavan_test** » Fri Feb 03, 2012 10:22 am

Hi All,

I have a sql in a test file in a remote location. (on the datastage server).

Can someone please suggest me if there is any way I can call this sql in ETL job and run it using oracle enterprise edition (we have Oracle as source and target) and write the output.

we want to keep the sql in remote location because if any changes to that sql we need not have to change the ETL job.

Thanks
pavan

chulett · Post by **chulett** » Fri Feb 03, 2012 11:15 am

How is on the DataStage server a "remote" location? If it is local to the DataStage server in any fashion, you can easily leverage it by using the SQL File option in the stage.

pavan_test · Post by **pavan_test** » Fri Feb 03, 2012 11:55 am

Actually the file will be local to the datastage server. where can I find the sql file option in the Oracle Enterprise edition stage.

Thanks
Pavan

chulett · Post by **chulett** » Fri Feb 03, 2012 12:15 pm

If you can't find that actual option (not all stages have it) then use the {FILE} methodology noted here and elsewhere.