SAND CDBMS Tools Reference Guide
NDL++ Functions:
Syntax and Examples  


NDL++ functions can be used in the map specification and the NULLIF, MISSINGIF, and SKIPIF clauses of ndlm import specification script files. They are typically included in the map specification (table-name section) to specify operations to be performed on input data. Analytical functions are useful for inclusion in variables and conditional expressions.

The examples presented in the following sections use the UNIX end-of-record character (\n), as opposed to the Windows characters (\r\n). In practice, use whichever end-of-record indicator is appropriate to the data file referenced by the specification script.