Entering content frame

Component documentation SQLDBC Manual Locate the document in the library structure

Purpose

SQL Database Connectivity (SQLDBC) is a runtime environment for the development of database applications and database interfaces for MaxDB. Through SQLDBC, applications can access MaxDB database instances, execute SQL statements and edit data. It consists of the runtime library libSQLDBC, the software development kit SQLDBC SDK and the tool sqldbc_cons.

You can use SQLDBC on all Structure linkoperating systems supported by the database system.

Implementation Considerations

SQLDBC is a component of the MaxDB software. For information on where to obtain MaxDB software and how to install it, see the Structure linkDownload section and the Structure linkInstallation Manual.

Note

If you want to use SQLDBC in open source projects, please observe the license terms. You can find more information at dev.mysql.com/doc/maxdb/FLOSS.html

You can download a detailed programming reference from the MaxDB website; see the Download section.

For more information about the database system, see the documentation Structure linkConcepts of the Database System; for more about SQL syntax, see the Structure linkSQL Reference Manual and the Structure linkSQL Tutorial. For quick access to all documentation and an explanation of the most important terms, use the alphabetical Structure linkGlossary.

Features

SQLDBC provides the following functions, among others:

     Unlimited number of database connections and SQL statements

     Complete Unicode support (UCS2 and UTF-8)

     Flexible result sets (navigation within the result set, changing the result set)

     Piecewise writing of characters and binary data (LOB interface)

     Support of the following SQL and C data types:

     CHAR, VARCHAR, SHORT, INT, LONG, FIXED, FLOAT, DOUBLE

     BLOB, CLOB

     ODBC (NUMERIC, DATE, TIME)

     STREAMS (BLOB, CLOB, ABAP and liveCache)

     Internal temporary storage of SQL statements in the parse info cache

     Optimization of SELECT and FETCH statements

     Optimization of the packages (use of multiple segments, use of unoccupied space in packages for administration tasks, use of a mixed Unicode/ASCII mode, alternating buffer technology for INSERT statements)

     Extensive trace options

     Multi-threading (parallel execution of SQL statements, ending long-running SQL statements, synchronization in a multi-threading environment, independence of parallel database connections)

SQLDBC was developed in a similar way to the ODBC and JDBC interfaces and also shares the same object-oriented architecture.

See:

Structure of SQLDBC

SQLDBC Classes

SQLDBC Traces

sqldbc_cons

 

Leaving content frame