DSXchange

I need to read the few colums from a '|' delimited sequential file. File may have any number of colums.

We can do this by using the partial schema file. I want the syntax for creating a partial schema file.

Example in help pdf is for fixed width file not for a delimited file.

Specify format in schema file.

There are many examples in the manuals; format is specified the same way as for non-partial definitions. Inspect one of your extant sequential file definitions in the Repository, particularly the parallel layout thereof.

Hi Ray,

Examples mentioned in pdf are for fixed width file only .
If we comma separated (delimiter) file with 10 columns , and we require data for only few columns ,how to specify them .As delinmited file will not have start and end position of data .

Please help in this .