<HTML>
<HEAD>
<meta name="GENERATOR" content="Microsoft Internet Assistant for PowerPoint 97">
<TITLE>SQL Portability - Driver Capabilities</TITLE>
</HEAD>
<BODY >
<H1>SQL Portability - Driver Capabilities</H1>
<P><UL>
<LI><H2>How can you tell what functionality the current driver and database support?
</H2>
<UL>
$value = $dbh->get_info(
);
<BR></UL></UL><UL>
<LI><H2>Heres a small sample of the information potentially available:
</H2>
<UL>
<LI>AGGREGATE_FUNCTIONS BATCH_SUPPORT CATALOG_NAME_SEPARATOR CONCAT_NULL_BEHAVIOR CONVERT_DATE CONVERT_FUNCTIONS CURSOR_COMMIT_BEHAVIOR CURSOR_SENSITIVITY DATETIME_LITERALS DBMS_NAME DBMS_VER DEFAULT_TXN_ISOLATION EXPRESSIONS_IN_ORDERBY GETDATA_EXTENSIONS GROUP_BY IDENTIFIER_CASE IDENTIFIER_QUOTE_CHAR INTEGRITY KEYWORDS LIKE_ESCAPE_CLAUSE LOCK_TYPES MAX_COLUMNS_IN_INDEX MAX_COLUMNS_IN_SELECT MAX_IDENTIFIER_LEN MAX_STATEMENT_LEN MAX_TABLES_IN_SELECT MULT_RESULT_SETS OJ_CAPABILITIES PROCEDURES SQL_CONFORMANCE TXN_CAPABLE TXN_ISOLATION_OPTION UNION
</UL></UL><UL>
<LI><H2>A specific item of information is requested using its standard numeric value
</H2>
<UL>
$db_version = $dbh->get_info( 18 ); # 18 == SQL_DBMS_VER
<BR></UL></UL><UL>
<LI><H2>The standard names can be mapped to numeric values using:
</H2>
<UL>
use DBI::Const::GetInfo;
<BR><BR>$dbh->get_info($GetInfoType{SQL_DBMS_VER})</UL></UL></P>
<P></P>
<P>
<TABLE>
<TD HEIGHT=100 WIDTH=100> <A HREF="tsld084.htm">Previous slide</A> </TD>
<TD HEIGHT=100 WIDTH=100> <A HREF="tsld086.htm">Next slide</A> </TD>
<TD HEIGHT=100 WIDTH=150> <A HREF="tsld001.htm">Back to first slide</A> </TD>
<TD HEIGHT=100 WIDTH=150> <A HREF="sld085.htm">View graphic version</A> </TD>
</TABLE>
<BR>
</P>
</Body>
</HTML>