MQSeries.net :: View topic - Adding single quotes in string

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 » Adding single quotes in string

Adding single quotes in string

« View previous topic :: View next topic »

Author

Message

gheekshike

Posted: Tue Mar 11, 2014 4:27 am Post subject: Adding single quotes in string

Novice

Joined: 13 Dec 2012
Posts: 11

I have requirement like this

DECLARE test CHARACTER 'TIMESTAMP ' || ''' || str2 || ''';

Resulting string should be TIMESTAMP '2013-12-22 00:00:00'

but here i need the str2 value should be dynamic...

How would be the syntax???

Plz help me its urgent..

Thanks in advance

sandman147

Posted: Tue Mar 11, 2014 11:20 am Post subject:

Apprentice

Joined: 01 Sep 2013
Posts: 42

what is str2?

Tibor

Posted: Wed Mar 12, 2014 1:22 am Post subject:

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

Quote:

but here i need the str2 value should be dynamic...

What does dynamic mean in your context?

Gralgrathor

Posted: Wed Mar 12, 2014 7:17 am Post subject: Re: Adding single quotes in string

Master

Joined: 23 Jul 2009
Posts: 297

gheekshike wrote:

DECLARE test CHARACTER 'TIMESTAMP ' || ''' || str2 || ''';

Resulting string should be TIMESTAMP '2013-12-22 00:00:00'

What are you trying to do?
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine.

smdavies99

Posted: Wed Mar 12, 2014 11:53 pm Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

The question could not have been that urgent. I guess the poster has found the answer by other means.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Adding single quotes in string

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