Page 1 of 1
STOREDPROCEDURE
Posted: Mon Jan 16, 2006 12:27 pm
by 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
Re: STOREDPROCEDURE
Posted: Mon Jan 16, 2006 10:29 pm
by keshav0307
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
Posted: Mon Jan 16, 2006 11:49 pm
by 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
Posted: Tue Jan 17, 2006 12:09 am
by 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
Posted: Tue Jan 17, 2006 1:47 am
by 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
Posted: Tue Jan 17, 2006 2:24 am
by 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
Posted: Tue Jan 17, 2006 3:00 pm
by adarsh shrinagesh
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 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.