| Author |
Message |
 Topic: any example where ESQL call stored procedure ? |
Edde
Replies: 13
Views: 16285
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 19, 2007 10:52 am Subject: any example where ESQL call stored procedure ? |
Did you create stored procedure under the same user that broker uses to connect to database?
Try to fill scheme name in your ESQL definition. |
| Topic: max no. of app db connections that broker handles? |
Edde
Replies: 3
Views: 4335
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 19, 2007 10:22 am Subject: Re: How the instances work with db2 bind package? |
I don't really know how broker works with the db2 client bind package.
But "Additional Instances=10" means that broker runs 11 instances of flow if needed, so you can have 11 DB connectio ... |
| Topic: Phantom local execution groups |
Edde
Replies: 14
Views: 10344
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 21, 2006 9:31 am Subject: Phantom local execution groups |
Skol: Do you have any clue what causes the execution groups to be created?
I've run to similar problem and it seems that phantom execution groups prevent debugger from working.
I've usually appl ... |
| Topic: Complete noob SELECT into a variable question... |
Edde
Replies: 1
Views: 2762
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 21, 2006 9:15 am Subject: Complete noob SELECT into a variable question... |
Read SET V_LOCATION =
THE (SELECT ITEM X.KEY1_FLD_VAL
FROM Database.v_database.REF_TBL AS X
WHERE X.BUSINESS_UNIT='KR828'
AND X.MAPNAME = 'Location Lookup'
AND X.KEY1 = InputRoot.XML.DATASET. ... |
| Topic: Creating a CWF MRM from an AS/400 (or iSeries) DDS |
Edde
Replies: 2
Views: 2779
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 28, 2006 12:57 am Subject: Creating a CWF MRM from an AS/400 (or iSeries) DDS |
You can create file from DDS on AS/400 and then use JDBC Object Discovery Agent and Business Object Designer to generate xsd.
Then you can create message definition file from xsd.
One problem is ... |
| Topic: cyrillic in ESQL code |
Edde
Replies: 9
Views: 6528
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Nov 26, 2006 11:57 pm Subject: cyrillic in ESQL code |
| Please post ESQL code with CAST that doesn't work and output message. |
| Topic: cyrillic in ESQL code |
Edde
Replies: 9
Views: 6528
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 24, 2006 6:35 am Subject: Re: hi |
well I try to deal with the problem without setting the regional settings to bulgarian because in that way the DB2 generates errors - maybe needs additional settings
I tried to initialize a blob en ... |
| Topic: [SOLVED]ESQL Editor Error with FLOAT |
Edde
Replies: 4
Views: 4826
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 24, 2006 1:13 am Subject: Re: ESQL Editor Error with FLOAT |
DECLARE FVAL FLOAT 0e+0;
What number do you mean? 
Did you try it without '+'? |
| Topic: cyrillic in ESQL code |
Edde
Replies: 9
Views: 6528
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 24, 2006 12:02 am Subject: Re: |
gorjy
Your link points to wrong thread, smth about XML namespaces.
Please correct.
ivan8008
We had have many problems with cyrillic characters in ESQL until we set regional settings to Russian ... |
| Topic: cyrillic in ESQL code |
Edde
Replies: 9
Views: 6528
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 23, 2006 6:04 am Subject: cyrillic in ESQL code |
On what OS are you running?
You have cyrillic names or values? |
| Topic: Handling Special Characters |
Edde
Replies: 1
Views: 2644
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 21, 2006 2:40 am Subject: Re: Handling Special Characters |
Hi,
How to handle special characters(&,$ etc) in XML?
This is one of the part of my input:
<PN>進豪實æ¥Â~!@#$%¬&*()_+}{|\¦¢"'?/`=-</PN>
Iam ta ... |
| Topic: Opening ESQL on node creates new funct. with the same name |
Edde
Replies: 3
Views: 3496
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 20, 2006 8:39 am Subject: Opening ESQL on node creates new funct. with the same name |
This is known bug.
Toolkit "loses" connection between message flow and esql.
But in my case it creates new module in the same .esql file.
Usually rebuild helps.
Or moving smth in mes ... |
| Topic: mqsicreateaclentry |
Edde
Replies: 6
Views: 5990
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 20, 2006 5:59 am Subject: mqsicreateaclentry |
You missed mandatory parameter ((-b broker (-e executionGroup)) | -s | -t | -r | -p).
Try
mqsicreateaclentry XYZPCM00 -u user01 -m machine01 -x F -p -n M:\wmbt6.0\workspace\Servers\WBI_CM_Localhos ... |
| Topic: promoted properties |
Edde
Replies: 7
Views: 4297
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 16, 2006 6:46 am Subject: promoted properties |
You cannot set promoted properties in Compute node.
You can set promoted properties in .bar file or in subflow properties (if you promote properties from subflow).
To set OutputLocalEnvironment.De ... |
| Topic: Handling multiple messages in MqInput node |
Edde
Replies: 1
Views: 2155
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 15, 2006 12:43 am Subject: Handling multiple messages in MqInput node |
That's possible, if you set up Mcd folder in MQRFH2 header of incoming MQ message.
In Mcd folder you can set message domain, message type and message format. |
