Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

Chapter 10 231
Technical Articles
Introducing ODBCLink/SE
ALLBASE/SQL Storage space for BLOBs should be created using a
LONG VARBINARY column.
Stored Procedures
ODBCLink/SE implements all types of ALLBASE/SQL stored
procedures, including those which return multiple-format results sets.
You can list the stored procedures available to your ODBC session by
calling SQLProcedures. Parameter information for stored procedures
is obtained by calling SQLProcedureColumns.
Features Specific to ODBCLink/SE
The following is a list of features that are unique or specific to
ODBCLink/SE and some details about them:
• Primary key name returned by SQLStatistics
Most ODBC applications including MS Access, Visual Basic, and
PowerBuilder require a unique primary key for a table to be
updatable.
• Reading or writing to ALLBASE/SQL LongVarBinary items.
Any file residing on the Hewlett-Packard server can be inserted into
an ALLBASE/SQL LongVarBinary field with the INSERT INTO
SQL command.
• Maximum number of statements
ODBCLink/SE supports up to 50 concurrent statements, or cursors,
per connection.
FLOAT(24), REAL, or Image E2 SQL_REAL
FLOAT(53), DOUBLE PRECISION, or
Image E4
SQL_DOUBLE
Image R2 (non-IEEE float) SQL_REAL
Image R4 (non-IEEE float) SQL_DOUBLE
DATE SQL_DATE
TIME SQL_TIME
DATETIME SQL_TIMESTAMP
INTERVAL SQL_CHAR
ALLBASE/SQL or IMAGE/SQL
Data Type
ODBC Data Type