Previous Topic Next topic Print topic


OFFSETS

Restriction: This topic applies to Windows environments only.

Specifies the starting positions of fields being imported from fixed-format ASCII files. The syntax is:

OFFSETS = start-pos1 [, start-pos2]. . .;  

where the starting positions are listed in the same order as the corresponding field names, and delimited by commas.

To determine the starting positions, it might be necessary to examine the file. (Use the Source File command from the View menu, or use a text editor.) The OFFSETS Batch Import command is required for every transaction when importing a fixed-format ASCII file into XDB Server.

For example:

OFFSETS = 1,11,23,35,57,74,78,85,91,113;

specifies the starting positions of the columns in a fixed-format ASCII source file.

Previous Topic Next topic Print topic