| Author |
Message |
 Topic: Date and Time Manipulation |
vmurdesh
Replies: 10
Views: 5989
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 26, 2003 8:39 am Subject: i think thats a bug |
thanks mgk,
i know it calculates it to 2003-11-31 but when the date is a variable this would imply that you have to check the input date before using the INTERVAL statement which makes it pointless ... |
| Topic: Date and Time Manipulation |
vmurdesh
Replies: 10
Views: 5989
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 25, 2003 12:31 pm Subject: proplem persists even with CSD 5 |
Hi Kiran,
Thanks for your reply.
I installed CSD 5 on NT and tried the foll ESQL in a simple compute node:
DECLARE tempCovExpDateSQL DATE;
DECLARE covExpDateSQL DATE;
SET covExpDateSQL = DA ... |
| Topic: Date and Time Manipulation |
vmurdesh
Replies: 10
Views: 5989
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 20, 2003 10:01 am Subject: So is this a bug in CSD02 ? |
Thanks Lisa....
So is this a bug in CSD02 ? does this mean we would have to do an upgrade for this to CSD05 fron CSD02 ?
Thanks again.. |
| Topic: Date and Time Manipulation |
vmurdesh
Replies: 10
Views: 5989
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 19, 2003 4:58 pm Subject: INTERVAL function does not work in v2.1 CSD02 ? |
Hi,
I tried the following ESQL with the INTERVAL function and it does not work in v2.1 CSD02 on NT ?
DECLARE tempCovExpDateSQL DATE;
SET tempCovExpDateSQL = DATE '2003-08-31' + INTERVAL '3' MON ... |
| Topic: Root SQL exception |
vmurdesh
Replies: 8
Views: 5203
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 13, 2003 8:16 am Subject: Here is the Root and ExceptionList |
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 546
(0x3000000)Code ... |
| Topic: Root SQL exception |
vmurdesh
Replies: 8
Views: 5203
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 12, 2003 5:25 pm Subject: What is the correct syntax for multiple SELECT ? |
My table does have 1 row and i tried with the 'Treat Warnings as Errors'
box both checked and unchecked..
I used the input xml to trigger this select and the SELECT clause as specified on page 1 ... |
| Topic: Root SQL exception |
vmurdesh
Replies: 8
Views: 5203
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri May 09, 2003 12:34 pm Subject: The LIST syntax does not work for Database SELECT |
and i do have 'Treat Warnings as Errors' checked on the advanced tab in your compute node...
Thanks |
| Topic: Root SQL exception |
vmurdesh
Replies: 8
Views: 5203
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri May 09, 2003 10:35 am Subject: Root SQL exception |
Hi,
I get the above 'Root SQL exception' when i do a database select as shown
on page 113 Chapter 8 of the ESQL reference manual..
SET OutputRoot =InputRoot;
SET OutputRoot.XML.Test.Result []= ... |
| Topic: Implementing wild cards in the Input XML |
vmurdesh
Replies: 2
Views: 2350
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 11, 2002 9:15 am Subject: Implementing wild cards in the Input XML |
I need to extract the field from the transactioncode tag in the input XML where the tag before it could be anything (wildcard)
This syntax does not work
SET TranName = InputBody.xl_request.*.transa ... |
| Topic: Stripping out a character like '/' from a string? |
vmurdesh
Replies: 1
Views: 1854
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 28, 2002 11:14 am Subject: Stripping out a character like '/' from a string? |
Hi,
How do we Strip out a character like '/' occuring an unknown number of times from a string in ESQL ?
thanks. |
| Topic: Converting String to BLOB in ESQL |
vmurdesh
Replies: 8
Views: 14973
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 07, 2002 9:44 am Subject: Cool.. With CCSID does work !!! |
I had thought CCSID is only across platforms.
THANKS!!!! |
| Topic: Converting String to BLOB in ESQL |
vmurdesh
Replies: 8
Views: 14973
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 07, 2002 8:20 am Subject: CAST and BITSTREAM both do not work.. |
A CAST does not work.. Gives this in the NT Event Log.
An attempt was made to cast the character string 'JacadaFNOL' to a byte string, but the string was of the wrong format. There must be an even ... |
| Topic: Converting String to BLOB in ESQL |
vmurdesh
Replies: 8
Views: 14973
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 06, 2002 1:55 pm Subject: No deployment or runtime error.. |
The String value in Environment.Variables.ServiceName is just not a part of the myMessage BLOB.
thanks. |
| Topic: Converting String to BLOB in ESQL |
vmurdesh
Replies: 8
Views: 14973
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 06, 2002 11:09 am Subject: Converting String to BLOB in ESQL |
I am trying to convert a string in the Environment tree to a BLOB (without resorting to Hex)
DECLARE myMessage BLOB;
SET myMessage = X'45415F454E' || BITSTREAM(Environment.Variables.ServiceName); ... |
| Topic: MQGet with a wait in a MQSI Message Flow |
vmurdesh
Replies: 3
Views: 4287
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 31, 2002 1:07 pm Subject: MQGet with a wait in a MQSI Message Flow |
| I have my MQSI flow building a xml request and putting to a request queue, Another host applicatoin does a get, processes and puts in a reply q in max 60 seconds (if not time out). The MQSI flow then ... |
