Filters with code-set conversion (GLS)

When you use a filter to select or discard data during the load, the High-Performance Loader (HPL) interprets the filter specification in the code set of the database server. The filtering process on data that undergoes code-set conversion occurs in the following order:
  1. The onpload utility converts the input data to the code set of the database server.
  2. The onpload utility performs the filtering operation.

If the code-set conversion process creates lossy errors, then the output of the filter operation can be unexpected. For information about lossy errors and how to define or evaluate a code-set conversion specification, see the HCL Informix® GLS User's Guide.

Parent topic: Define filters
Copyright© 2019 HCL Technologies Limited