Hi,
We have an old AS400 (don't have type, but it's something like 30 years old) that we need to extract data from (disk started to have a hard time to spin, we needed to shake them in order to make it spin again...)
We were able to extract data from some tables, but we have one with 1,5 million entries. We did the other with MSquery to excel, which worked well with no issues. But this one, of course, Excel won't 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 copy/paste data, I can do it with the first 65,000 lines, but after this msquery crash. If I try to send it to excel / access, it just crash.
Does 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 don't 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...)
This machine is older than me, and I have no experience with as400. I saw some interesting features in the programming menu in client access, such as STRQM, but I don't know where to start, and I really don't want to mess things up. Someone have a link to a good tutorial (I tried looking, but couldn't find something useful/I could understand well...)
Thank you..
We have an old AS400 (don't have type, but it's something like 30 years old) that we need to extract data from (disk started to have a hard time to spin, we needed to shake them in order to make it spin again...)
We were able to extract data from some tables, but we have one with 1,5 million entries. We did the other with MSquery to excel, which worked well with no issues. But this one, of course, Excel won't 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 copy/paste data, I can do it with the first 65,000 lines, but after this msquery crash. If I try to send it to excel / access, it just crash.
Does 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 don't 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...)
This machine is older than me, and I have no experience with as400. I saw some interesting features in the programming menu in client access, such as STRQM, but I don't know where to start, and I really don't want to mess things up. Someone have a link to a good tutorial (I tried looking, but couldn't find something useful/I could understand well...)
Thank you..
Comment