| Author |
Message |
 Topic: Need help on the use of PASSTHRU in WMB 6.1.0.4 and Oracle11 |
vijsam
Replies: 11
Views: 6166
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 16, 2012 7:26 am Subject: Need help on the use of PASSTHRU in WMB 6.1.0.4 and Oracle11 |
declare x character ;
SET x =
'UPDATE Database.tablename AS A
SET a= ?
,b = ?
,c= ?
,d= ?
WHERE A.fieldname = '';
passthru(x); |
| Topic: Need help on the use of PASSTHRU in WMB 6.1.0.4 and Oracle11 |
vijsam
Replies: 11
Views: 6166
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 16, 2012 7:09 am Subject: Need help on the use of PASSTHRU in WMB 6.1.0.4 and Oracle11 |
hi,
use AS in your sql query like 'UPDATE MYDB.LOG.SESSION_DB AS T SET QUERY_IN_PROGRESS '
go through the link
http://www.mqseries.net/phpBB2/viewtopic.php?p=169860&sid=d2124a0bcf77c0531 ... |
| Topic: count related function in esql |
vijsam
Replies: 12
Views: 20040
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 03, 2012 12:49 am Subject: count related function in esql |
Thanku all for the valuable inputs  |
| Topic: count related function in esql |
vijsam
Replies: 12
Views: 20040
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 02, 2012 7:16 am Subject: count related function in esql |
Hello All,
I need to count how many times a particular character in a string is repeatating,
example want to calculate the number of commas in value like:sam,ram,mbm. need your asisatnce. |
| Topic: ImbRecoverableException caught from worker->parseN |
vijsam
Replies: 13
Views: 9374
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 22, 2011 7:22 am Subject: ImbRecoverableException caught from worker->parseN |
My cobol copy book does not containOCCURS 0 TO 10 DEPENDING ON field Z These values,so trying to add OCCURS in Min and Max occurs in cobol copy book.
without editing Message Defination file,Iam editi ... |
| Topic: ImbRecoverableException caught from worker->parseN |
vijsam
Replies: 13
Views: 9374
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 22, 2011 3:42 am Subject: ImbRecoverableException caught from worker->parseN |
any inputs..............  |
| Topic: ImbRecoverableException caught from worker->parseN |
vijsam
Replies: 13
Views: 9374
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 22, 2011 12:11 am Subject: ImbRecoverableException caught from worker->parseN |
| HI, Without changing in message defination file min and max occurs Iam trying to change the cobol copy book and add WMOD-TEST-RQST OCCURS 0 TO 60 TIMES,it is not allowing to create Message defina ... |
| Topic: ImbRecoverableException caught from worker->parseN |
vijsam
Replies: 13
Views: 9374
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 21, 2011 7:26 am Subject: ImbRecoverableException caught from worker->parseN |
Hi,
I have done user trace and even in usertrace i could not find any error information.Consider if there are multiple occurences for a particular field and when i try to create Message defination fi ... |
| Topic: ImbRecoverableException caught from worker->parseN |
vijsam
Replies: 13
Views: 9374
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 21, 2011 6:30 am Subject: ImbRecoverableException caught from worker->parseN |
Hi all,
I am taking input as BLOB and when trying to convert it MRM using CREATE LASTCHILD OF OutputRoot DOMAIN('MRM') PARSE(InputRoot.BLOB.BLOB, encoding,ccsid,'G096BQO002001','msg_MESSAGE','Binar ... |
| Topic: MQGet node Exception-Error creating converter |
vijsam
Replies: 10
Views: 6440
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 15, 2011 6:55 am Subject: MQGet node Exception-Error creating converter |
This is used for setting MQIIH headers at the begging
All you need is ESQL which adds the MQIIH header but specifies where in the tree it should be positioned; either before the data or after the MQM ... |
| Topic: MQGet node Exception-Error creating converter |
vijsam
Replies: 10
Views: 6440
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 15, 2011 6:20 am Subject: MQGet node Exception-Error creating converter |
I was able to set the headers as explained by you in previous link .Iam setting the messageDomain as blob to accept the headers and actual data.
I have set the properties in MQGet settings as :
Inpu ... |
| Topic: MQGet node Exception-Error creating converter |
vijsam
Replies: 10
Views: 6440
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 15, 2011 5:00 am Subject: MQGet node Exception-Error creating converter |
Hi All,
Iam adding MQIIH headers before hitting Mainframe application,Iam using MQGet node which ll receive the message from Mainframe appliation,Iam setting Message Domain as BLOB,in MQGet node iam ... |
| Topic: MQIIH header is coming after actual data |
vijsam
Replies: 8
Views: 5130
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Dec 13, 2011 6:59 am Subject: MQIIH header is coming after actual data |
| Thank you all for the quick responseAll you need is ESQL which adds the MQIIH header but specifies where in the tree it should be positioned; either before the data or after the MQMD Can you Please el ... |
| Topic: MQIIH header is coming after actual data |
vijsam
Replies: 8
Views: 5130
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Dec 13, 2011 6:37 am Subject: MQIIH header is coming after actual data |
Do i need to create a new message defination file for adding MQIIH headers ?
I have added the MQIIH code at starting of the flow.
Do i need to add it in Copy Message headers?
|
| Topic: MQIIH header is coming after actual data |
vijsam
Replies: 8
Views: 5130
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Dec 13, 2011 6:17 am Subject: MQIIH header is coming after actual data |
I am trying to add the MQIIH . I am able to do that using the SET OutputRoot.MQIIH.
Actually THE MQIIH header should be at the start of the data along with LL,ZZ,Trancode.but the actual data is comin ... |
