| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| LTRIM |
« View previous topic :: View next topic » |
| Author |
Message
|
| anshu |
 Posted: Mon Jun 05, 2006 8:10 am Post subject: LTRIM |
 |
|
Novice
Joined: 23 Jan 2006
Posts: 19
|
What's wrong with this syntax
SET OutputRoot.XML.Message.Destination = LTRIM(DESID, '0');
The manual does does say you can use a LTRIM with a parameter. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Jun 05, 2006 8:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| iceage |
| Posted: Mon Jun 05, 2006 8:22 am Post subject: |
|
|
Acolyte
Joined: 12 Apr 2006
Posts: 68
|
Answer is in the manual , from WBIMB V5 Information center
| Quote: |
| LTRIM is a string manipulation function, used for manipulating all data types (BIT, BLOB, and CHARACTER), that returns a character string value of the same data type and content as source_string, but with any leading default singletons removed. |
| Quote: |
The default singleton depends on the data type of source_string:
Character ----> ' ' (space)
BLOB ---> X'00'
Bit ----> B'0' |
All in all, you cannot specify 2nd argument to LTRIM , for what you want tp do , from the manual again
| Quote: |
| The LTRIM function is equivalent to TRIM(LEADING FROM source_string). |
Good luck
[/quote] |
|
| 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
|
|
|
|
