ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Initialising eSQL variables on DECLARE

Post new topic  Reply to topic
 Initialising eSQL variables on DECLARE « View previous topic :: View next topic » 
Author Message
wolstek
PostPosted: Fri May 16, 2003 5:39 am    Post subject: Initialising eSQL variables on DECLARE Reply with quote

Acolyte

Joined: 25 Jun 2001
Posts: 52
Location: Bristol, UK
We tried to initialise variables on the DECLARE statement replacing

DECLARE nInteger INTEGER;
SET nInteger = 10;
DECLARE sString CHARACTER;
SET sString CHARACTER 'teststring';

With

DECLARE nInteger INTEGER 10;
DECLARE sString CHARACTER 'teststring';

and it all works fine, the trace files shws the correct setting of values

However there is no mention of this in the manuals
Is this a supported function of initialisation withi eSQL or did we just get lucky
Cheers,
Back to top
View user's profile Send private message
Craig B
PostPosted: Wed Jun 18, 2003 12:52 am    Post subject: Reply with quote

Partisan

Joined: 18 Jun 2003
Posts: 316
Location: UK
This functionality was introduced in WMQI V2.1 CSD03 and is documented in the V2.1 CSD release guide. This new capability also allows multiple variables of the same datatype to be declared in the same DECLARE statement. For example :

Code:

DECLARE myInt1, myInt2 INT;
DECLARE myInt3, myInt4 INT 5;


The last DECLARE statement would declare two integers called myInt3 and myInt4 and initialise them to the value of 5. Not only is the ESQL more compact when editing but it also faster performing since multiple ESQL statements do not need to be executed.
_________________
Regards
Craig
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Initialising eSQL variables on DECLARE
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.