Using HPL to Unload and Load Optical Data

You can use the HPL utility to migrate optical TEXT and BYTE data. With HPL you can either load or unload a complete table or a partial table. For example, you can unload selected columns or rows that contain optical TEXT and BYTE data and insert them into a table in another database.

For instructions on how to use the HPL utility, see the IBM Informix: High-Performance Loader User's Guide.