Executing Informix Stored procedure from PB
Hi, I am getting the following error when executing a procedure from
PB. Actually, this is the messages made by the trace command in
Informix SPL.
let cmd = dbload -d cip -c /usr/informix/dev/load/load.cmd -l /tmp/err_log
system : dbload -d cip -c /usr/informix/dev/load/load.cmd -l /tmp/err_log
exception : looking for handler
SQL error = -668 ISAM error = -1 error string = = ""exception : no appropriate handler
I am able to run this procedure from ISQL with no problems as the user
Informix. I am running it through PowerBuilder as informix also. There
are additional commands in the stored procedure that are executed
correctly, but it always bombs on this part.
Thank you for your suggestions.
Pete
P.S. please reply via email
P.P.S. Here is the rest of the stored procedure and
how I am executing it from PB.
create procedure load_legacy()
define cmd CHAR(90);
set debug file to "/tmp/debug";
trace on;
let cmd = "fold -w 520 /tmp/cip.dat > /tmp/cipgood.dat";
system cmd;
let cmd = "cat /usr/informix/dev/load/nothing >>/tmp/cipgood.dat";
system cmd;
let cmd = "dbload -d cip -c /usr/informix/dev/load/load.cmd -l /tmp/err_log";
system cmd;
--execute procedure load_data();
end procedure;
DECLARE d_load_legacy PROCEDURE FOR informix.load_legacy ;
EXECUTE d_load_legacy;
IF SQLCA.SQLCode = -1 THEN
MessageBox("Error",SQLCA.SQLErrText,StopSign!)
END IF