STOREDPROCEDURE

[seeta]

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

[keshav0307]

very much possible. you can call it at any stage

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

[swarnkar]

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

[Sreenivasulu]

HI

You can use the stored procedure to input data to database but if you want to retrieve some value from the database using the stored procedure
then its not quite straight forward. I had once tried to retrieve value using
a stored procedure but could not succeed.

Regards
Sreeni

[keshav0307]

I find it straight farwords

SQFILE---->stored procedure------->file

you can pass the input column as parameter to the store procedure,and can get outputput parameter in the output stage

[swarnkar]

[quote="keshav0307"]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

[adarsh shrinagesh]

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 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.

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.