STP unable to generate procudure call

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

STP unable to generate procudure call

Post by mab_arif16 »

I am calling a sybase stored procedure from the transform STP stage ,
It has an seq file as input ,and I am using transform STP stage,but the stage is not generating a procedure call using parametrs and column mapping.
like Oracle stored procedure generates BEGIN procname(:1,:2) END
Does some body knows the syntax of procedure call to sybase.
I tried
BEGIN procname(:1,:2) END
BEGIN exec procname @start = ORCHESTRATE.Col1, @end = ORCHESTRATE.Col2 END
BEGIN exec procname @start = DSlink12.Col1, @end = DSlink12.Col2 END
but getting error .
Thanks
Arif
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
From memory you can use call or execute for invoking the SP, I'm not sure you need the BEGIN/END in your sql.

But the above refers to a user defined SQL.

:idea: :arrow: Please post the exact error you get
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
Post Reply