IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Create procedure issues -628 when adding QUERY ACCELERATION


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 41
Location: Bangalore

PostPosted: Mon Sep 18, 2017 12:16 pm
Reply with quote

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                                                                                                                 
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2508
Location: NY,USA

PostPosted: Mon Sep 18, 2017 10:01 pm
Reply with quote

Can you try as a BIND OPTION instead?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Mainframe ISPREDIT Macro query TSO/ISPF 3
No new posts In JCL Procedure how we can execute R... CLIST & REXX 7
No new posts DEBUG COMMENT command not adding to log IBM Tools 1
No new posts Add the name in the PS file and creat... DFSORT/ICETOOL 9
No new posts DFSORT Output file order query DFSORT/ICETOOL 2

Back to Top