Previous Topic Next topic Print topic


SRC_LENS

Restriction: This topic applies to Windows environments only.

S pecifies the maximum number of spaces a field can use in a fixed-format ASCII source file being read. The syntax is:

SRC_LENS = length1 [, length2] ...; 

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

When importing fixed-format ASCII files, the SRC_LENS command is used to determine the source file length. To determine the field length for ASCII files, it might be necessary to examine the files. (Use the Source File command from the View menu or a text editor.)

The SRC_LENS Batch Import command is required for every transaction when importing a fixed-format ASCII file into XDB Server.

For example:

SRC_LENS = 8,10,20,15,2,5,4,20,30;

specifies the column widths of the fixed-format ASCII source file being read.

Previous Topic Next topic Print topic