Cannot Preview Fixed Width File Sequential File Data

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
ReceK
Premium Member
Premium Member
Posts: 1
Joined: Mon Jun 30, 2008 10:39 am

Cannot Preview Fixed Width File Sequential File Data

Post by ReceK »

I'm a new DataStage user using DataStage version 8.0 and cannot preview my fixed width sequential file within DataStage. I created a test file with 3 columns:

FIRST_NAME CHAR 15 Not Nullable
LAST_NAME CHAR 15 Not Nullable
ADDRESS_1 CHAR 30 Not Nullable

Record Level Properties
Record delimiter = UNIX newline
Record length = fixed

Field defaults
Delimiter = none

I've used Informatica and Ab Initio in the past and have never had any trouble getting those tools to read files of any kind.

Below is the new error message I'm receiving:

##E IIS-DSEE-TOIX-00139 13:33:33(007) <Sequential_File_0> Import validation failed.
##E IIS-DSEE-TFIG-00226 13:33:33(008) <Sequential_File_0> At field "FIRST_NAME": A fixed length field cannot have a "null_field" of length 0 on import with delim of none or whitespace
##E IIS-DSEE-TFIG-00226 13:33:33(009) <Sequential_File_0> At field "LAST_NAME": A fixed length field cannot have a "null_field" of length 0 on import with delim of none or whitespace
##E IIS-DSEE-TFIG-00226 13:33:33(010) <Sequential_File_0> At field "ADDRESS_1": A fixed length field cannot have a "null_field" of length 0 on import with delim of none or whitespace
##E IIS-DSEE-TOPK-00007 13:33:33(014) <_PEEK_IDENT_> Input dataset does not have field: "FIRST_NAME".
##E IIS-DSEE-TOPK-00007 13:33:33(015) <_PEEK_IDENT_> Input dataset does not have field: "LAST_NAME".
##E IIS-DSEE-TOPK-00007 13:33:33(016) <_PEEK_IDENT_> Input dataset does not have field: "ADDRESS_1".
##E IIS-DSEE-TFSR-00019 13:33:33(018) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 13:33:33(019) <main_program> Creation of a step finished with status = FAILED.

Any ideas on what I'm missing?

Thanks!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You're missing what it's telling you: A fixed length field cannot have a "null_field" of length 0 on import with delim of none or whitespace.

You must provide Null Field Value property values that contain the same number of characters as the defined field width.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

de select the "Record length = fixed " option
Post Reply