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 » ESQL feature

Post new topic  Reply to topic
 ESQL feature « View previous topic :: View next topic » 
Author Message
ernest-ter.kuile
PostPosted: Wed May 15, 2002 5:32 am    Post subject: ESQL feature Reply with quote

Apprentice

Joined: 13 May 2002
Posts: 49
Location: KLM Holland

To my great surprise this little code snippet

Code:

SET the_string = 'hello world' || '
';


actually adds a line feed to the string !

This is a Highly unusual way of programing, and is not described (that I can find) in the documentation.

In fact I didn't know (until I tried) if it added a carriage return, a line feed, or both. Neither do I know if changing the OS will not change the result (or even changing the editor I use to edit the code).


My question is :

is this a Bug ?
is this a feature ?
will somebody at IBM notice and remove this ?

Although it's very handy, it smells bad, and I wonder if I should use this in production code.

Can anybody comment on this ?
Back to top
View user's profile Send private message Visit poster's website
CodeCraft
PostPosted: Fri May 17, 2002 11:01 am    Post subject: Reply with quote

Disciple

Joined: 05 Sep 2001
Posts: 195

I'm sure I posted a reply to this already but it seems to have not made it!

The answer, this is not so much a bug, but an oversight, by whomever coded the EUI, that it continues scanning whitespace and including it in the string even though it wraps onto a new line.

My opinion is that this is most likely to be fixed in some future release, so you SHOULD NOT exploit this 'feature' to solve any particular problem.

I'll bring this to the attention of the appropriate C/T in due course.
Back to top
View user's profile Send private message
ernest-ter.kuile
PostPosted: Mon May 20, 2002 11:51 pm    Post subject: Reply with quote

Apprentice

Joined: 13 May 2002
Posts: 49
Location: KLM Holland

Right, so there still isn't an easy way to add a LF to string, without changing it to a BLOB first.





Ernest ter Kuile.
Back to top
View user's profile Send private message Visit poster's website
CodeCraft
PostPosted: Sat May 25, 2002 12:12 am    Post subject: Reply with quote

Disciple

Joined: 05 Sep 2001
Posts: 195

I've a feeling I've done this before, long ago, by doing something like:

declare crlf character;

And assigning or casting to get the x'10' into the character field, and then appending the crlf string to the data in question. Unfortunately, when I'm on this board I don't actually have access to a WMQI installation!
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 » ESQL feature
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.