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!
Cannot Preview Fixed Width File Sequential File Data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia