chandraBE
New User
Joined: 02 Feb 2010 Posts: 44 Location: Bangalore
|
|
|
|
Hi
The below stored procedure creation worked fine before we added below line.
Code: |
QUERY ACCELERATION ENABLE WITH FAILBACK |
Can you please help us in understanding what is the clause getting conflict/issue with QUERY ACCELERATION option?
Code: |
CREATE PROCEDURE XXXXX.XXXXXXXX(
PROCNM CHAR(18) IN,
PARMLST CHAR(254) OUT)
LANGUAGE COBOL
DETERMINISTIC
READS SQL DATA
EXTERNAL NAME "XXXXXX"
QUERY ACCELERATION ENABLE WITH FAILBACK
COLLID XXXXXXXXXX
ASUTIME NO LIMIT
PARAMETER STYLE GENERAL WITH NULLS
STAY RESIDENT NO
RUN OPTIONS 'HEAP(,,ANY),STACK(,,ANY,),STORAGE(,,,4K),BELOWHEAP(4K
,,),LIBSTACK(4K,,),ALL31(ON)'
WLM ENVIRONMENT XXXXXXXX
PROGRAM TYPE MAIN
SECURITY DB2
RESULT SETS 2
COMMIT ON RETURN NO;
|
Issued below message:
Code: |
SQLERROR ON CREATE COMMAND, PREPARE FUNCTION
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -628, ERROR: THE CLAUSES ARE MUTUALLY EXCLUSIVE
DSNT418I SQLSTATE = 42613 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHSMP2 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 27 0 0 -1 149 2905 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'0000001B' X'00000000' X'00000000' X'FFFFFFFF' X'000
INFORMATION
|
|
|