Archive for April, 2007
SAS/Access and Oracle Timestamp format
Until SAS 9.2, SAS/Access will not support the Oracle timestamp format. There still is no word on when 9.2 might appear so it’s over to the SQL pass-through facility…
Uses for symbolic links
UNIX (and Linux) does a wonderful trick with its file and folder shortcuts; it effectively treats them as file and folder transporters that transfer associate a file or folder that exists in one folder hierarchy with another and it is treated as if it exists in that hierarchy too. For example, the images folder under [...]
Checking existence of files and directories on UNIX using shell scripting
Having had a UNIX shell script attempt to copy a non-existent file, I decided to take another look for ways to test the existence of a file. For directory existence checking, I was testing for the return code from the cd command and I suppose that the ls command might help for files. However, I [...]
Google Reader
Going through the stats for my other blog, I noticed some activity from Google Reader and decided to investigate. what I discovered was a very capable feed reader, much better than Technorati’s equivalent. The interface feels a little like an email client with a different entry of the sidebar for each feed. It also gives [...]
Inexpensive hosting
On a recent blog hopping excursion, I spotted a mention for no frills hosting by Streamline.net by a satisfied customer. I’ll stick with Fasthosts for now because I have what I need from them in terms of features and uptime, even though I am paying a bit more. the Streamline package looks interesting though…
Learning about Oracle
My work in the last week has put me on something of a learning about Oracle. This is down my needing to add file metadata to database as part of an application that I am developing. The application is written in SAS but I am using SAS/Access for Oracle to update the database using SQL [...]