Hi,
I want to know where and when to use unix shell scripting and stored procedures in datastage.
Thanks
Suresh
when to write Shell Scripts and pl/sql in datastage
Moderators: chulett, rschirm, roy
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
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
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.
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.
Mamu Kim