> I'm not sure what you mean by "hasn't defined SQL_DBMS_VER".
>
> The DBI spec says "doesn't provide a name to number mapping for the
> information type codes or the results. Applications are expected
> to use the integer values directly".
> Handle what?
Handling hardcoding like
sub get_info {
my $infotype = shift;
if($infotype == 18) {
return $somecolumn;
}
}
or something like
sub get_info {
my %infotypes = {
"SQL_DBMS_VER" => 18,
..
};
my $infotype = shift;
if($infotype == $infotypes{"SQL_DMS_VER"}) {
return $somecolumn;
}
}
I am trying to figure out a good way to do this in the sybase DBD. I guess
the second approach is better.
--pradeep