RE: Output IBM i query to networked drive

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

If I'm not mistaken, there is a function in SEQUEL allowing read/write to
other boxes as well. No need to let a third party go get their nose into the
tent.

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Vernon Hamberg
Sent: Thursday, March 10, 2016 9:38 AM
To: Midrange Systems Technical Discussion
Subject: Re: Output IBM i query to networked drive

Because of the user/password issue, and other matters, I usually 
recommend using an NFS share - there is a free set of utilities, as I 
recall, that one can put on a Windows box, to enable it as an NFS server 
- this has usually been faster and more reliable than QNTC in my (and 
other's) experience.

Vern

On 3/10/2016 8:52 AM, Bradley Stone wrote:
> I believe since QNTC is similar to a windows server the user ID and
> password you use on your IBM i when connecting needs to match one that is
> set up on the QNTC server.
>
> It's been years since I set something like this up but I know we had to
> switch user IDs before doing anything with files in QNTC to match the ID
on
> the QNTC share.
>
> Our process copied files to the QNTC share to redact information.  So we
> would do this...
>
> 1.  Get the original file from the IFS
> 2.  Change User ID to the ID of the QNTC share
> 3.  Copy the file from the IFS to QNTC
> 4.  Wait until the redaction was done and created a new file
> 5.  Copy the file back to the IFS.
> 6.  Change the User ID back to what it was before.
>
>
> Brad
> www.bvstools.com
>
> On Thu, Mar 10, 2016 at 8:45 AM, Hoteltravelfundotcom <
> hoteltravelfun@xxxxxxxxx> wrote:
>
> > I keep on getting this error on the IBM i  Stream file error - Permission
> > denied
> > I have created a share to QNTC/CUBISCAN
> > and in IBM I I run this
> >   SEQUEL/EXECUTE VIEW(qgpl/statelist)
> >                    OUTFILE() TOSTMF('/QNTC/cubiscan/statelist')
> >
> > On Thu, Mar 10, 2016 at 9:09 AM, Hoteltravelfundotcom <
> > hoteltravelfun@xxxxxxxxx> wrote: