<<
01. Define a temporary table on the fly with one exception to
use a different column name to hold NOTE data type.
>>
I did do something similar to this, but since the user who needed to do this
works from the R> prompt I needed a technique that didn't require any code.
My solution was to create a view against the table UNIONed to a dummy view
using the Downall View Typecasting technique. That way, I simply told the user
to BROWSE against the view (AlertsInfo) instead of the table (Alerts) and that
everything would be exactly the same as before.
--
Larry