sybase stored procedure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mab_arif16
Charter Member
Charter Member
Posts: 87
Joined: Sat Mar 18, 2006 11:45 pm

sybase stored procedure

Post by mab_arif16 »

Hi
Is it possible to call the syabse stored procedure using a transform STP stage.
I am not able to generate the procedure call syntax ,and getting error
Procedure expecting input parameters .
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Look in the stpstage.pdf (in the install CD if your Docs library doesn't have it) to see if your version supports sybase using the stp stage.
(7.5.1 Docs say Sybase is supported So go over the pdf and see if you missed anything)

What exactly do you need to do?

I was able to get a SP result set from a user defined quesry on sybase IQ, but is this oyur case?

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
mab_arif16
Charter Member
Charter Member
Posts: 87
Joined: Sat Mar 18, 2006 11:45 pm

Post by mab_arif16 »

roy wrote:Hi,
Look in the stpstage.pdf (in the install CD if your Docs library doesn't have it) to see if your version supports sybase using the stp stage.
(7.5.1 Docs say Sybase is supported So go over the pdf and see if you missed anything)

What exactly do you need to do?

I was able to get a SP result set from a user defined quesry on sybase IQ, but is this oyur case?

IHTH,
Hi
Did you or any one used a transfrom STP stage with some input parameters to call a sybase stored procedure.I would appreciate if some bode can give me the procedure call syntax.

Thanks
Arif
Post Reply