With your client accession open click on action in the tool bar.
Then select reciev file from host and follow the prompts as needed.

Can any one of you tell me how to use Client access to transfer database from host to PC text file?

Start-> Programs-> IBM iSeries Access-> Data Transfer From iSeries Server

Then fill in the values that you need, and click the <Transfer data…> button.

Since we don’t know anything about the server, the PC nor the data requirements, that’s about all we can say.

Tom

These are the options that i need to fill to get the text file into my PC using client access. But i am getting stck in the part “To Folder”.. If i give my local folder name in my PC, it is not accepting that.. It says member not copied to PC document.

Copy To PC Document (CPYTOPCD)

Type choices, press Enter.

From file . . . . . . . . . . . Name
Library . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
To folder . . . . . . . . . . .

From member . . . . . . . . . . *FIRST Name, *FIRST
To document . . . . . . . . . . *FROMMBR Name, *FROMMBR
Replace document . . . . . . . . *NO *NO, *YES
Translate table . . . . . . . . *DFT Name, *DFT, *NONE
Library . . . . . . . . . . . Name, *LIBL, *CURLIB
Format of PC data . . . . . . . *TEXT *TEXT, *NOTEXT

Copy To PC Document (CPYTOPCD)

The CPYTOPCD command is not a Client Access command, and it does not copy to a “PC”. It copies to a “PC document”. The document will still be on the AS/400. Generally, the command is obsolete and should no longer be used.

The Client Access commands are on the PC, not on the AS/400.

Please describe the business process that you are trying to do.

Tom

What i need to do is to copy a PF from AS400 to text file (in PC). I tried for Reflection but facing issue with larger files. I heard from some one it can be done using Client Access which is an IBM tool (i Access). I found an option Client Access/400 tasks (in which i found the option CPYTOCPD). I thought this can be the option. So is there some other way to use Client access.
In file transfer setup, under option transport i found Client Access/400 (usually given FTP/IP). But when i select this option, it throws an error: “File not found. You should exit reflection & rerun setup”.

The general problem is that the question asks about to do something with Client Access, but the OP is using Reflection. The ‘Answer’ should start with “Install Client Access before asking how to make a Client Access function work.”Tom