var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OS/ 390 Call a Stored Procedure from QMF
OK...I finally wrote a sproc in DB2 on the mainframe (and a trigger and a udf..)
How do you execute the sproc in QMF? I can't figure it out
Should it be as simple as
Re: OS/ 390 Call a Stored Procedure from QMF
OK...how do you call a stored procedure from anywhere?
Nothing about QMF...
Originally posted by Marcus_A
What do the manuals say?
and it say the syntax is call...but that don't work...
The code builds the proc just fine...but how do you execute it?
Or can't you execute procs in QMF...I would understand why not...
--CREATE PROCEDURE QUERY_TAB
--(IN TABNAME CHAR(18))
-- DECLARE V_NAME CHAR(18);
-- SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = TABNAME;
OK what's the syntax for a call in client server?
PROC syntax in DB2 is painful...
Why isn't as simple as
CREATE PROC myProc
@x int, @y in out
SELECT @y=COUNT(*) FROM SYSCOLUMNS