BookmarkSubscribeRSS Feed
MaheshPeesari
Calcite | Level 5

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

4 REPLIES 4
ballardw
Super User

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

Ksharp
Super User

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

MaheshPeesari
Calcite | Level 5

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
SAS Employee
Is there any solution to this topic?

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1607 views
  • 0 likes
  • 4 in conversation