delimiter string in schema file definition

[tulip.fernandes]

Hi All....
We are trying to use a Schema file definition for a Sequential file.
When we try to use a string (^|) as the field delimiter while defining the schema file, we are not able to process the records. All the records get rejected.

However the same thing works if we are not using a schema file definition. This can be done by adding a Delimiter String option in the file defaults of the Sequential file.
We must use the schema file definition. Please do not ask to go with the sequential file, as we can't.

Please reply if any one has a solution for the same.
Thanks,
Tulip

[ray.wurlod]

Save the table definition from your Sequential File stage, then view it as a schema file (on the Layout tab) to learn how it's done.

[meet_deb85]

To simplify Ray's words : -

1) Go to the table definitions tab in the designer on the left hand side.

2) Right click on any table definition and choose properties.

3) Click on the layout Tab and select Parallel.


This is how our schema file should look like.