Sequential file stage- low value
Posted: Fri Dec 20, 2013 5:48 am
|i,
We are getting a binary file[delimited with "|"] as source. It is not giving as proper view data , While Reading the file using sequtial file stage, given options as EBCDIC with binary format in the stage. but we are not getting proper view data.
We need to give the lowvalue "X00", but i did not see any option which i need to give the low value in the sequential file stage.
Based on the forums, we need to use CFF stage but we already used sequential file stage, did not find the inforamtion after Reading the documentation which is provided by the datastage, givin more information on the ASCII but not on the EBCDIC format.
Exptect view data
as
Sampel Seq file stage view data -
Thanks
Smartpal
We are getting a binary file[delimited with "|"] as source. It is not giving as proper view data , While Reading the file using sequtial file stage, given options as EBCDIC with binary format in the stage. but we are not getting proper view data.
Code: Select all
Sampel Seq file stage view data -
10|abcd|100000
1|2|3|4|5|asdadad|349038403984|sdjkflksjdlajd
1|2|3|4|5|asdadad|349038403984|sdjkflksjdlajd
1|2|3|4|5|asdadad|349038403984|sdjkflksjdlajd
40|abcd|100000
Based on the forums, we need to use CFF stage but we already used sequential file stage, did not find the inforamtion after Reading the documentation which is provided by the datastage, givin more information on the ASCII but not on the EBCDIC format.
Exptect view data
as
Sampel Seq file stage view data -
Code: Select all
10|abcd|100000
1|2|3|4|5|asdadad|349038403984|sdjkflksjdlajd
1|2|3|4|5|asdadad|349038403984|sdjkflksjdlajd
1|2|3|4|5|asdadad|349038403984|sdjkflksjdlajd
40|abcd|100000
Smartpal