Help using Base SAS procedures

ERROR READING .DB FILE

Reply
Contributor
Posts: 38

ERROR READING .DB FILE

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:

http://ftp.sas.com/techsup/download/hotfix/HF2/C70.html#19710

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

Super User
Posts: 10,466

Re: ERROR READING .DB FILE

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

Super User
Posts: 9,662

Re: ERROR READING .DB FILE

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

Contributor
Posts: 38

Re: ERROR READING .DB FILE

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

Ask a Question
Discussion stats
  • 3 replies
  • 265 views
  • 0 likes
  • 3 in conversation