RE: Query over DDM?

["Bull, Jeff" <BullJ1@xxxxxxxxxxxxxxxx>]

Hi Larry, 
I would tend to create a DDMF link to the remote file, then use CPYF to
retrieve the data, using INCCHAR, INCREL, FROMRCD-TORCD or FROMKEY-TOKEY to
pre-select the dataset if the remote file is large, then run query over the
retrieved data.  Query will not allow you to specify a DDMF as one of the
input files.  This could all be wrapped up and simplified in a CL program if
it is a regular report/extract.

Kind regards,
Jeff Bull.
Senior Support Consultant
Certified IBM AS/400 System Administrator
Midas Kapiti International Ltd

Tel:    44 (0) 175 370 8224
Fax:    44 (0) 175 357 0233
Mailto:Jeff.Bull@Midas-Kapiti.Com  << == Replies to 
The views and opinions expressed in this e-mail are the senders own and do
not necessarily represent the views and opinions of Misys Plc.

This email message is intended for the named recipient only.  It may be
privileged and/or confidential.  If you are not the intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose its contents to any other person.  You should
contact Midas-Kapiti International as shown below so that we can take
appropriate action at no cost to yourself.

Midas-Kapiti International Ltd, Key West, 53-61 Windsor Road, Slough,
Berkshire, SL1 2DW, England
Email: Postmaster@midas-kapiti.com Tel: (44) 1753 573244 Fax: (44) 1753
570233
Midas-Kapiti International Ltd is registered in England and Wales under
company no. 971479
 

-----Original Message-----
From: Larry Bolhuis [mailto:lbolhuis@arbsol.com]
Sent: Friday, February 09, 2001 2:12 PM
To: Midrange Systems Mailing List
Subject: Query over DDM?


I seem to remember trying to use Query over a DDM connection and having
it fail. Is there a way to use Query to access files on another AS/400
in the network? (In this case 100MB LAN connection between machines.)

 Thanks!

  - Larry

-- 
Larry Bolhuis
Arbor Solutions, Inc.
(616) 451-2500
(616) 451-2571 -fax
lbolhuis@arbsol.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
+---