Filters with Code-Set Conversion (GLS)

When you use a filter to select or discard data during the load, the 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 on lossy errors and how to define or evaluate a code-set conversion specification, see the IBM Informix: GLS User's Guide.