Ansicht
Dokumentation

SQL0084 - SQL statement not allowed. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : SQL0084
SQL statement not allowed.

Message Long Text :

Cause . . . . . : The SQL statement is not allowed for one of the following reasons:
-- DECLARE CURSOR, DECLARE STATEMENT, FETCH, OPEN, CLOSE, WHENEVER, PREPARE, EXECUTE, EXECUTE IMMEDIATE, INCLUDE, SELECT INTO, VALUES INTO, DECLARE VARIABLE, DECLARE PROCEDURE, DESCRIBE, GET DIAGNOSTICS, SIGNAL, RESIGNAL, ALLOCATE CURSOR, ASSOCIATE LOCATOR, ALLOCATE DESCRIPTOR, DEALLOCATE DESCRIPTOR, GET DESCRIPTOR, and SET DESCRIPTOR are not allowed in interactive SQL, dynamic SQL, or when using the RUNSQLSTM command.
-- BEGIN DECLARE SECTION and END DECLARE SECTION are not allowed in interactive SQL, in dynamic SQL, in RPG, or in REXX.
-- A blocked INSERT statement is not allowed in interactive SQL or dynamic SQL.
-- The CONNECT, SET CONNECTION, RELEASE, and DISCONNECT statements are not allowed in dynamic SQL or REXX. CONNECT with constants specified for user ID and password is not allowed in a precompiled program.
-- SET ENCRYPTION PASSWORD with constants specified for user ID or hint is not allowed in a precompiled program.
-- SELECT and VALUES cannot be issued from an EXECUTE IMMEDIATE statement or the RUNSQLSTM command.
-- The SET OPTION statement is only allowed in REXX, in a precompiled program, or in SQL routines. In a precompiled program, it must be the first SQL statement in the program.
-- ALLOCATE CURSOR, ASSOCIATE LOCATORS, DECLARE STATEMENT, DECLARE VARIABLE, DECLARE PROCEDURE, GET DIAGNOSTICS, INCLUDE, SELECT INTO, SET CURRENT DEGREE, SET RESULT SETS, SIGNAL, WHENEVER, blocked INSERT, blocked FETCH, locator statements, and SQL descriptor statements are not allowed in REXX.
-- The SET TRANSACTION statement is not allowed when the current connection is to a remote database.
-- The SET SESSION AUTHORIZATION statement can only be run in the default activation group. It is not allowed in REXX, or when using the RUNSQLSTM command.
-- The SQL statement specified is not a valid statement on the current release of DB2 for IBM i. The statement may be valid on a future release of DB2 for IBM i or on some other system's implementation of SQL.
Recovery . . . : The statement cannot be run in this mode. For a CONNECT or SET ENCRYPTION PASSWORD statement in a precompiled program, specify host variables instead of constants. If in interactive SQL, you may syntax check a statement by setting the statement processing value to *SYN.

Message File : QSQLMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3230 Date: 20240426 Time: 200559     sap01-206 ( 3 ms )