Re: Remote Query/SQL

[Rob Berendt <rob@xxxxxxxxx>]

In English to 'look up' means to study.  So in this case you 
would study suitable reference materials.  One suggestion is 
the following:
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AQ902/5.10.3





Qin_Huang@schindler.com on 05/11/2000 10:45:04 PM
Please respond to RPG400-L@MIDRANGE.COM@Internet
To:     RPG400-L@MIDRANGE.COM@Internet
cc:      
Fax to: 
Subject:        Re: <insert subject line here please>




Could you kindly tell me how to..

       set up proper WRKRDBDIRE on both machine
                       and
       look up CONNECT statement

?

thanks and best regards,
sorry for no subject tho.

hqin




owner-rpg400-l@MIDRANGE.COM on 2000-05-09 21:21:53

Please respond to RPG400-L@MIDRANGE.COM

To:   RPG400-L@MIDRANGE.COM
cc:
Subject:  <insert subject line here please>


DDM files are not supported via Query/400.

If you set up the proper WRKRDBDIRE on both machines you should be
able to use SQL.  Look up the CONNECT statement.  However the BEST
method for the money is to create a Query Management Query using
either STRQM (if you have a copy of the files on the 170) or by
brute force.  Then port that to the 720 and use STRQMQRY to execute
it.





Qin_Huang@schindler.com on 05/08/2000 09:12:53 PM
Please respond to RPG400-L@MIDRANGE.COM@Internet
To:  RPG400-L@MIDRANGE.COM@Internet
cc:
Fax to:
Subject:




Dear all,

I have a model 720 installed BPCS405CD, however we have no Query nor SQL on that
machine, we have a old slower model 170 with sql and Query, is it possible for
me to access and update the date in IIM file of the Model 720 from old one Model
170?

thanks in anticipation of your kindly help
hqin


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


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






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


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