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