mainframe file issue

[sdfasih]

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.

[ray.wurlod]

Sounds like the REDEFINES for a type "H" record is inexact in the metadata. Get that fixed and all should be well.

[sdfasih]

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.

Thanx Ray, but can you elaborate on your solution.

[ray.wurlod]

You claim that the second field is an integer but have described the "H" record type as having a date in the second field.