Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Create procedure issues -628 when adding QUERY ACCELERATION

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Create procedure issues -628 when adding QUERY ACCELERATION
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

Senior Member


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

PostPosted: Mon Sep 18, 2017 10:01 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Adding comments in Synsort rajiv rengasamy SYNCSORT 18 Fri Jul 13, 2018 3:21 pm
No new posts Query for fetching matching data in t... Poha Eater DB2 10 Mon Jul 09, 2018 6:06 pm
No new posts Varying List Select SQL Query In DB2 ... NikhilGuptaGaya DB2 5 Wed Jun 27, 2018 11:01 pm
No new posts IBM website search issues starting 06... harisukumaran General Talk & Fun Stuff 2 Thu Jun 14, 2018 7:48 pm
No new posts How to force a select query to abend neo4u DB2 7 Mon Apr 23, 2018 1:36 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us