| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Look up file creation to access predefined table of values |
« View previous topic :: View next topic » |
| Author |
Message
|
| ENVYMB |
 Posted: Fri Dec 20, 2013 3:28 am Post subject: Look up file creation to access predefined table of values |
 |
|
Newbie
Joined: 19 Nov 2013
Posts: 7
|
Hi All,
I have a table of values which i want to store in some file and fetch the value from the file from a ESQL code based on some conditions. I understand , a database table can be created and data can be fetched based on conditions.
I want to know is there any way to create a look up file as we are not ok with database approach..
Thanks,
ENVYMB |
|
| Back to top |
|
 |
| Simbu |
| Posted: Fri Dec 20, 2013 3:36 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
| Hi, FileRead node has some options which will help you. |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Dec 20, 2013 3:59 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
If you need high performance, you might want to put the file contents in the Global Cache ( if not v8 or higher) or in a SHARED ROW variable ( if on v7 ).
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Dec 20, 2013 4:48 am Post subject: Re: Look up file creation to access predefined table of valu |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| ENVYMB wrote: |
I want to know is there any way to create a look up file as we are not ok with database approach..
|
Can you please explain why this is a problem for you?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
