Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\usingproduct.05.09.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Retrieving Data Type Information</title> <link rel="StyleSheet" href="css/usingproduct.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="usingproduct.05.01.html#107277">2 Using The Product</a> : Retrieving Data Type Information</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="107277">Retrieving Data Type Information</a></div> <div class="Body"><a name="107278">At times, you might need to get information about the data types that are supported by the </a>data source, for example, precision and scale. You can use the ODBC function SQLGetTypeInfo to do this. </div> <div class="Body"><a name="107279">On Windows, you can use ODBC Test to call SQLGetTypeInfo against the ODBC data </a>source to return the data type information. Refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.1.html#108583', '');">Chapter 1 â??Diagnostic Toolsâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Troubleshooting Guide</span> for details about ODBC Test.</div> <div class="Body"><a name="107289">On UNIX, Linux, or Windows, an application can call SQLGetTypeInfo. Here is an example </a>of a C function that calls SQLGetTypeInfo and retrieves the information in the form of a SQL result set.</div> <div class="syntax_first"><a name="107290">void ODBC_GetTypeInfo(SQLHANDLE hstmt, SQLSMALLINT dataType)</a></div> <div class="syntax"><a name="107291">{</a></div> <div class="syntax"><a name="107292"> </a></div> <div class="syntax"><a name="107293"> </a> RETCODE rc;</div> <div class="syntax"><a name="107294"> </a></div> <div class="syntax"><a name="107295">// There are 19 columns returned by SQLGetTypeInfo. </a></div> <div class="syntax"><a name="107296">// This example displays the first 3.</a></div> <div class="syntax"><a name="107297">// Check the ODBC 3.x specification for more information.</a></div> <div class="syntax"><a name="107298"> </a></div> <div class="syntax"><a name="107299">// Variables to hold the data from each column</a></div> <div class="syntax"><a name="107300"> </a> char typeName[30];</div> <div class="syntax"><a name="107301"> </a> short sqlDataType;</div> <div class="syntax"><a name="107302"> </a> unsigned long columnSize;</div> <div class="syntax"><a name="107303"> </a></div> <div class="syntax"><a name="107304"> </a> SQLINTEGER strlenTypeName,</div> <div class="syntax"><a name="107305"> </a> strlenSqlDataType,</div> <div class="syntax"><a name="107306"> </a> strlenColumnSize;</div> <div class="syntax"><a name="107307"> </a></div> <div class="syntax"><a name="107308"> </a> rc = SQLGetTypeInfo(hstmt, dataType);</div> <div class="syntax"><a name="107309"> </a> if (rc == SQL_SUCCESS) {</div> <div class="syntax"><a name="107310"> </a></div> <div class="syntax"><a name="107311">// Bind the columns returned by the SQLGetTypeInfo result set.</a></div> <div class="syntax"><a name="107312"> </a> rc = SQLBindCol(hstmt, 1, SQL_C_CHAR, &typeName,<br /> (SDWORD)sizeof(typeName), &strlenTypeName);</div> <div class="syntax"><a name="107313"> </a> rc = SQLBindCol(hstmt, 2, SQL_C_SHORT, &sqlDataType,<br /> (SDWORD)sizeof(sqlDataType), &strlenSqlDataType);</div> <div class="syntax"><a name="107314"> </a> rc = SQLBindCol(hstmt, 3, SQL_C_LONG, &columnSize,<br /> (SDWORD)sizeof(columnSize), &strlenColumnSize);</div> <div class="syntax"><a name="107315"> </a></div> <div class="syntax"><a name="107316">// Print column headings</a></div> <div class="syntax"><a name="107317"> </a> printf ("TypeName DataType ColumnSize\n");</div> <div class="syntax"><a name="107318"> </a> printf ("-------------------- ---------- ----------\n");</div> <div class="syntax"><a name="107319"> </a></div> <div class="syntax"><a name="107320"> </a> do {</div> <div class="syntax"><a name="107321">// Fetch the results from executing SQLGetTypeInfo</a></div> <div class="syntax"><a name="107322"> </a> rc = SQLFetch(hstmt);</div> <div class="syntax"><a name="107323"> </a> if (rc == SQL_ERROR) {</div> <div class="syntax"><a name="107324">// Procedure to retrieve errors from the SQLGetTypeInfo function</a></div> <div class="syntax"><a name="107325"> </a> ODBC_GetDiagRec(SQL_HANDLE_STMT, hstmt);</div> <div class="syntax"><a name="107326"> </a> break;</div> <div class="syntax"><a name="107327"> </a> }</div> <div class="syntax"><a name="107328"> </a></div> <div class="syntax"><a name="107329">// Print the results</a></div> <div class="syntax"><a name="107330"> </a> if ((rc == SQL_SUCCESS) || (rc == SQL_SUCCESS_WITH_INFO)) {</div> <div class="syntax"><a name="107331">printf ("%-30s %10i %10u\n", typeName, sqlDataType, columnSize);</a></div> <div class="syntax"><a name="107332"> </a> }</div> <div class="syntax"><a name="107333"> </a></div> <div class="syntax"><a name="107334"> </a> } while (rc != SQL_NO_DATA);</div> <div class="syntax"><a name="107335"> </a> }</div> <div class="syntax"><a name="107336">}</a></div> <div class="Body"><a name="107337">For information about how a databaseâ??s data types map to the standard ODBC data types, </a>see the appropriate driver chapter in this book.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de