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.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

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
  • 1303 views
  • 0 likes
  • 4 in conversation