mainframe file issue

sdfasih · Post by **sdfasih** » Wed Jul 26, 2006 9:28 pm

Hi,
I have an issue reading mainframe file whose format is
H,date(2006-07-07).....
D,.............................
D,....................
.
.
T,1234,..................

H-header record
D-data record
T-trailer record

I am using same metadata to read all the records using CFF stage to convert ebcidic to ascii.
I have an issue with the second column its datatype is integer.So date cannot be loaded into this datatype.After conversion its giving me junk values for data column of header record.
Please suggest some strategy to deal with this issue as it may happen for any file.
Thanx in advance

kumar_s · Post by **kumar_s** » Wed Jul 26, 2006 10:17 pm

Since the file is in Ebcidic formate, you canot use unix command readily.
Check whether you can count the number of lines of the file using wc -l command. If it succeed, it proves the file has the end of line as new line character. So you can wipe out the first and last in unix command in the filter option using tail/head command.
Or once Trailer record is removed, give the first line as column name to get rid of Header.
Else, Read the whole as varchar chuck and using a transformer wipe out the header and trailer using the first column 'H' and 'T' check. and formulate back to the given metadata.

kumar_s · Post by **kumar_s** » Wed Jul 26, 2006 10:19 pm

Can you delete the other dulicate post create on the same topic by you, before any one reply to that.