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: 1806
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 HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
This topic is locked: you cannot edit posts or make replies. rexx to create a tso command Bharath Vikraman CLIST & REXX 1 Tue Aug 08, 2017 3:32 pm

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