topic Re: ERROR READING .DB FILE in SAS Procedures

ERROR READING .DB FILE

MaheshPeesari — Fri, 19 Apr 2013 18:52:49 GMT

Hi All,

I am trying to read a .db file using proc import. i am using sas9.2 and SAS

Access is also installed, i always get an error as:

Disk Read Request Error

ERROR: Import unsuccessful. See SAS Log for details.

When i googled i found that there is a hotfix for this error and i have

installed the hotfix, but still i have the same error.

Here are the details for HOTFIX:

Basically we are scheduling on unix server using TWS(TIWOLI WORKLOAD

SCHEDULER) and i was given a file which is created by tws. the file is .db

extension and the file consists information of job run times, of previous two

months and current month.Based on the file i have to generate report

comparing execution time of jobs of previous and current months.so now my question

is has anyone ever used .db file created by TWS. does TWS really create a

.db file or else while i have moved to my local system did format got

changed.If anyone has ever used such file from TWS,please give your inputs

as how to read the file.

Thanks,

Mahesh P

ballardw — Fri, 19 Apr 2013 22:07:26 GMT

Completely guessing here, but I would try DBMS=DBF at least once to see if the file is mare Dbase than Paradox.

Ksharp — Sat, 20 Apr 2013 07:02:29 GMT

Can you use ' more xxx.db ' to check its content ?

MaheshPeesari — Sun, 21 Apr 2013 18:23:00 GMT

I am able to read that file using sqlite , i can query and see the results , if you want to check me on UNIX , i will do it tomorrow and reply back.

Thanks for the reply.

thanks,

Mahesh P

imvash — Thu, 21 May 2020 16:43:49 GMT

Is there any solution to this topic?