Recent content by Msolar

Thanks to both for your input. I'll do a couple of benchmarks to decide on the approach.

Hi All, Everytime I ask this question I get a different opinion. I have a table of about 4 million rows. The date column is part of a PK. I need to delete approx. 300K rows based on an input date parameter every month. What is the most efficient method to delete from my table where date <= parm...

Thanks. I'm just using a telnet to the server on the default term. The display isn't in a dialog; simply from ls command.

I got it to be a printable character (like I want) by using echo "\0244" Let me know if you think that's correct. Now the question is: How can I actually create the filename knowing this octal code? Thanks

Thanks - can't tell if it's correct because the character that our echo displays is a plus sign with a minus underneath. That happens to be the character I got when I tried to ftp the "tilde n" character from Windows to AIX. Looks like you're on the right track, tho.

I need to type the lower-case character n with the diacritical tilde over top of it. In Windows it's easy using Alt+164 (on the number keypad). This character will be used for part of a filename as well as in a text document. Any suggestions? Thanks!

Using SQL*Loader, can a packed decimal input field be mapped to a Date column? ex.: jdat pic 9(7) comp-3 and is formatted as 'yyyydd'. Need to make it a DATE in the table with mask as 'YYYYMMDD' Thanks

Under Win2K Pro, IE works just fine. However, AOL does not accept URLS and cannot surf web sites. It is unresponsive to any web GO address. AOL email is okay, as are all other strictly AOL sites. I've reinstalled AOL and upgraded to IE 6 but nothing has changed. Any ideas? Thanks!