| Author |
Message |
 Topic: Reading text files from Broker |
cloucas
Replies: 2
Views: 2230
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 10, 2007 4:13 am Subject: Reading text files from Broker |
I have an application that sends messages as text files with one element per line and with the element name appearing before the value.
I need to use the broker to read these messages and change th ... |
| Topic: Accessing an sql database from ESQL |
cloucas
Replies: 9
Views: 7270
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 10, 2007 4:05 am Subject: Accessing an sql database from ESQL |
Finally got this to work....it appears that the returned object of the query was indeed a complex type and thus I needed to reference the Name element to get to my desired value.
Thanks a lot for ... |
| Topic: Accessing an sql database from ESQL |
cloucas
Replies: 9
Views: 7270
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 10, 2007 1:55 am Subject: Accessing an sql database from ESQL |
thanks for this, i had to change type nvarchar as it is not supported....almost there as i am now reading the value from the database table. I now get the following error:
2007-01-10 11:45:35.0052 ... |
| Topic: Accessing an sql database from ESQL |
cloucas
Replies: 9
Views: 7270
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 09, 2007 11:50 pm Subject: Accessing an sql database from ESQL |
I have done the above and get the following error:
RecoverableException BIP2519E: (, 1.1) : Error executing SQL statement 'SELECT T.Name FROM CIFInquiries T WHERE (T.CIF)=(?)' against datasource ' ... |
| Topic: Accessing an sql database from ESQL |
cloucas
Replies: 9
Views: 7270
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 09, 2007 2:37 am Subject: Accessing an sql database from ESQL |
We use 5.1
I looked a bit into that as well, but couldn't get to the cause of the problem with referencing the database from the esql.....unless I am missing something
Thanks
Chris |
| Topic: Accessing an sql database from ESQL |
cloucas
Replies: 9
Views: 7270
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 09, 2007 2:05 am Subject: Accessing an sql database from ESQL |
I am developing a message flow which is composed of an MQInput, Compute and MQOutput nodes.
The message coming into the MQInput Node is composed of just one string element, customerCode. Based on ... |
| Topic: Problem with parsing tagged delimited messages |
cloucas
Replies: 18
Views: 14438
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 25, 2006 9:40 pm Subject: Problem with parsing tagged delimited messages |
Thanks for your reply.
Let me try to make sure I understood your recommendation correctly:
Since the three transaction messages are in fact elements of the Body structure, I went into the Body s ... |
| Topic: Problem with parsing tagged delimited messages |
cloucas
Replies: 18
Views: 14438
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 25, 2006 12:26 am Subject: Problem with parsing tagged delimited messages |
Ok thanks for this
I have tried to define the messages as tagged delimited with tags the first field and its data. This however creates a problem as it seems to be conflicting with the Physical Pr ... |
| Topic: Problem with parsing tagged delimited messages |
cloucas
Replies: 18
Views: 14438
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed May 24, 2006 1:21 am Subject: Problem with parsing tagged delimited messages |
Thanks for your response...
So, you mean that I can use the element as a tag? Where would I define it as a tag? |
| Topic: Problem with parsing tagged delimited messages |
cloucas
Replies: 18
Views: 14438
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 23, 2006 8:13 pm Subject: Problem with parsing tagged delimited messages |
| Yes, the first field is always fixed and unique for each type of message. It actually contains the type of message. |
| Topic: Problem with parsing tagged delimited messages |
cloucas
Replies: 18
Views: 14438
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 23, 2006 4:25 am Subject: Further info on TDS Parser Problem |
Hi again
The messages themselves do not have a tag. However their first field is always Logical Properties
Complex Type: Composition is SEQUENCE
Content Validation is CL ... |
| Topic: Problem with parsing tagged delimited messages |
cloucas
Replies: 18
Views: 14438
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 23, 2006 2:40 am Subject: Problem with parsing tagged delimited messages |
| I am using TDS to model our host message structure which is composed of a fixed length header, followed by a body. The body is a complex type that consists of a number of tagged delimited messages. ... |
| Topic: TDS Problems |
cloucas
Replies: 5
Views: 6475
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri May 19, 2006 2:22 am Subject: TDS Problems |
Thanks Kimbert
It seems to me that as the error implies, there are indeed more characters in the message than what we have defined in our message set. After the last element, there are about 2000 ... |
| Topic: TDS Problems |
cloucas
Replies: 5
Views: 6475
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 18, 2006 3:18 am Subject: TDS Problems |
Kimbert
Thanks for your swift response. I am on v5, and I have tried the On-Demand Parsing, but that option is not avalable on my version. Assuming I would like to try option 1, is there an easy ... |
| Topic: TDS Problems |
cloucas
Replies: 5
Views: 6475
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 18, 2006 2:25 am Subject: TDS Problems |
I am trying to model our messages using TDS, as follows:
Our Mainframe host application currently sends its responses in 4096 (4K) byte blocks, each composed of the message, padded with spaces to 4 ... |
