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

232 Chapter 10
Technical Articles
Introducing ODBCLink/SE
To use multiple statements when you are not writing your own SQL
application, tell ODBCLink/SE to have SQLGetInfo report more
than one statement per connection.
ALLBASE/SQL Restrictions
These are the ALLBASE/SQL and IMAGE/SQL restrictions on the
ODBC grammar. These are summarized in the following table:
Table 10-7 ALLBASE/SQL Restrictions
• ALLBASE/SQL provides a DATETIME data type similar to
TIMESTAMP.
• ALLBASE/SQL does not implement optimistic locking.
Optimistic locking means that the DBMS does not lock data until
just before an update is made, thus improving concurrency because
locks are not held for long.
ANSI Character Set
The HP 3000 and HP 9000 both use the default ROMAN8 character set.
Most applications running under Microsoft Windows use the 8-bit ANSI
(ISO 8859/1) character set to provide support for Western European
languages (including American). The first 127 characters are the same
for both ROMAN8 and ANSI character sets, so only the extended and
special characters are different.
If your client application uses these extended or special characters,
then the data from the server must be converted from ROMAN8 to
ANSI, and the data returning to the server must be converted from
ANSI to ROMAN8. A translation DLL has been provided to accomplish
this task.
Statement Programming Considerations
CREATE TABLE UNIQUE PRIMARY KEY must follow NOT
NULL
DROP TABLE ALLBASE/SQL does not provide CASCADE
or RESTRICT
REVOKE ALLBASE/SQL does not provide RESTRICT