SAP DB:ODBC, Manual

Page: 7 / 31

SAP AG November 2002
SQL_C_UBIGINT SQLUBIGINT unsigned _int64, unsigned long (64 bit)
SQL_C_BINARY SQLCHAR* unsigned char*
SQL_C_DATE SQL_DATE_STRUCT struct tagDATE_STRUCT {
SQLSMALLINT year;
SQLSMALLINT month;
SQLSMALLINT day;}
SQL_C_TIME SQL_TIME_STRUCT struct tagTIME_STRUCT {
SQLSMALLINT hour;
SQLSMALLINT minute;
SQLSMALLINT second;}
SQL_C_TIMESTAMP SQL_TIMESTAMP_STRUCT struct tagTIMESTAMP_STRUCT {
SQLSMALLINT year;
SQLSMALLINT month;
SQLSMALLINT day;
SQLSMALLINT hour;
SQLSMALLINT minute;
SQLSMALLINT second;
SQLUINTEGER fraction;}
SQL_C_BIT SQLCHAR unsigned char
Conversion of SQL and C Data Types
The SAP DB ODBC driver allows the conversion for all supported data types [Page 6 ] .
See also:
Microsoft Homepage (http://www.microsoft.com/data/ODBC) in the ODBC Software
Development Kit (SDK) under ODBC Programmer‘s Reference , Converting Data from SQL to
C Data Types and Converting Data from C to SQL Data Types sections .
Processing SQL Statements
The SAP DB ODBC driver supports the complete ODBC-SQL syntax.
For detailed information about the ODBC function calls, see the Microsoft
Homepage (http://www.microsoft.com/data/ODBC) in the ODBC Software
Development Kit (SDK) under ODBC Programmer‘s Reference, Chapter 8: SQL
Statements, Escape Sequences in ODBC , Scalar Functions section.
Numeric functions ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT,
EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, PI,
ODBC Manual: SAP DB 7