| Author |
Message |
 Topic: Database insertion error - SQL7967 |
RITCHEA
Replies: 1
Views: 3828
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 21, 2011 11:32 pm Subject: Database insertion error - SQL7967 |
When I am inserting the data into DB2 AS400 database it is giving me error-:[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7967 - PREPARE of statement ZBNKP completed...
Please help. |
| Topic: SMS integration with Message broker |
RITCHEA
Replies: 3
Views: 2578
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 30, 2011 8:22 pm Subject: SMS integration with Message broker |
I want to do the SMS integration with Message broker please give me some useful link and reference link  |
| Topic: MOVE statement |
RITCHEA
Replies: 9
Views: 7186
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 13, 2011 3:01 am Subject: MOVE statement |
I am trying to Move to next child element in loop ....
Get the start and end field index from the database.
Initialize an array variable Fields[10] with default values of each
field.
De ... |
| Topic: MOVE statement |
RITCHEA
Replies: 9
Views: 7186
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 13, 2011 2:42 am Subject: MOVE statement |
Set Environment.variables = THE(select p.Start from Database.email_req AS p);
Set Environment.variables = THE(select t.ended from Database.email_req AS t);
-- ---- work ---------
DECLARE i IN ... |
| Topic: MOVE statement |
RITCHEA
Replies: 9
Views: 7186
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 13, 2011 2:09 am Subject: MOVE statement |
| I tried MOVE nextsibling but it didnt work... |
| Topic: MOVE statement |
RITCHEA
Replies: 9
Views: 7186
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 13, 2011 1:34 am Subject: MOVE statement |
if my tree structure is like
data.customer.fname
data.customer.lname
data.customer.age
I want to move from fname to lname and then age using move statement in ESQL.... Is that possible. |
| Topic: Way to move emails to folder |
RITCHEA
Replies: 4
Views: 2773
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 29, 2011 9:10 pm Subject: Way to move emails to folder |
| I want to move the mails(IMAP) which are read by the message broker from input box to other folder, so that even if the mail is marked as unread again is not consumed by the email input node... |
| Topic: Way to move emails to folder |
RITCHEA
Replies: 4
Views: 2773
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 29, 2011 8:24 pm Subject: Way to move emails to folder |
| Is there any way in message broker so that we move the inbox mails to other folder of same account... please help... |
| Topic: email sever object not found |
RITCHEA
Replies: 2
Views: 1745
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 07, 2011 10:38 pm Subject: email sever object not found |
when i am running command-
mqsicreateconfigurableservice MB7BROKER -c EmailServer -o myservice -n serverName,securityIdentity -v pop3://Myserver.com:110,mySecurityIdentity
on MB command console.. ... |
| Topic: get messages in email input node |
RITCHEA
Replies: 19
Views: 15759
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 06, 2011 3:05 am Subject: get messages in email input node |
able to solve this problem...
just need to write following ESQL in compute node to get first attachment
CREATE LASTCHILD OF OutputRoot DOMAIN 'BLOB' PARSE (InputRoot.MIME.Parts.Part[2].Data.BLOB ... |
| Topic: get messages in email input node |
RITCHEA
Replies: 19
Views: 15759
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 24, 2011 3:28 am Subject: get messages in email input node |
the following is the message i am getting as output of emailinput node, but what i require is just the attachment part (999,MUR1234567890124,2,RTG,20030811,1125,2,0,XXXXXXXXX,CANBH03127000003,21
,,,, ... |
| Topic: get messages in email input node |
RITCHEA
Replies: 19
Views: 15759
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 23, 2011 11:25 pm Subject: get messages in email input node |
but i unable to check if the attachment received is text or csv...
i ran following code on filter node
IF Root.MIME.Parts.Content-Type= '*.txt' THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
... |
| Topic: get messages in email input node |
RITCHEA
Replies: 19
Views: 15759
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 23, 2011 11:22 pm Subject: get messages in email input node |
yes, thankfully i have resolved the problem i ran following commands on MBcomamnd console:
mqsideleteconfigurableservice MB7BROKER -c EmailServer -o myservice
mqsicreateconfigurableservice MB7BROK ... |
| Topic: get messages in email input node |
RITCHEA
Replies: 19
Views: 15759
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 23, 2011 3:23 am Subject: get messages in email input node |
| Is there any way one can check in filter node that the attachment received in email input node...is csv or text...from email input node... |
| Topic: get messages in email input node |
RITCHEA
Replies: 19
Views: 15759
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 22, 2011 9:57 pm Subject: get messages in email input node |
| still unable to find the problem.... |
