Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 2325
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
No new posts Large'ish Working Storage and SOS issues govindc CICS 0 Sat Jan 18, 2020 1:58 am
No new posts IFTHEN HIT=NEXT BUILR should create m... speermb DFSORT/ICETOOL 5 Fri Jan 10, 2020 10:49 pm
No new posts Rexx to create VSAM define statements Dinesh Mani CLIST & REXX 10 Fri Nov 29, 2019 9:26 pm
No new posts Usage of pre-processor statement in p... Sakthidevi PL/I & Assembler 1 Thu Nov 28, 2019 4:08 pm
No new posts Query on JCL abdulrafi DFSORT/ICETOOL 5 Wed Oct 16, 2019 7:02 pm

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