IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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: 44
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: 3048
Location: NYC,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

 


Similar Topics
Topic Forum Replies
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts RC query -Time column CA Products 3
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Adding first / last acct numerber to ... DFSORT/ICETOOL 7
Search our Forums:

Back to Top