Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

/LDEL - Line delimiter

Syntax: /LDEL=LineDelimiter

This option specifies a line delimiter used in the text files. The default value is carriage return and new line characters (0x0D0A or \r\n) unless /IMPS=Unix is specified. If /IMPS=Unix is specified, the default value is a new line character (0x0A or \n).

Using this option you can specify any string as a line delimiter. The non-printing characters like tab, carriage return and new line can be represented by \t, \r and \n accordingly.

In most cases, if there are new line characters in the data, you have to change the default value to any other string that does not exist in the data. This will allow you to process rows properly by import/load utilities.

You can specify this option in the initialization file. See Initialization File Options for details.