RE: AS400....is it really an "Open" system??

[ray@xxxxxxxxxxxx]

I've found this question and answer in the September 1999 Tech Corner
of News400. I think Paul Conte answered this.
________________________________________________________________
Q: I have an application that runs on a V4R1 AS/400 and needs to
access data (interactively) from an Oracle7 database that runs on
a Unix box. How can I access Oracle from the AS/400 without buying
a separate product to do this?

A: You can access a non-UDB/400 database from an AS/400 application
by using OS/400's SQL Client Integration (SQLCI) feature. SQLCI lets
you specify an application requester program (ARD) on the ADDRDBDIRE
command. The ARD routes AS/400 SQL requests to the non-IBM database.
Oracle provides an ARD called Oracle Access Manager for AS/400 as well
as other tools to support IBM's Distributed Relational Database
Architecture (DRDA). For more information about this ARD, visit Oracle's
Web page at http://www.oracle.com/gatewa ys/cd/products/group3.html.

I hope this helps some of you Oracle guys...
Ray


-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Art Tostaine, Jr.
Sent: Wednesday, April 11, 2001 2:20 PM
To: MIDRANGE-L@midrange.com
Subject: RE: AS400....is it really an "Open" system??


I've tried the port that the SQL guys think it is, I've tried sqlserv, still
no good.

A search on Deja (now google), turned up this snippet that says it doesn't
work:

>Unfortunately SQL Server does not support DRDA AS (server-side), which
>would enable (for example) RPG with embedded SQL on AS/400 to access SQL
>Server tables.  OS/400 does support a DRDA "application request driver"
>exit program, that could also enable access to SQL Server, but I don't
>know if anyone has written an ARD for SQL Server.
>Karl Hanson

I'd love to make this work.  Anymore details that you can post would be
appreciated.

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Chris Bipes
Sent: Wednesday, April 11, 2001 11:34 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: AS400....is it really an "Open" system??


Unfortunately I am no SQL Server expert.  I just know that it can be done,
with some limitations.  On the WRKRBDDIRE command you can specify the port
name.  The default is *DRDA.  Check out what port the SQL server is
listening at and use that port.  The default is sqlserv or 118.  You can
enter the service name or the port number directly.

Christopher K. Bipes      mailto:ChrisB@Cross-Check.com
Operations & Network Mgr          mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.          http://www.cross-check.com
6119 State Farm Drive     Phone: 707 586-0551 x 1102
Rohnert Park CA  94928    Fax: 707 586-1884

-----Original Message-----
From: Art Tostaine, Jr. [mailto:art@link400.com]
Sent: Wednesday, April 11, 2001 7:30 AM
To: MIDRANGE-L@midrange.com
Subject: RE: AS400....is it really an "Open" system??


Chris:

I've tried this and can only access AS/400 databases.  I can guess that the
SQL server has to be running DRDA?  How can I tell the SQL server guys what
they need to configure on the SQL Server?  They have heard of DRDA but never
used it.

The SQL server database that I am trying to connect to is running a canned
imaging application.  There is no real "SQL Server" expert at my customer.

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---