|
midrange.com
Yes, the WRKRDBDIRE does some nice things. However calling a stored
procedure on a remote system, and expecting a result set, will fail.
For example the following works (I am leaving out the /EXEC SQL stuff):
CONNECT TO :rmtsys
UPDATE filename SET fielda = :vara where keyfield=:keyvalue
CONNECT TO LOCAL
But trying to call a stored procedure which returns it values via the
following fails:
* input parameters - Used in place of *ENTRY PLIST
D BOM220FILE PI
D UsrLib 10A
D Parent 15A
D KFaci 2A
------------ 48 data records excluded --------
C/EXEC SQL
C+ SET RESULT SETS ARRAY :Parm1 FOR :Row1 ROWS
C/END-EXEC
Rob Berendt
==================
Remember the Cole!
ray@esprinkle.cc
Sent by: To:
<MIDRANGE-L@midrange.com>
owner-midrange-l@mi cc:
drange.com Subject: RE: AS400....is it
really an "Open" system??
04/10/01 09:33 PM
Please respond to
MIDRANGE-L
Thanks Christopher !!!
It looks like I have some digging to do
to figure out how to use this.
Ray
-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Chris Bipes
Sent: Tuesday, April 10, 2001 8:18 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: AS400....is it really an "Open" system??
Actually you can access data from any SQL server with the as400.
WRKRDBDIRE
is the command to configure remote data bases for you to access via SQL or
DRDA.
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: ray@esprinkle.cc [mailto:ray@esprinkle.cc]
Sent: Tuesday, April 10, 2001 3:56 PM
To: MIDRANGE-L@midrange.com
Subject: AS400....is it really an "Open" system??
I have a question that maybe someone on the list
can answer.
Several years ago a major effort was made to make
the AS400 more open. Other platforms could access
our data....etc. And this was achieved for all
intents and purposes.
But nothing has been done to allow us to access
data from another systems database....such as
SQLServer.
Perhaps I'm wrong or not informed. Is there a way
to access data from another system via RPG in
a realtime fashion? And if we can't why isn't
there any grumbling about this?
+---
| 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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
