The alternative Open SQL interface introduced in DBTools.h++ 4.0 can be used with DB2 CLI. This section provides some specific details.
The placeholder syntax for DB2 CLI is simply:
?
Here is an example:
INSERT INTO PICNICTABLE VALUES(?)
Placeholders are not a portable feature. Different access libraries use different placeholder syntax.
All the C++ language datatypes are supported for input binding. The following Rogue Wave types are also supported: RWCString, RWDate, RWDBDateTime, RWDecimalPortable, RWDBDuration, and RWDBBlob.
You can use the standard DB2 CLI stored procedure syntax when executing stored procedures with RWDBOSql.
©Copyright 2000, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.