Informix HPL message 23427: Pload cannot reorder queries having expressions/aggregates and blobs/udts in the same select list. Please reorder the select list in the query in the following order: 1. non-blob non-udt columns 2. inrow udts in the case of fixed format 3. other blob/udt columns.

Message

Program: onpload

Pload cannot reorder queries having expressions/aggregates and blobs/udts  in
 the same select list. Please reorder the select list in the query in the
 following order: 1. non-blob non-udt columns 2. inrow udts in the case of
 fixed format 3. other blob/udt columns.

Oninit® Troubleshooting Guidance

What it means

Queries mixing expressions or aggregates with blob and UDT columns cannot be reordered. The message describes the order to use: non-blob non-UDT columns first, then in-row UDTs for fixed format, then other blob and UDT columns.

Common causes

Select list in the wrong order.

What to do

Reorder the select list as described.