| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL function to read String values? |
« View previous topic :: View next topic » |
| Author |
Message
|
| giorginus80 |
 Posted: Mon Mar 30, 2009 5:55 am Post subject: ESQL function to read String values? |
 |
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
Hello,
in esql how can I know if a character variable contains a value or start with a specific value? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Mar 30, 2009 5:57 am Post subject: Re: ESQL function to read String values? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| giorginus80 wrote: |
| in esql how can I know if a character variable contains a value or start with a specific value? |
POSITION
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| zpat |
| Posted: Mon Mar 30, 2009 6:10 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| IF LEFT(String,5) = 'VALUE' THEN etc |
|
| Back to top |
|
|
| mgk |
| Posted: Mon Mar 30, 2009 7:31 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hello.
WMB 6.1.0.3 has some new ESQL string functions including;
STARTSWITH, ENDSWITH and CONTAINS. It also added the BEFORE and AFTER clauses to the SUBSTRING function.
Regards,
MGK
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| 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
|
|
|
|
