MQSeries.net :: View topic - How to read a file from esql

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to read a file from esql

Goto page Previous 1, 2

How to read a file from esql

« View previous topic :: View next topic »

Author

Message

zpat

Posted: Tue Jul 29, 2008 4:35 am Post subject:

Jedi Council

Joined: 19 May 2001
Posts: 5867
Location: UK

Unless the reference data is changing frequently you can just load it into the database manually. Why are you hung up on processing files in the broker?

If you don't know how to use a database or the DB/2 utilities then find someone to help you.

This is not one task, it is two completely separate tasks.

1 - Load the database table from a file of reference data (maybe manually) or using fileinput nodes if it needs frequent changes.

2 - Use the database table to validate message fields.

nagarjun_vv

Posted: Tue Jul 29, 2008 11:48 pm Post subject: good zpak

Apprentice

Joined: 24 Jun 2008
Posts: 33

I 100% agree with ZPAK.

Use the database , fill all the required data in the database.

If at all the values will be changing based upon some other message then

use another flow(or subflow) for reading that particular message and insert those values in the database and start using those values . When you got another messge then delte old values and insert new values. But using database is the best way for this.

Regards,
Nagarjun.

SOLOHERO

Posted: Thu Jul 31, 2008 9:59 pm Post subject:

Centurion

Joined: 01 Feb 2007
Posts: 107

1. Use Select statement to validate the Country Code.

Sample Code:
SET TEMP =
THE(SELECT ITEM R.CountryCode FROM RoutingTable.CountryCodes[] AS R WHERE R.CountryCode = InputRoot.CountryCode);
_________________
Thanks

Display posts from previous:

Goto page Previous 1, 2

Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to read a file from esql

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP