STPPX Stage - Sybase Stored Proc

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
ersunnys
Participant
Posts: 29
Joined: Wed Sep 13, 2006 1:39 pm
Location: Singapore

STPPX Stage - Sybase Stored Proc

Post by ersunnys »

Hi,

We are tying to extract data from Syabase DB through STPPX stage. length of column is Char(400), in Output i have tried selecting Char 400 as well as Varchar 400.

Problem is Data is getting truncated after 255 Char...

Can anyone please help in resolving this issue.

Sunny
Regards,
Sunny Sharma.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

That may be a Sybase limit on the maximum column size returnable through a stored procedure. Please check your Sybase documentation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
ersunnys
Participant
Posts: 29
Joined: Wed Sep 13, 2006 1:39 pm
Location: Singapore

Post by ersunnys »

Ray,

It is not Sybase limit because I am getting expected data (complete 400 Char) when i execute procedure in Sybase, but when i call same procedure in Datastage through STPPX stage, data is getting truncated to 255 chars...

Sunny
Regards,
Sunny Sharma.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Then it seems to me it's time to involve your official support provider. Perhaps this is a known issue.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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