| Author |
Message |
 Topic: Getting data from database |
vishal
Replies: 17
Views: 7258
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jul 18, 2004 6:43 pm Subject: Getting data from database |
The result set from the query returns with the column name col1.
Try this one
SET AA =RTRIM(OutputLocalEnvironment.Variables.col1[2].col1);
SET OutputRoot.MYMSG.DATA.col1=AA;
I guess thi ... |
| Topic: Handling low values in MRM |
vishal
Replies: 2
Views: 2290
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat May 29, 2004 8:48 pm Subject: Handling low values in MRM |
I have a task in, which I transform the MRM to XML. Some of the fields passed from the legacy system would contain low values (HEX zero's)..In this case I would like to eliminate
the XML tag.
My out ... |
| Topic: Pcaked decimal problem casting |
vishal
Replies: 11
Views: 5466
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Apr 03, 2004 7:04 pm Subject: Pcaked decimal problem casting |
Kiran,
Thanks for the response..Sorry for the confusion..Disregard my earlier message.The cobol copy book is ok..I misprinted the format..
It is the same as you suggested....
So, when I importe ... |
| Topic: Pcaked decimal problem casting |
vishal
Replies: 11
Views: 5466
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Apr 03, 2004 2:10 pm Subject: Pcaked decimal problem casting |
OK....HERE IS WHAT I DID..
I tried the other way round..
I defined the logical structure in the MRM as below:
I just defined a field as an Integer.
PHYSICAL TYPE: Packed decimal.
length co ... |
| Topic: Pcaked decimal problem casting |
vishal
Replies: 11
Views: 5466
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Apr 02, 2004 5:51 pm Subject: Pcaked decimal problem casting |
Can you plz suggest or post the code in ESQL for casting..
One more thing to keep in mind is the incoming field is in COMP-3 so, the parser would always treat it as a packed decimal. and the logica ... |
| Topic: Pcaked decimal problem casting |
vishal
Replies: 11
Views: 5466
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Apr 02, 2004 12:42 pm Subject: Pcaked decimal problem casting |
I am getting a field from mainframes side as PIC S(07) v99 COMP-3
When I imported MRM created a logical type as an integer and the physical type as packed decimal with a count of 5.Does the count t ... |
| Topic: Repeat fields |
vishal
Replies: 8
Views: 4229
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 01, 2004 10:58 am Subject: Repeat fields |
When I assigned the integer value for the count field ..It looks like it is not parsed as expected 003 to 3..But when I checked the option of the extended decimal it is parsed in predictable way.
... |
| Topic: Repeat fields |
vishal
Replies: 8
Views: 4229
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 01, 2004 5:07 am Subject: Repeat fields |
NO..THATS JUST A EXAMPLE...
The outgoing XML message does look different....
May be I am missing the basics here..when we assign the count field as integer..does MRM take it as 03 or 3.
In my ... |
| Topic: Repeat fields |
vishal
Replies: 8
Views: 4229
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 31, 2004 10:41 pm Subject: Repeat fields |
DECLARE J INTEGER;
SET J=1;
Coorection in the code... |
| Topic: Repeat fields |
vishal
Replies: 8
Views: 4229
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 31, 2004 10:39 pm Subject: Repeat fields |
| I have to convert a cobol copy message to XML format.In the cobol copy book message there is a field which is a compound element and can occur no: of times (dynamic) depending upon the another field j ... |
| Topic: Importing cobol copy books |
vishal
Replies: 6
Views: 3892
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 24, 2004 5:11 pm Subject: Importing cobol copy books |
Thanks,
That really worked ....
I have a task to convert XML message to MRM. I am using RFH UTIL for PUT and GET messages.The message has been successfully processed and got commuted to the Outp ... |
| Topic: Importing cobol copy books |
vishal
Replies: 6
Views: 3892
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Mar 19, 2004 4:10 pm Subject: Importing cobol copy books |
I was trying to Import the cobol copy book layout to message set...But couldn't get all the fields in the cobol copy book.I am using WMQI v 2.1.
I checked it couple of times if the allignmnet of th ... |
| Topic: XML to COBOL copy book format.. |
vishal
Replies: 2
Views: 1896
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 25, 2004 5:04 pm Subject: XML to COBOL copy book format.. |
Hi guys,
This is the first time I am posting in this group..moreover I am new to WMQI.. This is the case..
I have an input message in XML format and need to convert it into Cobol copy book forma ... |
