I am trying to use a script I have already published to Perlmonks here. The script was designed to be database generic, and in principle it is. I have just successfully hacked the first few lines to allow my current database to be analysed.

Considering the original post was written with an Oracle database in mind, and I am now using it for Sybase, I am pleased that my original script works. However, I have an issue with the decoding of data types as the DBD layer is returning different values for $sth->{TYPE}. I am getting different 'magic' numbers, but I do not have the complete infomation to decode them. I would like a comprehensive list for the standard values that will occur.

The two references I have seen quoted for this information in the documentation both don't work:

• ftp://jerry.ece.umassd.edu/isowg3/dbl/SQL_Registry
• ftp://sqlstandards.org/SC32/SQL_Registry/

Can anyone please post the current list of values as a reply, or a url which works (preferrably http rather than ftp).

Thanks in anticipation.

rinceWind