Page 1 of 1
when to write Shell Scripts and pl/sql in datastage
Posted: Thu Jul 15, 2004 4:33 pm
by suri
Hi,
I want to know where and when to use unix shell scripting and stored procedures in datastage.
Thanks
Suresh
Posted: Thu Jul 15, 2004 4:58 pm
by ketfos
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
Posted: Thu Jul 15, 2004 5:45 pm
by kduke
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.
Posted: Thu Jul 15, 2004 8:32 pm
by chulett
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'.
