Use Case Accelerators > How to Convert Positional SyncSort UNIX /FIELDS to DMExpress /RECORDLAYOUT

How to Convert Positional SyncSort UNIX /FIELDS to DMExpress /RECORDLAYOUT

Article #: Product: Version:

Summary

When migrating existing applications from SyncSort UNIX to DMExpress, converting SyncSort UNIX positional /FIELDS layouts to DMExpress /RECORDLAYOUT statements is complicated by the following conditions that are supported in /FIELDS but not in /RECORDLAYOUT statements:

The attached Perl script provides a way to convert positional /FIELDS layouts to /RECORDLAYOUT statements within the constraints of the above limitations.

Note that delimited /FIELDS statements would need to be converted to /DELIMITEDLAYOUT statements in DMExpress, but that is a simpler case and is not covered here.

Resolution

Attachments

350_FieldsToRLO.zip, which contains the Perl script and associated input/output files

Additional Information

See SyncSort_UNIX_Reference_Guide.pdf for details on the /FIELDS syntax.

See /RECORDLAYOUT command option in the DMExpress Help for details on the /RECORDLAYOUT syntax.

Last updated: