| Author |
Message |
 Topic: ESQL 2.1.0 to ESQL 2.0.1 |
sagwa99
Replies: 2
Views: 2826
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 25, 2002 7:05 pm Subject: ESQL 2.1.0 to ESQL 2.0.1 |
I have ESQL statements in ver 2.1.0 and would like to convert them to ver 2.0.1.
DECLARE A INTEGER;
SET InputLocalEnvironment.Variables.Number[] = PASSTHRU('SELECT COUNT FROM TESTDB.DB2ADMIN.SU ... |
| Topic: Element Length |
sagwa99
Replies: 2
Views: 2426
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Oct 20, 2002 7:59 pm Subject: Element Length |
| Hi Terry. Thanks a lot. |
| Topic: Element Length |
sagwa99
Replies: 2
Views: 2426
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 17, 2002 6:20 pm Subject: Element Length |
I have associated an element length (Length_2) to an element (Field A). I later decided to change the element length to (Length_3). May I know how to make the change? MQSI version is 2.0.1
Thanks. |
| Topic: Error Queue |
sagwa99
Replies: 3
Views: 2422
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 11, 2002 12:54 pm Subject: Error Queue |
For the situation that there are only one MQInput node
and one MQOutput node, should there be an error queue
connected to the failure terminal of the MQInput node? Why?
Thanks. |
| Topic: EBCIDIC signed data to ASCII |
sagwa99
Replies: 18
Views: 12010
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 22, 2002 7:43 pm Subject: EBCIDIC signed data to ASCII |
Hi All,
Thanks a lot for further explanation. Is there a way to parse this type of field using MRM.
I tried the following but having parsing error (invalid extended decimal):
input value = 0 ... |
| Topic: EBCIDIC signed data to ASCII |
sagwa99
Replies: 18
Views: 12010
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 21, 2002 7:37 pm Subject: EBCIDIC signed data to ASCII |
Yes I am refering to "Using the Control Center".
I do not know the pic clause. Refering to page 290 of "Using the Control Center", I interpreted 00123L as sign trailing seperate. May be I have misu ... |
| Topic: EBCIDIC signed data to ASCII |
sagwa99
Replies: 18
Views: 12010
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 21, 2002 7:16 pm Subject: EBCIDIC signed data to ASCII |
I am using v2.0.1. The manual you referred to is for v2.1.
Can v2.0.1 handle this situation?
Thanks. |
| Topic: EBCIDIC signed data to ASCII |
sagwa99
Replies: 18
Views: 12010
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 21, 2002 5:37 pm Subject: EBCIDIC signed data to ASCII |
I could not find the recommended manual "Working with Messages".
However below was my attempt:
singned data (unpacked) from an EBCDIC machine to be converted to ASCII numeric with a '-' sign.
I ... |
| Topic: EBCIDIC signed data to ASCII |
sagwa99
Replies: 18
Views: 12010
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 21, 2002 5:45 am Subject: EBCIDIC signed data to ASCII |
In fact, there are two sets of data, one is packed and the other is unpacked on different projects.
Appreciate help for both requirements.
Thanks. |
| Topic: EBCIDIC signed data to ASCII |
sagwa99
Replies: 18
Views: 12010
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 20, 2002 6:48 pm Subject: EBCIDIC signed data to ASCII |
I like to convert EBCDIC signed data to ASCII numeric with a '-' sign if the number is negative.
Please help. |
| Topic: Data conversion using compute node |
sagwa99
Replies: 4
Views: 3293
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jun 29, 2002 8:35 pm Subject: Data conversion using compute node |
Stuart,
Thanks for your input. It works.
CodeCraft,
Would you further elaborate on how to change the CCSID in the properties folder/tree or let me know where can I get more information? I would ... |
| Topic: Data conversion using compute node |
sagwa99
Replies: 4
Views: 3293
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 27, 2002 7:38 pm Subject: Data conversion using compute node |
To convert the incoming message from EBCDIC(not packed data) to ASCII.
Can the conversion being done using compute to set encoding & CCSID without creating MRM message set?
Compute Node (Copy ... |
| Topic: Padding Character |
sagwa99
Replies: 4
Views: 3761
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 24, 2002 6:52 pm Subject: Padding Character |
Thanks. It worked  |
| Topic: Padding Character |
sagwa99
Replies: 4
Views: 3761
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jun 16, 2002 7:14 pm Subject: Padding Character |
I tried but it does not work. Could you provided further details? For example the incoming message is:
111
222222
Field_One (String length 3, CWF padding 0x0D)
Field_Two (String length 6)
... |
| Topic: Padding Character |
sagwa99
Replies: 4
Views: 3761
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 14, 2002 8:35 pm Subject: Padding Character |
Could someone let me know the padding character for a carriage return.
Thanks |
