Error when trying to read a fixed width file - EE
Posted: Fri Aug 11, 2006 9:29 am
Hi All,
I am trying to read a fixed width file into a sequential file stage of a Parallel job. I set up the format as:
Record Length=Fixed
I have set up the column definitions with multiple fields, all character and of various lengths. I have double checked and the input file is the same length as the sum of the field lengths.
Problem is, when I try and view data, I get the following:
##I TUTL 000031 16:20:45(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 16:20:45(002) <main_program> orchgeneral: loaded
##I TOSH 000002 16:20:45(003) <main_program> orchsort: loaded
##I TOSH 000002 16:20:45(004) <main_program> orchstats: loaded
##I TFSC 000001 16:20:45(005) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 16:20:46(000) <main_program> Parameter specified but not used in flow: FilePath
##W TCOS 000049 16:20:46(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOIX 000141 16:20:46(003) <sfWeeklyIdent> Unable to initialize the importer.
>##E TOIX 000000 16:20:46(004) <sfWeeklyIdent> "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "Ticker".>##E TFSR 000019 16:20:46(008) <main_program> Could not check all operators because of previous error(s)
>##E TCOS 000029 16:20:46(009) <main_program> Creation of a step finished with status = FAILED.
Any help that you can give here would be much appreciated. Thanks in advance.
Kind regards
Stu
I am trying to read a fixed width file into a sequential file stage of a Parallel job. I set up the format as:
Record Length=Fixed
I have set up the column definitions with multiple fields, all character and of various lengths. I have double checked and the input file is the same length as the sum of the field lengths.
Problem is, when I try and view data, I get the following:
##I TUTL 000031 16:20:45(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 16:20:45(002) <main_program> orchgeneral: loaded
##I TOSH 000002 16:20:45(003) <main_program> orchsort: loaded
##I TOSH 000002 16:20:45(004) <main_program> orchstats: loaded
##I TFSC 000001 16:20:45(005) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 16:20:46(000) <main_program> Parameter specified but not used in flow: FilePath
##W TCOS 000049 16:20:46(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOIX 000141 16:20:46(003) <sfWeeklyIdent> Unable to initialize the importer.
>##E TOIX 000000 16:20:46(004) <sfWeeklyIdent> "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "Ticker".>##E TFSR 000019 16:20:46(008) <main_program> Could not check all operators because of previous error(s)
>##E TCOS 000029 16:20:46(009) <main_program> Creation of a step finished with status = FAILED.
Any help that you can give here would be much appreciated. Thanks in advance.
Kind regards
Stu