Re: -- JAVA400-L

We usually call our RPG programs via stored procedure definitions in SQL.
Then you can use any JDBC driver, *including* DB2 on those platforms for
which it is supported - e.g. AS/400. The DB2 JDBC driver (which uses DRDA
for its distributed SQL processing) supports SNA as well as TCP/IP
connections between AS/400s, but I do not know if it does so on all other
platforms.

So the question is, can you get a DB2 JDBC driver that will work, with SNA,
in your PC server environment? There may well be one shipped with UDB on
NT, but I don't know whether it would support SNA. There are certainly IBM
or third party DB2 drivers for the Windows platform available on various
sites on the Web, but again I don't know if any of them support SNA.

This DB2 driver just provides JDBC support, it doesn't give the record
level access that the TCP/IP-only Toolbox does, unfortunately.

I expect someone else on the list will be able to help with this...anyone
using a DB2 driver on a Windows platform?

Mandy





Hendi Sumarna <HENDI@MULTIPOLAR.CO.ID> on 26/09/2000 09:53:22

Please respond to JAVA400-L@midrange.com

To:   "'JAVA400-L@midrange.com'" <JAVA400-L@midrange.com>
cc:    (bcc: Mandy Shaw/Pacific/UK)
Subject:




Hi,
I try to make a connection from my java program in PC server to AS/400 box.
The problem that I face is I try to use SNA-APPC protocols beside of
TCP/IP.
Here is the questions:
1. Is there any other way to call AS/400 program beside using ProgramCall?
Does IBM also provide some class that is used like ProgramCall but using
APPC?
2. If I want to use DDM features in my java programming, is it possible? Or
is there any way beside using JDBC?
Any idea about those problem?
Thanks in advance.
Hendi
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



      Regards,
      Mandy Shaw

      Catalyst Solutions plc
      Kingfisher House
      Frimley Business Park
      Camberley
      Surrey
      GU16 5SG
      UK

      http://www.catalyst-solutions.com
      Email: Mandy.Shaw@uk.catalyst-solutions.com

      Telephone: +44 (0)870 166 1000
      DDI: +44 870 166 1324
      Facsimile: +44 870 168 3920
      Mobile: +44 410 447966
      Email to mobile 'phone: mandyshaw@sms.genie.co.uk




----------------------------------------------------------------------
----------------------------------------------------------------------
Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

NOTICE:
This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---