Tech question for a PowerBuilder user...
Posted in 1998
Topics: Stored Procedures & SPL
I have a technical question for someone who knows PowerBuilder and stored
procedures in Informix. If you can help out I'd really appreciate it.
When creating a new datawindow in PB 5.0, I choose "Stored Procedure" and
"Freeform" as the type. The stored procedure I choose comes from the Informix
database (It's a healthy stored procedure because it runs just fine in the
database itself). So far so good except that PowerBuilder gives me zero
opportunity to define a result set. Apparently PB thinks there is no result
set, but have a look below--the result set is two integer fields:
-- This procedure runs in Unix just fine, but a PB datawindow can not be
-- created from it... I don't know why...
CREATE PROCEDURE chris_report2()
RETURNING INT, INT;
define TOTAL_A integer;
define TOTAL_B integer;
LET TOTAL_A = (select count(emp_id) FROM emp_tbl);
LET TOTAL_B = (select count(product_id) FROM prod_tbl);
RETURN TOTAL_A, TOTAL_B;
END PROCEDURE;
Any thoughts? I'm hoping this will be easy because I'm very new to working with
Informix stored procedures in PB and something simple could very easily pass me
by. If I need to give more detail, please post your question for all to see.
Thanks so much for any help.
--Chris O'Keefe
Chris2508@aol.com