|
Technical Fact Sheet
Dharma ODBCnet™
Flexible Configuration Support
Dharma ODBCnet supports client/server, three-tier and single-tier configurations for Internet/Intranet environments. The ODBCnet driver runs on Windows and UNIX. This flexibility insures ODBCnet supports your present and future needs.
By providing a client/server environment, Windows tools can access previously-unavailable data in proprietary databases. Three-tier configurations give you the flexibility to access proprietary data through a Web browser, and push business-logic processing to the application server
Data Type Support
Dharma ODBCnet supports all ODBC data types, including LONG types of arbitrary length and structure.
ODBC 3.5 Support
The ODBCnet Driver supports all Core, Level 1, and most Level 2 API functions, plus extensive scalar functions.
Scalar functions
| String Functions
| |
| ASCII |
CHAR |
| CHARACTER_LENGTH |
CHAR_LENGTH |
| CONCAT |
CONVERT |
| DIFFERENCE
| INSERT |
| LCASE |
LEFT |
| LENGTH |
LOCATE |
| LOWER |
LTRIM |
| REPEAT |
REPLACE |
| RIGHT |
RTRIM |
| SOUNDEX |
SPACE |
| SUBSTRING |
TRANSLATE |
| TRIM_LEADING |
TRIM_TRAILING |
| UCASE |
| Time and Date Functions
| |
| CURDATE |
CURTIME |
| DAYNAME |
DAYOFMONTH |
| DAYOFWEEK |
DAYOFYEAR |
| HOUR |
MINUTE
|
| MONTH |
MONTHNAME |
| NOW |
QUARTER
|
| SECOND |
TIMESTAMPADD |
| TIMESTAMPDIFF |
WEEK |
| YEAR |
|
| Numeric Functions
| |
| ABS | ACOS
|
| ASIN | ATAN
|
| ATAN2 |
CEILING |
| COS | DEGREES
|
| EXP | FLOOR
|
| LOG |
LOG10 |
| MOD |
PI |
| POWER |
RADIANS |
| RAND |
SIGN |
| SIN |
SQRT |
| TAN
|
|
