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 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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