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 2 matches
Author Message
  Topic: How to set Timestamp multiple times in ESQL
vrathod2

Replies: 15
Views: 20673
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Sep 29, 2021 10:23 am   Subject: How to set Timestamp multiple times in ESQL
Write a Java class to return what you need and call that from ESQL ?

Let me expand a little on this answer with an insight into why this is an answer.


The values returned with the CURRENT_TIME ...
  Topic: How to set Timestamp multiple times in ESQL
vrathod2

Replies: 15
Views: 20673
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Sep 29, 2021 10:21 am   Subject: How to set Timestamp multiple times in ESQL
Nope, just for getting system timestamp suggesting to use Java its not good one.

You can use PASSTHRU to achieve this

Ex:

PASSTHRU 'INSERT INTO ' || cDBSchema || '.TPI_CURRENT_MASTER VALUES(C ...
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.