RE: [SYSTEM21] Connectivity question

["Neil Thursby" <neil.thursby@xxxxxxxxxxxxxxxxxxxx>]

Thanks to all who responded.  We are now trialling one product and still 
looking at dataq's as an alternative.

Best regards,

Neil.

-----Original Message-----
From: Rob Rogerson [mailto:rrogerson@xxxxxxxxxxxxxxxxx]
Sent: Wednesday 09 February 2005 14:17
To: 'System 21 Users'
Subject: RE: [SYSTEM21] Connectivity question


Yet another solution I have used in the past with Oracle and DB2/400 is
to use Java and JDBC.

You mentioned an RPG solution so this may not be the solution you are
looking for.

Rob

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
jroesch@xxxxxxxxxxxxxxx
Sent: Wednesday, February 09, 2005 9:09 AM
To: system21@xxxxxxxxxxxx
Subject: RE: [SYSTEM21] Connectivity question

One method is to write your output to an AS400 file.  SQL can be setup
to
pull data on a timely, nightly for example, but this is not real time
basis.


Another more real time method is to simply FTP the data to SQL Server
from
your RPG program.       


-----Original Message-----
From: Neil Thursby [mailto:neil.thursby@xxxxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, February 09, 2005 6:42 AM
To: System 21 Users
Subject: [SYSTEM21] Connectivity question

A little off the System 21 subject I'm afraid, but wonder if anyone can
help;

I need to write some records from an RPG program to a SQL Server table.
There are a few products out there that claim to enable this.  Has
anyone
got any experience of these products?  Another approach might be a dataq
with a vb.net program at the Pc end - again has anyone used a dataq in a
vb.net program to receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please
do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission
from
your system.

Although we have taken steps to ensure that this email and attachments
are
free from viruses, we advise that in keeping with good computing
practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means
of
email communications.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


_____________________________________________________________________
This transmission and any attachments are confidential and are intended solely 
for the named addressee (s). If you are not the addressee, please do not read, 
copy, use or disclose this transmission and please notify us immediately by 
telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from 
your system.

Although we have taken steps to ensure that this email and attachments are free 
from viruses, we advise that in keeping with good computing practice the 
recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of email 
communications.