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 » Search

 Search found 3 matches
Author Message
  Topic: Getting the current sequence number from DUAL in Oracle
smurthy

Replies: 9
Views: 7140
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Jun 18, 2002 6:36 am   Subject: ESQL For Compute Node to Select Sequence Number from DUAL
Here is my exact code:
On the Compute Node you are using, set The Adavanced tab to Message and Local Environment. This is a PASSTHRU statement do it should deploy properly. Also, remember SEQ_CorrelI ...
  Topic: Getting the current sequence number from DUAL in Oracle
smurthy

Replies: 9
Views: 7140
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Jun 18, 2002 6:11 am   Subject: Getting the current sequence number from DUAL in Oracle
You do not need to use a stored procedure just to get the sequence number. It seems like alot of work to do something very simple.

Cheers,
Suntosh
  Topic: Getting the current sequence number from DUAL in Oracle
smurthy

Replies: 9
Views: 7140
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Jun 17, 2002 9:35 am   Subject: Select From DUAL
Use the following code:

Set OutputLocalEnvironment.ScratchPad[] = PASSTHRU('Select SEQ_ID.CurrVal From DUAL;');

Remember for this to work you have to create the sequence in SQL:
create sequence ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


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

Copyright © MQSeries.net. All rights reserved.