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
STP unable to generate procudure call
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
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.
Please post the exact error you get
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 :idea:](./images/smilies/icon_idea.gif)
![Arrow :arrow:](./images/smilies/icon_arrow.gif)
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](http://www.worldcommunitygrid.org/images/logo.gif)
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](http://www.worldcommunitygrid.org/images/logo.gif)