The admin_cmd calling describe call statement hangs or throws
SQL0469N
Repro -
connect to sample;
CREATE PROCEDURE newton.noLobProc ( out parm1 SMALLINT, out
parm2 INT, out parm3 BIGINT, out parm4 REAL, out
parm5 FLOAT, out parm6 DOUBLE, out parm7 CHAR(200),
out parm8 VARCHAR(200), out parm9 LONG VARCHAR, out
parm10 DATE, out parm11 TIME, out parm12 TIMESTAMP )
EXTERNAL NAME 'blah!blah' DYNAMIC RESULT SETS 0 FENCED LANGUAGE
C PARAMETER STYLE DB2SQL;
DESCRIBE call newton.noLobProc( 1, ? , 8, ?,?,? ,? ,? ,? ,?,?,
12 );
CALL ADMIN_CMD ('DESCRIBE call newton.noLobProc( 1, ? , 8, ?,?,?
,? ,? ,? ,?,?, 12 )');
SQL0469N The parameter mode OUT or INOUT is not valid for a
parameter in the
routine named "NOLOBPROC" with specific name
"SQL091021065248000" (parameter
number "1", name "PARM1"). SQLSTATE=42886 |
****************************************************************
* USERS AFFECTED: *
* users of DESCRIBE command using admin_cmd *
****************************************************************
* PROBLEM DESCRIPTION: *
* connect to sample; *
* *
* CREATE PROCEDURE newton.noLobProc ( out parm1 SMALLINT, *
* out parm2 INT, out parm3 BIGINT, out parm4 REAL, *
* out parm5 FLOAT, out parm6 DOUBLE, out parm7 *
* CHAR(200), out parm8 VARCHAR(200), out parm9 LONG *
* VARCHAR, out parm10 DATE, out parm11 TIME, out parm12 *
* TIMESTAMP ) EXTERNAL NAME 'blah!blah' DYNAMIC RESULT SETS 0 *
* FENCED LANGUAGE C PARAMETER STYLE DB2SQL; *
* *
* *
* *
* DESCRIBE call newton.noLobProc( 1, ? , 8, ?,?,? ,? ,? ,? *
* ,?,?, 12 ); *
* *
* CALL ADMIN_CMD ('DESCRIBE call newton.noLobProc( 1, ? , 8, *
* ?,?,? ,? ,? ,? ,?,?, 12 )'); *
* *
* above call to admin_cmd might hang. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 fp3 or use parmater marker inplace of user *
* supplied values *
**************************************************************** |
use parameter marker(?) instead of user supplied values.
the following call works..
CALL ADMIN_CMD ('DESCRIBE call newton.noLobProc( ?, ? , ?,
?,?,? ,? ,? ,? ,?,?, ?)'); |
