Using CPYFRMIMPF to transfer data from CSV file to custom table on AS4. Thanks. Well let you know when a new response is added. Can any one tell me if there is an easy way to convert as400 spool files to a fornat that can be imported into excel currently i am modifying programs to buil. Ive always found the easiest weay to do what you trying to do is create the file on iseries with fields matching the file on the PC and then use the the File transfer from 4. FDF. Once you have the downloaded file matching the file format of the original PC file, you can use the transfer to A0. FDF and the system will map it out. No need to convert to CSV first. What is the error message identifier The message text is almost useless to us. What versionrelease of the operating system are you running Is that an accurate representation of the CPYFRMIMPF command that you showedIts hard to determine an answer since there is almost no useful info to go on. However, it looks like youre leaving out some likely necessary parameters from the command. For example, without knowing any more, Id bet that you need to specify something other than the default for the RCDDLM parameter. Most likely it should be RCDDLMCRLF. Any number of other possibilities exist. Did you look at reason 5 and did you even try the suggested recovery TomTom, if your intention is to supplement this discussion for later reference, then why not just provide the useful comments you have instead of appearing antagonistic in the response to the original poster whos probably figured it out by now, or gotten the assistance they needed, since this question is from almost two years ago CWC. N1017285&aid=4' alt='Copy As400 File Text File' title='Copy As400 File Text File' />I can verify the copy doesnt work at V6R1, but you can circumvent that. Net Framework 3.5 Standalone Installer For Windows 8. I have a physical file with a 133 record length on my box that Ive been using to copy spool. N1018362&aid=1' alt='Copy As400 File Text File' title='Copy As400 File Text File' />In iSeriesAS400 Save files are very handy in saving objects, complete libraries, IFS directories and files and then restoring them back on the same or different. Winx Hd Video Converter Deluxe Crack. I want to create a procedure for creating a text file to store the output of a query. In DB2 running on AS400. Ultimate Force Torrent. I am using 7. 5 version of DB2AS400. In some cases, we will need to inspect the LPlpr and LPcon for the problem spooledfile. You can use the FileOpen menuoption to display all your converted. Q I am looking for a way to print the subsystem description for each subsystem on the AS400. I have only found a way to do this one subsystem at a time.