There's no easy way for debugging stored procedures in Informix. If you can afford it, you can use Server Studio (
http://www.serverstudio.com/ first 30 days it is free for use, and after that most features are disabled).
You can use Informix native debugging with trace:
CREATE PROCEDURE ah() RETURNING VARCHAR(100); DEFINE part CHAR(30);
DEFINE ret VARCHAR(100);
LET ret = "";
set debug file to "/tmp/ah.trace.txt";
-- if using windows
-- set debug file to "c:\temp\ah.trace.txt";
FOREACH SELECT partnum INTO part FROM partmaster WHERE partnum MATCHES 'A*' trace on;
LET ret = ret || "|" || TRIM(part);
trace off;
END FOREACH
RETURN ret;
Or if you want just to debug
part you can use trick:
CREATE PROCEDURE ah() RETURNING VARCHAR(100); DEFINE part CHAR(30);
DEFINE ret VARCHAR(100);
LET ret = "";
set debug file to "/tmp/ah.trace.txt";
-- if using windows
-- set debug file to "c:\temp\ah.trace.txt";
FOREACH SELECT partnum INTO part FROM partmaster WHERE partnum MATCHES 'A*'
trace on;
LET part = part;
trace off;
LET ret = ret || "|" || TRIM(part);
END FOREACH
RETURN ret;
HTH
dBforums
>
How do I show debug from a PROCEDURE CURSOR LOOP
11-27-08, 08:59
Linear Mode
