Getting Started with SAND CDBMS : Using SAND CDBMS
Loading Data into Tables Using the SAND CDBMS Data Loader

Running the SAND CDBMS Data-Loading Utility (ndlm)

see also
SAND CDBMS Tools Reference Guide: Running ndlm

Once the load specification script has been composed (see here), the source data can be loaded into tables in the database by running the file with the ndlm utility. To use ndlm, the target database instance must already be started, and there must be no nisqlm or other non-ndlm client connections to the instance. The -u option flag can be included in the ndlm invocation to disconnect all other non-ndlm users from the server automatically, but note that they will lose any unsaved work when their sessions are ended.

From the command prompt, invoke ndlm as follows:

ndlm [ <option-flags> ] connection-name instance-name user-name[/password] load-spec-file

Note:
If password protection is being enforced, include the user password (preceded by a slash, /) immediately after user-name.

Consult the SAND CDBMS Tools Reference Guide for information about ndlm invocation option flags. Available options can be displayed by typing -h after the ndlm command keyword. Useful flags include:

-b	suppresses interactive prompts from ndlm, to enable batch processing of loads
-n string	establishes string as the indicator for null values in the input file
-p n	instructs ndlm to process only n rows
-s n	instructs ndlm to process the input file beginning with row number n+1
-t timing-file-name	writes load timing information to the specified file