IMPORT command with nicknames - examples

The examples show you how to import data into nicknames from different file types.

DEL file type

This example uses the INSERT_UPDATE option to import data from a DEL file type:

IMPORT FROM import_file_1.del OF DEL 
   ALLOW WRITE ACCESS 
   COMMITCOUNT 50 
   INSERT_UPDATE INTO NICKNAME_1;

IXF file type

This example uses the INSERT option to import data from an IXF file type:

IMPORT FROM import_file_1.ixf OF IXF 
   ALLOW WRITE ACCESS 
   COMMITCOUNT 20 
   INSERT INTO NICKNAME_1;

ASC file type

This example uses the INSERT option to import data from an ASC file type. The example includes the STRIPTBLANKS file modifier to truncate any trailing blank spaces in the data. The METHOD L parameter specifies the start and end of the column numbers.

IMPORT FROM import_file_1.asc OF ASC MODIFIED BY STRIPTBLANKS 
   METHOD L(1 6, 8 32, 34 44, 46 48) 
   ALLOW WRITE ACCESS 
   COMMITCOUNT 20 
   INSERT INTO NICKNAME_1;