Loading to a only TEXT field
I'm having problems for load a text file to a 'TEXT' field.
I have a table just with one field ('TEXT' data type): table 'TblTmpTextos'
CREATE PROCEDURE procimportadescripcionlarga()
DEFINE v_StrCadena Varchar(255);
LET v_StrCadena = "";
LET v_StrCadena = v_StrCadena || " Load From '/informix/file.txt' ";
LET v_StrCadena = v_StrCadena || " Insert Into TblTmpTextos ";
SYSTEM 'echo " ' || v_StrCadena || ' " |dbaccess epic';
END PROCEDURE;
The errors are: 668: System command cannot be executed.
255: Not in transaction.
if you can help me to solve it...will be great...thanks to all.