Partial Schema file

vishnuvyas · Post by **vishnuvyas** » Mon Jul 20, 2009 1:55 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 20, 2009 4:59 pm

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.

bgs_vb · Post by **bgs_vb** » Mon Mar 26, 2012 2:34 am

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 .