MQSeries.net :: View topic - Add String in ESQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Add String in ESQL

Add String in ESQL

« View previous topic :: View next topic »

Author

Message

lpoon

Posted: Tue Jun 28, 2005 8:38 am Post subject: Add String in ESQL

Newbie

Joined: 27 Jun 2005
Posts: 2

The problem that I have is I have a string of Date and Time. I have already use the SUBSTRING function to seperate the Date and Time of the string. Now, I would like to replace the Date with another Date and append the new Date back to the Time. Basically, the problem is I would like to add two Strings together. Is this possible? I'm very new in coding of ESQL. Please Help....

recallsunny

Posted: Tue Jun 28, 2005 8:52 am Post subject: Concatenate or Add ?

Disciple

Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts

I'm hoping that " Basically, the problem is I would like to add two Strings together " meant you are trying to concatenate two strings....

Code:

DECLARE myStr1 CHARACTER;
DECLARE myStr2 CHARACTER;
SET myStr1 = 'MQSeries';
SET myStr2 = '.net';

DECLARE myConCatStr CHARACTER;
SET myConCatStr = myStr1 || myStr2 ;

-- myConCatStr will now contain 'MQSeries.net'

Cheers

lpoon

Posted: Tue Jun 28, 2005 8:56 am Post subject:

Newbie

Joined: 27 Jun 2005
Posts: 2

Thanks.. =) This is exactly what I'm looking for.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Add String in ESQL

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