| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Search found 5 matches |
| Author |
Message |
 Topic: MERANT : MAXIMUM OPEN CURSORS EXCEEDED |
JOEL
Replies: 1
Views: 3602
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 20, 2002 6:42 am Subject: MERANT : MAXIMUM OPEN CURSORS EXCEEDED |
it's OK now
IBM recommend us changing argument to the PASSTHRU function
like this :
SET OutputRoot.XML.MSG.TEMP[] = PASSTHRU('SELECT NOS_TRANS_CARAC_FS(?,?,?,?,?) FROM DUAL', . . . .
rather ... |
| Topic: MERANT : MAXIMUM OPEN CURSORS EXCEEDED |
JOEL
Replies: 1
Views: 3602
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 12, 2002 5:23 am Subject: MERANT : MAXIMUM OPEN CURSORS EXCEEDED |
HI,
Environment : MQSI 2.0.2, AIX 4.3, oracle 8.1.7
I have a flow wich use a call to a function in oracle like this :
SET OutputRoot.XML.MSG.TEMP[] = PASSTHRU('SELECT NOS_TRANS_CARAC_ ... |
| Topic: convert BLOB to CHAR |
JOEL
Replies: 10
Views: 10354
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 25, 2002 1:01 am Subject: convert BLOB to CHAR |
THANKS A LOT AT ALL OF YOU,
IT'S WALKING WELL !
I VE AN 'UNDER FLOW' FOR MY BLOB TO CHAR CONVERSIONS |
| Topic: convert BLOB to CHAR |
JOEL
Replies: 10
Views: 10354
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jan 14, 2002 3:21 am Subject: convert BLOB to CHAR |
hi,
Thanks for you translation'idea Mathias.
I use it successfully for a fixed length.
But now I want to have a variable character length.
(to have a generic function)
As you say, i have to u ... |
| Topic: convert BLOB to CHAR |
JOEL
Replies: 10
Views: 10354
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 10, 2002 9:32 am Subject: convert BLOB to CHAR |
My Root is in BLOB domain.
I have to test a part of the Root.
when i do this :
SET OutputRoot.XML.MSG.GEFWRK.V1 = CAST(SUBSTRING(InputRoot."BLOB"."BLOB" FROM 1 FOR 4) AS CHAR);
or
SET Output ... |
|
|
|
