jokerjoe6773
asked on
Automate transfer from AS400 to a PC
I need to transfer 4 files from a AS400 to a pc share. The files are CSV files if that matters. I know how to set the schedule up on the 400 to create the files I just don't know how to do the actual transfer from the 400 where the file is created to the pc where the file needs to be. Please be as specific as you can be since I am not a 400 guru.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Where are the file now? QSYS? IFS?
Steve
Steve
ASKER
I need it automated. They are in QSYS
ASKER
Here is what I would like to have happen...I would like to create a share and have the query write to that share then maybe map a drive on the PC to that share.
Is this pc share on the 400 or on a windows machine?
If it is on a PC then cause your AS/400 userid and password to match your windows userid and password and the try this: wrklnk '/QNTC/*'
you will be presented with a list of shares that the 400 can see. Do you see the one you are looking for? If you do then Gary's #5 will do the job.
If it is on the 400 let me know. I have more recommendations.
Steve
If it is on a PC then cause your AS/400 userid and password to match your windows userid and password and the try this: wrklnk '/QNTC/*'
you will be presented with a list of shares that the 400 can see. Do you see the one you are looking for? If you do then Gary's #5 will do the job.
If it is on the 400 let me know. I have more recommendations.
Steve
ASKER
I don't really have the share set up yet...I actually want it on the 400 but I'm not sure how to go about making a share that I can put a query in. See what I have is a query that I want to run at night and that query creates a CSV file which in turn is used by a program that is located on a PC. The program on the PC just needs access to those files.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...then cause your AS/400 userid and password to match your windows userid and password...
That piece is often not possible. A more reasonable way to do it is to create a local user on the PC that is exporting a share and have it match an AS/400 profile (and password). Many Windows user profiles are network profiles, so creating a local Windows user on that PC is a workable alternative. The structure of the name and the password can be easier to match up.
Tom
That piece is often not possible. A more reasonable way to do it is to create a local user on the PC that is exporting a share and have it match an AS/400 profile (and password). Many Windows user profiles are network profiles, so creating a local Windows user on that PC is a workable alternative. The structure of the name and the password can be easier to match up.
Tom
For a user to read/write to the IFS, it needs to be configured in WRKDIRE. So you need to create the PC user on the AS400.
For a user to read/write to the IFS, it needs to be configured in WRKDIRE. So you need to create the PC user on the AS400.
I'm pretty sure that I use the IFS on numerous systems where my profile is not in the system directory. All you need is a profile with adequate authority to the folder (and files, of course).
I'm pretty sure that I use the IFS on numerous systems where my profile is not in the system directory. All you need is a profile with adequate authority to the folder (and files, of course).
The WRKDIRE entry is only required when the old/obsolete /QDLS file system is used. Almost no one should be using it nowadays.
Tom
Tom
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Used XTMENU to complete the process.
You could use a Robo-FTP script running on the PC to download the file, retry failed downloads, and send the support team an email or SMS text if download fails repeatedly.