RE: NFS mount -- MIDRANGE-L

I already use a "pull" that employs an FTP get on the SQL server box since that box does not have an FTP server active that I can "push" to.
But it does have IBM Client Access installed so I use RUNRMTCMD to launch a .vbs script on the SQL Server box which performs an FTP get from the i5.
I would like to improve on this somewhat convoluted solution.

I'm not sure the QNTC route is at all straight forward. I think there are pre-requisite setup steps on the other box that must be addressed by administrators there and since they never heard of system i5 that usually ends up as too hard for them.

Peter

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S Waterbury
Sent: Sunday, 2 June 2013 1:30 p.m.
To: Midrange Systems Technical Discussion
Subject: Re: NFS mount

Hi, Pete:

You might want to investigate the QNTC (NetClient) file system -- it provides a way to access the NT file system from OS/400 ...

Or, you could use OS/400 NetServer that provides "shares" that can be accessed from Windows ... so you could copy the file from the IFS on
OS/400 to Windows ... via NetServer ... but this will need to be a "pull" from NT rather than a "push" from the OS/400 side.

HTH,

Mark S. Waterbury

On 6/1/2013 9:18 PM, Peter Connell wrote:
Mark
Sigh. I figured it could not be just easy.

Thanks, Peter

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S Waterbury
Sent: Sunday, 2 June 2013 1:05 p.m.
To: Midrange Systems Technical Discussion
Subject: Re: NFS mount

Windows does not support NFS "out of the box". You would have to buy some NFS software for Windows and install it, or find suitable NFS freeware, shareware or "open source" equivalent, and install and use that.

> On 6/1/2013 8:56 PM, Peter Connell wrote:

I want to load a file in a database on SQL Server 2008 R2 using SQL bulk insert from a csv file.
So that I can use the IFS on the i5 I would like to mount the SQL server using the MOUNT command but need some advice as this is new to me.
The MOUNT cmd has the format MOUNT TYPE(*NFS) MFS(?????)
MNTOVRDIR(??????) and I need to know what to specify for MFS and
MNTOVRDIR

The host name of the SQL Server box is nzaklgl-db601.corp.bayadv
which can be pinged from the i5 and returns an IP address of
10.9.64.65 If I log on to the SQL Server machine and look at the
drives via Windows Explorer I see the following

Computer
OS(C:)
Data(F:)
Logs(H:)
Work(I:)
Backup(K:)
...
...

I figure that I need a folder in one of these drives to be the target of the MOUNT.
So what do I specify for MFS and MNTOVRDIR?

Peter

#####################################################################
#
###############

This correspondence is for the named person's use only. It may
contain confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately
delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual
sender, except where the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :- Australia
1300-762-207 or New Zealand +64 9 367 6200

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

######################################################################
###############

This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual
sender, except where the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :- Australia
1300-762-207 or New Zealand +64 9 367 6200

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

#####################################################################################

This correspondence is for the named person's use only. It may contain confidential
or legally privileged information, or both. No confidentiality or privilege is waived
or lost by any mistransmission. If you receive this correspondence in error, please
immediately delete it from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual sender, except where
the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :-
Australia 1300-762-207 or New Zealand +64 9 367 6200