RE: ISeries - Mainframe Communications

Is the file on the mainframe stored in DB2?  If so, register the database in 
WRKRDBDIRE, then write a program to 

CONNECT TO OS390HOST;
Create table QTEMP/MYDATA as
(
        Select * from mydata
) with data;

CONNECT TO ISERIESHOST;
Create table PRODLIB/MYDATA as
(
        Select * from QTEMP/MYDATA
) with data;

This could probably be done as a stored procedure.....

BTW, I'd pass on the Elmo, but I wouldn't say no to a PS3.....  <vbg>


Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On 
Behalf Of Weber, Richard
Sent: Thursday, September 21, 2006 3:07 PM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: ISeries - Mainframe Communications


All,

 

I need some suggestions.  I have just been given an assignment to research a
project to permit our local ISeries RPG programs to communicate with and
access data in a cross reference file on our 390 mainframe.  I am looking
for advice on how to use native devices or third party products or anything
else out there.  One system I have already been asked to look at is MQ
Series.

 

The design we envision would maintain a mirror in each country's iSeries
system of the mainframe file.  The system needs to keep the mirror file
synchronized with the mainframe on its own.  The reason we need this design
as opposed to accessing the mainframe file directly is to keep the local
system running in the event of a communications interruption.

 

Sorry, I can't award a new Tickle Me Elmo doll to the winning idea.  All I
can do is offer my thanks and gratitude.

 

Regards.

 

Richard L. Weber  |  Senior Systems Analyst, TOYS 'Я' US International  |
973.617.3497  |  weberr@xxxxxxxxxxx <mailto:weberr@xxxxxxxxxxx> 

 

                     There are only 10 kinds of people in the world:  Those
that understand binary and those that do not.

 


======================================================================== 
This email message is for the sole use of the intended recipient (s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies
of the original message. To reply to our email administrator directly, send
an email to EmailAdmin@xxxxxxxxxxxx 
Toys "R" Us, Inc.