Data display problem

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
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Data display problem

Post by abc123 »

I have a simple job where data is being written from a SQL Server table to a sequential file aftercoming through a transformer. When I view the data from SQL Server on the DRS stage, it looks fine. However, when I display data on the sequential file, it just shows the first 2 columns. What's interesting is, when I view the data using the vi editor, it is fine. Can somebody tell me the reason?
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

What is the data type and contents of the 3rd column? Could there be some nondisplayable characters there?
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 »

In particular, is there a leading \x00 character?
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
Post Reply

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