informix 从文本导入海量数据(informix load)（Informix imports large amounts of data from text (Informix, load)）.docVIP

informix 从文本导入海量数据(informix load)（Informix imports large amounts of data from text (Informix, load)） Informix imports large amounts of data from text (Informix, load) Importing data from text to Informix data generally uses SQL statements: Load, from, file.dat, insert, into, yourDB; But when the imported data has several million or even tens of millions, the above method may go wrong because it can cause insufficient database caching. One solution is to use the dbload command, which follows the parameter description of the dbload: #--------------------------------------------------------------------- #dbload Usage: # #dbload, [-d, dbname], [-c, cfilname], [-l, logfile], [-e,, errnum], [-n, nnum] [-i inum] [-s] [-p] [-r # | -k] [-X] # # -d database name -c command file name # # -l bad row (s) log file # -e bad row (s) before abort # # -s syntax error check only # # -n of row (s) before commit -p prompt to commit or not # on abort # # -i or row (s) to ignore before starting # -r loading without locking table -X recognize HEX escapes in character # fields -k loading with exclusive lock # on table (s) #--------------------------------------------------------------------- Heres a simple example: Database name: remotedb Load command file name: load.cmd Error log file name: error.log Number of data submitted per submission: 100000 Data file name: prepay.dat Data delimiter: 1 Field data for each row of data: 14 The data table name to insert: prepay The application command is as follows: Dbload, -d, remotedb, -c, load.cmd, -l, error.log, -n; Load.cmd file content: －－－－－－－－－－－－－－－－－ File prepay.dat delimiter | 14; Insert into prepay; －－－－－－－－－－－－－－－－－ Attached shell script: # /bin/sh! #=========================================================================== #filename:dbload.sh # function: # from the file data into the Informix database # is mainly to solve the problem of massive data import, when used directly as: #load, from, prepay.dat, insert, into, prepay; # import dat