| Author |
Message |
 Topic: How do you trim tabs with the TRIM function? |
cayenne
Replies: 7
Views: 5334
|
 Forum: General IBM MQ Support Posted: Wed Mar 07, 2007 8:21 am Subject: Thank you. |
| CCSID is "CodedCharSetID" or "Coded Character Set ID" - it's the number that tells various things which text format to interpret the bytes as - ASCII, EBCDIC, Unicode, Windows text ... |
| Topic: How do you trim tabs with the TRIM function? |
cayenne
Replies: 7
Views: 5334
|
Forum: General IBM MQ Support Posted: Wed Mar 07, 2007 7:43 am Subject: Thank you! |
Okay, ESQL won't evaluate a symbolic constant like \t or /t.
You can either determine the hex value of a horizontal tab in the CCSID of the message, or you can explicitly type a horizontal tab insi ... |
| Topic: How do you trim tabs with the TRIM function? |
cayenne
Replies: 7
Views: 5334
|
Forum: General IBM MQ Support Posted: Wed Mar 07, 2007 6:18 am Subject: I've tried... |
Read the broker manual on how it handles a tab.
If you look for the java version of the tab it should be \t
Enjoy 
I've tried looking through all the documentation that I have available so ... |
| Topic: How do you trim tabs with the TRIM function? |
cayenne
Replies: 7
Views: 5334
|
Forum: General IBM MQ Support Posted: Tue Mar 06, 2007 2:39 pm Subject: How do you trim tabs with the TRIM function? |
Hello!
I'm trying to learn the TRIM function functionality, and I've come upon something I can't find out there in the literature.
I see that for character data, the default trim_singleton is a ... |
| Topic: [where ?] UPDATE statement with nested SELECT syntax error? |
cayenne
Replies: 7
Views: 8963
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 31, 2007 11:16 am Subject: sorry? |
Can Someone tell me how this relates to MQWorkflow?
I'm new to the forum...this is a problem I'm having in a message flow I'm working on...
Whbic forum would this would this be best posted to? |
| Topic: [where ?] UPDATE statement with nested SELECT syntax error? |
cayenne
Replies: 7
Views: 8963
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 30, 2007 10:27 am Subject: Re: Trying an UPDATE statement with nested SELECT, syntax er |
Hi cayenne,
Declare name ?? U could have used CHAR.
UPDATE table AS A SET....similarly AS B...
Regards.
Strange....when I did my first database access with MQ...I tried CHARACTER, but, it wo ... |
| Topic: [where ?] UPDATE statement with nested SELECT syntax error? |
cayenne
Replies: 7
Views: 8963
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 30, 2007 8:52 am Subject: [where ?] UPDATE statement with nested SELECT syntax error? |
Hello all,
I'm quite the MQ noob, and I'm also trying to hook to a DB2 database, my background is from Oracle. I'm getting a fairly non-specific syntax error message in my toolkit from this bit of ES ... |
| Topic: Complete noob SELECT into a variable question... |
cayenne
Replies: 1
Views: 3172
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 21, 2006 8:54 am Subject: Complete noob SELECT into a variable question... |
Hi all,
I'm brand new to MQ and Websphere, trying to learn as I code. I'm looking and I don't see an example in the ESQL docs or in my searches in the forum for what I'm trying to do. Should be simp ... |
