| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Appending string using ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| mmarq |
 Posted: Wed Nov 06, 2002 10:45 am Post subject: Appending string using ESQL |
 |
|
Acolyte
Joined: 19 Sep 2002
Posts: 74
Location: Newton, MA
|
It doesn't look like I can do the following:
set stringA = stringB + stringC;
How do I append strings in ESQL?
Thanks,
Melissa
_________________
M Marquis |
|
| Back to top |
|
 |
| mmarq |
| Posted: Wed Nov 06, 2002 10:58 am Post subject: Answer my own question |
|
|
Acolyte
Joined: 19 Sep 2002
Posts: 74
Location: Newton, MA
|
So, for whatever reason, I didn't see the overlay function in the ESQL doc until after I did the post so the answer is:
stringA = overlay(stringA PLACING stringB from (length(stringA)+1) for length(stringB));
_________________
M Marquis |
|
| Back to top |
|
|
| cute_pav |
| Posted: Wed Nov 06, 2002 11:10 am Post subject: |
|
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
>>set stringA = stringB + stringC;
How do I append strings in ESQL?
Ans: SET stringA = stringB || stringC;
(Overlay is expensive function just to append strings  )
pavan |
|
| Back to top |
|
|
| mmarq |
| Posted: Wed Nov 06, 2002 1:24 pm Post subject: Reply |
|
|
Acolyte
Joined: 19 Sep 2002
Posts: 74
Location: Newton, MA
|
Thanks!
So, I can do
set stringA = stringB || stringC || .... on and on?
Thanks - I thought the overlay stuff looked kind of heavy for what I needed to do which is concatenate about 6 items.
-M
_________________
M Marquis |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
