skip to main content

c-tree Utilities : Command-line utilities : dbload
dbload
The dbload utility imports data from another file into a isCOBOL SQL Server file.
Usage:
dbload -f commands_file [options] database_name
Where:
•
command_file is the script file containing the load commands. Consult http://www.faircom.com/doc/isql/ (Data Load Utility: dbload -> The Commands File) for details on this kind of files. The following snippet shows a sample command_file:
     DEFINE RECORD ord_rec AS
         ( ord_no, item_name, date, item_qty ) FIELD DELIMITER ' ' ;
     FOR EACH RECORD ord_rec FROM ord_in
         INSERT INTO ADMIN.orders (order_no, product, order_date, qty)
         VALUES (ord_no, item_name, date, item_qty) ;
     NEXT RECORD
•
database_name is the name of the destination database
•
options can be one or more of the following:
o
-u user_name: user name to connect to the database.
o
-a password: password to connect to the database.
o
-z maximum multiple inserts: maximum number of records to be inserted at one time in each bulk insert (used to improve performance)
o
-l logfile: the file into which the error logging is done. stderr is the default.
o
-b badfile: the file into which the bad rows that were not loaded, are written. By default badfile is put in the current directory.
o
-c commit_frequency: the specified number of records before committing the transaction. The default frequency is 100 records.
o
-e maxerrs: the maximum number of tolerable errors. The default number is 50 errors.
o
-s skipcount: skip the specified number of rows in the first data file. If multiple files are specified, the rows are skipped only in the first file. The default is 0.
o
-m maxrows: stop storing rows at the specified number.
-n: parse the commands file and display errors, if any, without doing the database load.
Copyright (c) 2017 Veryant
Contact us
Please share your comments on this manual or on any
Veryant product documentation with the email button at the top left