Re: Output IBM i query to networked drive

Now i changed to a root folder but it gets further but has this error

SEQUEL/EXECUTE VIEW(qgpl/statelist)
TOSTMF('/root/home/statelist')
Function check. CEE9901 unmonitored by QRYO07 at statement *N,
instruction X'00F6'.

On Thu, Mar 10, 2016 at 10:59 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

THis is going off on a tangent but even when I sign on as SECOFR, it is
not letting me change the permissions to READ WRITE. The owner of the QNTC
is QOBJOWN. and here that one has no password and you cant login to it.

On Thu, Mar 10, 2016 at 10:41 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx>
wrote:

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:

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.