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
Completely guessing here, but I would try DBMS=DBF at least once to see if the file is mare Dbase than Paradox.
Can you use ' more xxx.db ' to check its content ?
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
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!
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.