How to read file when only half of the columns are optional.

[new2dsx]

Hi,

I need to read sequential file where in 50% cases file may contain half of the columns. There are some required columns and some are optional. File is comma delimited.

In server version, I was able to do this type of functionality by defining optional column properties. but in parallel version, that property is not avaiable.

I am inclined towards developing server job to solve this, but would like to use parallel jobs if possible.

Thanks,
New2DSX

[madhukar]

You can define a runtime Schema file and pass it as parameter...