Complex flat file with multiple records
Moderators: chulett, rschirm, roy
Complex flat file with multiple records
Hi There, I have a problem while reading multiple record types using Complex Flat file. My input file is coming from Mainframes in EBCDIC (Binary) format and it has three record types in it; Header, Detail and Trailer. I have defined three record definitions in CFF stage along with the Record Id specifications ( for each record type, the first column represents the record type).I have configured the CFF stage as below.
File Options: Record Type - Fixed Block
Record Options: Byte Order -Big endian; Data format- binary ; Character set: EBCDIC.
With the above settings in the CFF stage I am not able to read the file. But
When I tried to read the same file in server job then CFF stage giving me the expected output, but the job is getting aborted when try to read the file (Header,Detail along with the Trailer) using CFF stage in parallel job .
Can anyone help me in resolving this issue.
Thanks in advance!
File Options: Record Type - Fixed Block
Record Options: Byte Order -Big endian; Data format- binary ; Character set: EBCDIC.
With the above settings in the CFF stage I am not able to read the file. But
When I tried to read the same file in server job then CFF stage giving me the expected output, but the job is getting aborted when try to read the file (Header,Detail along with the Trailer) using CFF stage in parallel job .
Can anyone help me in resolving this issue.
Thanks in advance!
Ria
The only way of finding the limits of the possible is by going beyond them into the impossible
The only way of finding the limits of the possible is by going beyond them into the impossible
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 21, 2007 9:35 am
- Location: Boston
Ria,
How are you trying to read the file in parallel job? Is it through view data? Did you checked the record layout?
It is very easy work with CFF stage in a server job. Because a server job doesn't complain about a data type and I also read some where CFF stage was initially a server stage later brought into parallel pallette.
Please post what error you are getting so taht we can try to help you.
Aruna.
How are you trying to read the file in parallel job? Is it through view data? Did you checked the record layout?
It is very easy work with CFF stage in a server job. Because a server job doesn't complain about a data type and I also read some where CFF stage was initially a server stage later brought into parallel pallette.
Please post what error you are getting so taht we can try to help you.
Aruna.
Hi Aruna
Thanks for quick response..
Yes iam trying to read file through view data but its throwing an error i.e
>##E TCOS 000003 13:23:23(001) <main_program> Syntax error: Error in "import" operator: Error in operator arg: In field "SDW": Expected ";", got: "-", line 323
>Expected operator name, got: ")", line 346; text: import;
>)
>Error in "jobmon_ident" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Expected ';' or ','; got: "-", line 360
>
>##E TCOS 000029 13:23:23(002)
and i have cross checked record layout.Iam able to read that file in server job not in parallel.
I have one doubt my datastage version is 7x not 8x is this reason of that.
Thanks in advance....
Thanks for quick response..
Yes iam trying to read file through view data but its throwing an error i.e
>##E TCOS 000003 13:23:23(001) <main_program> Syntax error: Error in "import" operator: Error in operator arg: In field "SDW": Expected ";", got: "-", line 323
>Expected operator name, got: ")", line 346; text: import;
>)
>Error in "jobmon_ident" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Expected ';' or ','; got: "-", line 360
>
>##E TCOS 000029 13:23:23(002)
and i have cross checked record layout.Iam able to read that file in server job not in parallel.
I have one doubt my datastage version is 7x not 8x is this reason of that.
Thanks in advance....
Ria
The only way of finding the limits of the possible is by going beyond them into the impossible
The only way of finding the limits of the possible is by going beyond them into the impossible
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 21, 2007 9:35 am
- Location: Boston
Can anyone throw light why this error is coming while reading file throw view data
>##E TCOS 000003 13:23:23(001) <main_program> Syntax error: Error in "import" operator: Error in operator arg: In field "SDW": Expected ";", got: "-", line 323
>Expected operator name, got: ")", line 346; text: import;
>)
>Error in "jobmon_ident" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Expected ';' or ','; got: "-", line 360
>
>##E TCOS 000029 13:23:23(002)
Thanks
>##E TCOS 000003 13:23:23(001) <main_program> Syntax error: Error in "import" operator: Error in operator arg: In field "SDW": Expected ";", got: "-", line 323
>Expected operator name, got: ")", line 346; text: import;
>)
>Error in "jobmon_ident" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Expected ';' or ','; got: "-", line 360
>
>##E TCOS 000029 13:23:23(002)
Thanks
Ria
The only way of finding the limits of the possible is by going beyond them into the impossible
The only way of finding the limits of the possible is by going beyond them into the impossible