when to write Shell Scripts and pl/sql in datastage

suri · Post by **suri** » Thu Jul 15, 2004 4:33 pm

Hi,

I want to know where and when to use unix shell scripting and stored procedures in datastage.

Thanks
Suresh

ketfos · Post by **ketfos** » Thu Jul 15, 2004 4:58 pm

Hi,
You can use Stored Procedures for data manipulation(insert/update/delete) from and to tables.
But you can achieve the similiar functionality in DataStage enviornment itself instead of using the PL/SQL stored procedure (In case of Oracle) and thus avoid PL/SQL statements.

Shell Scripts can be used in before/after routines in job control.

Ketfos

kduke · Post by **kduke** » Thu Jul 15, 2004 5:45 pm

A lot of people use shell scripts instead of ftp stages. There are lots of things you can trigger using shell scripts. It is easy to shell out and do sqplus or run some process to extract data from a source that does not use ODBC or some plugin. The flexiblity is great.

Stored procedures maybe easier to implement in "before" sql. You can see that tab within Oracle and other plugins.

If there is some process that you need done before or after a job then shell scripts are useful.

chulett · Post by **chulett** » Thu Jul 15, 2004 8:32 pm

Upgrade to 7.5 and enjoy the benefits of the Stored Procedure Stage. As long as you are on Oracle, that is. Support for other databases 'coming soon'.