I have a text column thatI want to preload with some text that contains EOLN (\n) charcters.
I know I need to use "LOAD" to load the text column, but regardless of what I try, I can't get the \n character loaded. I even insert it programatically and then used "UNLOAD" to generate a file, but that same file fails to put back the \n character when used with the LOAD command.
I gave this a shot, but Informix gives me the error:
"A blob subscript is not allowed within this context"
I guess it can't be used for updating rows. I played around with the subscripts and it does work for SELECTs.
Some Google searching found:
616 A TEXT or BYTE subscript is not allowed within this context.
This UPDATE or INSERT statement specifies a subscripted column of BYTE or TEXT data type as a destination. Subscript notation is not allowed in this context; a BYTE or TEXT (or any other) value must be replaced in full. Revise the statement to assign into whole columns.