/LOBIN - Write the LOB data inside the text file

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
/LOBIN - Write the LOB data inside the text file

Syntax: /LOBIN

This option specifies that the data of LOB columns (CLOB, BLOB, TEXT, IMAGE and MEMO) be written inside the text file.

By default, if /TARGET is Oracle, IBM DB2 or not specified, each LOB value is written into a separate file. This allows the LOB data to be transferred into Oracle using SQL Loader and IBM DB2 IMPORT/LOAD utilities.

If /TARGET is Microsoft SQL Server, Sybase, MySQL or Pervasive.SQL, the LOB data are written inside the text file even if the /LOBIN option is not specified. This allows the LOB data to be transferred into Microsoft SQL Server and Sybase using the BCP utility, into MySQL using LOAD DATA INFILE command and into Pervasive.SQL using the BUTIL utility.