"Pepin, Joseph D (Joe), SOLCM" wrote:
>
>
> It would be nice if there was something like: my @quote_these =
>$dbh->reserved_words;
> I ran into this with CSV a while back, where TEXT was a reserved word in CSV but not
>in Oracle.
I'm not sure of the wisdom of such a method, but here's how to tell the
list of new reserved words when going from one DBMS to another, (once
all DBDs implement get_info):
my %old_res = map { $_ => 1 }
split ',', $old_dbh->get_info(89);
my @new_res = grep { !$old_res{$_} }
split ',', $new_dbh->get_info(89);
And, BTW, "TEXT" is also a reserved word for ODBC-Access and MySQL among
others.
--
Jeff
