Complex Flat File very long filler processed as "raw&qu

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
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm

Complex Flat File very long filler processed as "raw&qu

Post by FranklinE »

We likely have a workaround, so this is a request for any similar issues people have seen and whether they determined if it was worthy of reporting to IBM. I tried a few searches for previous posts on this, but found none (likely because I'm just bad at searches).

The copybook defines a record of 2,000 bytes. The final filler is 1,739 bytes long. The table definition, Stage tab displays of the column and Output stage display all show the column as Char(1739), except the Stage Layout tab. The parallel view defines the column as raw(1739). The job aborts on the message correctly showing that raw to string is not supported.

I verified the .cfd file used for the import has FILLER PIC X(1739). All of the other columns are verified as well.

My only guess is the length of the column. We'll try splitting it to two or more shorter columns.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: http://www.dsxchange.com/viewtopic.php?t=143596 Using CFF FAQ: http://www.dsxchange.com/viewtopic.php?t=157872
Post Reply