| Author |
Message |
 Topic: Need best performing ESQL or method to determine if XML Msg |
brenner
Replies: 14
Views: 8655
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Sep 30, 2005 1:31 am Subject: Need best performing ESQL or method to determine if XML Msg |
Best to try:
DECLARE cursor REFERENCE TO Root.XML;
IF LASTMOVE(cursor) THEN -- it is xml !!..
...
ELSE -- it is blob
...
END IF; |
| Topic: Oracle where clause with Date function |
brenner
Replies: 8
Views: 12341
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 01, 2005 1:47 am Subject: Oracle where clause with Date function |
and a better option is to write an Oracle stored procedure that takes
2 imput parameters and returns a result set. Then you can use
PASSTHRU to invoke the stored procedure and get the result set tha ... |
| Topic: Oracle where clause with Date function |
brenner
Replies: 8
Views: 12341
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 01, 2005 1:31 am Subject: Oracle where clause with Date function |
Please see the wmqi readme file, defect 31642 for a work around using PASSTHRU.
Else you'll have to remove the date from the where clause and then
filter the result set from the select within your E ... |
| Topic: Oracle where clause with Date function |
brenner
Replies: 8
Views: 12341
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 01, 2005 12:43 am Subject: Oracle where clause with Date function |
| What level of MQSI and Oracle ? |
| Topic: Calling procedure with REFERENCE ELEMENT |
brenner
Replies: 5
Views: 4914
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 16, 2004 12:18 am Subject: Calling procedure with REFERENCE ELEMENT |
Try calling your stored procedure using passthru, that will build your
tree automatically, for example:
SET poutref.ABC[]= PASSTHRU('{CALL PLN.SP0001 (?, ?, ?)}', parm1,parm2,parm3); |
| Topic: ESQL POSITION command - syntax error |
brenner
Replies: 5
Views: 7728
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 08, 2004 11:22 pm Subject: ESQL POSITION command - syntax error |
The POSITION function was upgraded in V5. Pre V5 the syntax was
POSITION (search_string IN source_string);
The improved V5 is
POSITION(SearchExpr IN SourceExpr FROM FromExpr REPEAT RepeatExpr); ... |
| Topic: How To Find The Day of Week for A Given Date? |
brenner
Replies: 17
Views: 11840
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 08, 2004 11:01 pm Subject: How To Find The Day of Week for A Given Date? |
Why not use the EXTRACT function instead of
DECLARE y Int Cast(Substring(DateInC From 9 for 2) as Int);
for example
DECLARE y INT EXTRACT (DAY FROM DateInC); |
