× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 2015

Re: Using CONNECT to a remote system with RUNSQLSTM

Yep, see my 2nd reply that I sent after seeing your post on 3-part naming.

I checked the parameter - it depends on another parameter, where you set *DUW or *RUW - not too picky in my mind, since the default for that parameter is *DUW, which does allow setting OUTFILE.

In any case, I reminded by you about the 3-part naming - haven't had to use it yet.

Thanks
Vern

On 7/28/2015 11:57 AM, rob@xxxxxxxxx wrote:
Vern, I ran it just fine with RUNSQLSTM.

Vern, remember he was trying to insert locally from a remote database. I
am under the impression that using the relational database parameter of
STRQMQRY has the statement run there. If you read the help on that
parameter the OUTFILE parameter gets really picky when you specify a
remote database.

Best to be on a version of the OS that will be supported in more than two
months and just use the three part syntax.


Rob Berendt


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.