i m facing a problem with sequential file.
i have a source file with header,footer and detail records.header will be the first record and footer will be the last record ,in between records are detailed records.i dont have any indicator like thing saying that it is a header or footer or detailed record.my job is to route the first and the last records to one file and between records to another file.suppose if there are only two records both must go to one file assuming that one is a header and another is a footer.i need to do this with the help of datastage job but not with unix commands.
can anybody help me how to solve this problem?
