Re: Output IBM i query to networked drive

Then you probably don't want TOSTMF('/root/home/statelist'). You want
TOSTMF('/home/statelist').



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

there is no root/home

there is wrklnk home

On Thu, Mar 10, 2016 at 11:46 AM, Gerald Magnuson <
gmagqcy.midrange@xxxxxxxxx> wrote:

just to clarify...
if you type "WRKLNK "/root/home/"
what do you see?



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

no just root

On Thu, Mar 10, 2016 at 11:33 AM, Gerald Magnuson <
gmagqcy.midrange@xxxxxxxxx> wrote:

do you have a folder named "root" off the root "/"?


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

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.

--
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.

--
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.

--
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.