Create a Directory on your PC and run the ftp command from this directory CDxxxxxx FTP Commands: (Type Highlighted Commands) ftp xxxxx (xxxxx AS400 System name or AS400 IP Address, you must be able to ping either one to use) User: qsecofr Password: xxxxxx (Password for QSECOFR, qsecofr is the administrator account on the AS400) bin (bin binary image or try the get command below without using bin) get rtestfromfilename tofilename (rtest is an example library name on the AS400, you need to know what library the file is in, fromfilename the name of the file you want to copy, tofilename is the name of the file it will be called on your PC C: drive File should now be in the directory on your PC Someone below mentions the get command using a. (dot) instead of (slash) I dont know how old the OS on the AS400 is but very old OS uses a.We did the other with Excel to Msquery, which worked well with no issues.But this one, of course, Excel wont take 1.5 million lines.Then we tried to send it to Access, but an error occur, and we are not able to skip this error (on line 235,716) I was trying to split the query, but I get an error while sending to MSquery.
SQL0227 - FETCH not valid, cursor CRSR0003 is unknown position. I tried to exclude the line, skip the line, but I get this error. If I try to open it in msquery and copypaste data, I can do it with the first 65,000 lines, but after this msquery crash. Copy As400 File Text File How To Pull DataDoes anyone have any idea on how to pull data from this nightmare I tried asking old IT technician who worked for years with AS400 and they dont know how to get through. We were ready to pay for someone to extract the data, but there is no company with AS400 expertise around me (looked 200 km around me) and the only person that may have an idea on how to achieve this is not able to give me a valid reference (the data is sensitive.) Thank you. ![]() CPYF FROMFILE(LARGEFILE) TOFILE(librarySMALL1) CRTFILE(YES) FROMRCD(1) TORCD(100000). Whatever is your limit, just use the copy file (cpyf) to create smaller work files and then transfer them. Once you have them over to what ever system you will use you can just put them back together. Rather simple. If you need some assistance just reply and Ill give you some example commands. Is it possible to print a whole table to a text document format, and then I will format it into a readable sheet The important is not the time spent on the problem, it is only the resolution of the problem. You would not be able to open the.csv in excel, put perhaps you could import it into your new database. One common practice for non-AS400 is pulling a drive and extracting the data from an external connection but Ive never done that with AS400 drivesdata. You do not need to get the data directly to Excel, at least to a csv or some other data delimited file format. ![]() Once you can get that data out, you can pull it into whatever program that can handle that large a database. IBM can pull a drive and pump the data to a new one but that is about it. Is the file the same that would appear if I try to extract with MS query In that case, the file or table is named JHIS. You may also try command: telnet xxxxx (xxxxx AS400 system name or IP address but telnet might be shutoff on your firewall) when at the Sign on Screen, sign on as QSECOFR and this should take you directly to a command line. Its been awhile and I think if you type cpy it will show you the command parameters for all the copy commands. I think you can also press F4 to bring up the entire list of commands. I think using the CPYF and copy it in smaller pieces might work. You may be able to get the file using FTP as someone mentioned. Create a Directory on your PC and run the ftp command from this directory CDxxxxxx FTP Commands: (Type Highlighted Commands) ftp xxxxx (xxxxx AS400 System name or AS400 IP Address, you must be able to ping either one to use) User: qsecofr Password: xxxxxx (Password for QSECOFR, qsecofr is the administrator account on the AS400) bin (bin binary image or try the get command below without using bin) get rtestfromfilename tofilename (rtest is an example library name on the AS400, you need to know what library the file is in, fromfilename the name of the file you want to copy, tofilename is the name of the file it will be called on your PC C: drive File should now be in the directory on your PC Someone below mentions the get command using a. I dont know how old the OS on the AS400 is but very old OS uses a.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |