Calling 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
shyju
Participant
Posts: 58
Joined: Thu May 19, 2005 1:00 am

Calling sybase stored procedure

Post by shyju »

Hi All,

Can we call a SYBASE stored procedure from DataStage using ODBC stage.

Thanks in advance
Shyju
Top
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

No, you should use the Stored procedure stage
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I believe you can if it has only IN or INOUT paramters. Never tried it myself but the only limitation for calling odbc stored procedures is that it only supports IN and IN OUT parameters.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”