Hi,
I wrote one storedprocedure I want to call that in my job.Which stage can I use to call the stored procedure into my parlleljob.Is this posible are not?
Thanks
STOREDPROCEDURE
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Re: STOREDPROCEDURE
very much possible. you can call it at any stage
seeta wrote:Hi,
I wrote one storedprocedure I want to call that in my job.Which stage can I use to call the stored procedure into my parlleljob.Is this posible are not?
Thanks
Hi,
You can call it through ODBC stage as
SEQ_FILE----->Tranfomer------>ODBC_STAGE
the input column to ODBC_STAGE will be passed as agrument to procedure. Here agrument is compulsary so if yoour procedure is not using arguments, you can pass a dummy agrument.
You can call SP in OCI stage where you can make a call in Before tab of SQL tab.
Nitin
You can call it through ODBC stage as
SEQ_FILE----->Tranfomer------>ODBC_STAGE
the input column to ODBC_STAGE will be passed as agrument to procedure. Here agrument is compulsary so if yoour procedure is not using arguments, you can pass a dummy agrument.
You can call SP in OCI stage where you can make a call in Before tab of SQL tab.
Nitin
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
If you're not on a version lower than DS 7.5 you cud use the OCI stage for calling your stored procedure( call or execute) if your procedure is not returning a value.swarnkar wrote:keshav0307 wrote:I find it straight farwords
SQFILE---->stored procedure------->file
Keshav,
stored procedure stage is available in Data Stage 7.5 so its ok for them but for prior versions we have call SP trough OCI or ODBC stage
Thanks
If your are returning a value you would need to use a ODBC stage ...
On DS 7.5 the STP stage works wonders
Remember that you would have to create DSN's for the ODBC and STP stages.