RE: Use of the IFS

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, January 02, 2009 7:19 AM
To: Midrange Systems Technical Discussion
Subject: Re: Use of the IFS

First off, your problem isn't that the data is being transferred, the
problem is that the data exists in two places; in the i as a DB file
and as a PC stream file.

I agree. The "problem" is that the data is duplicated in two places. One
place, on the "i", seems to be the master copy. The PC copy seems to be
so that the data can be used in a PC application (likely Winblows).

Having the stream file version on the i isn't going to do a whole lot
for you IMHO.

I will disagree here. Transferring the data from a DB file to an stream
file would be easier if the stream file were on the i. Why? Because the
process which updates the DB file on the "i" could be extended to make
corresponding updates on the stream file. Perhaps even some sort of
"trigger" action on the update of the DB. But I am not very familiar
with how DB2 on the "i" works. I'm not very DB2 literate at all.

What data is the warehouse modifing/adding from the PC and what
application is being used to do it?

This is the difficult part. How to "back port" the updates made to the
stream file to the DB file. I don't know enough about the i to know if
there is some sort of "hook" or "exit" which could be used to monitor
the stream file for changes.

Have you looked at getting rid of the requirement for the stream file
version completly and just providing the user with a way to modify the
data in the i DB file as needed?

This would be best. Eliminate the stream file entirely by replacing it
with ODBC access or something akin to that.

Charles

In all the above, please remember that I am not an "i" person, I am a
"z" person who is only starting to learn the "i" (and I don't have an
"i" available as yet).

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)
Administrative Services Group
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential or proprietary information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.