Informix Error -4438

-4438 You cannot SELECT into a substring of a character variable.

Substring notation is not allowed in the INTO clause. You can specify a substring of a column in the list of columns to select and in the WHERE clause. But you have to select into an entire variable. Define a variable to select into, and move the data into the destination substring using a LET statement.