Overview

Invoking & Using nconfig

Creating & Configuring a Database

Database Configuration Options

Nconfig Error Messages

Overview

Providing Multi-User Database Access with nserv

Managing Database Server Access

Shutting Down the Database Server

Nserv Exit Codes

Nserv SQL Error Messages

Virtual and Persistent Mode Error Messages

Session Mode (.SESS)

SQL Mode (.SQL)

Date and Time Display Formats

Nisqlm Error Messages

Nisqlm Exit Codes

The Parallel Loader

SAND Compacted Table (SCT) Functionality

Running ndlm

Importing Data with ndlm

Creating the Import Specification Script

Import Record Specification

The NULLIF and MISSINGIF Statements

The SKIPIF Clause

Import Map Specification

NDL++ Data Load Scripting Language

Declaring Variables

The #INCLUDE Directive

NDL++ Load Scripting Functions:
String Functions
Math Functions
Custom Library Functions
Operators
Operator Precedence

Import Examples

Verifying and Filtering Data Using the PIC Clause

Importing Data from an SCT File

Importing Data from a CSV File

Updating the Database with ndlm (EXECSQL)

Exporting Data with ndlm

Exporting Data to an SCT File

Transferring Data via Named Pipes

Importing from an ODBC Data Source

Batch Execution

Creating a Custom Library in C/C++

Troubleshooting

Ndlm Error Messages

Ndlm Exit Codes