When a DDL (Data Definition Language) statement must be executed, you can use the member function IldDbms::execute. This function behaves like the member function IldRequest::execute. If required, Rogue Wave DB Link silently allocates an IldRequest object and uses it.

This function can also be used for DML (Data Manipulation Language) statements, except for the select statement. If you need to know the number of processed rows —modified, inserted, or deleted— you must pass a valid pointer to an IlInt variable as the second argument to the function IldDbms::execute (the first argument being the text of the SQL statement). This is the only way since, unlike the class IldRequest, the class IldDbms has no getStatus member function. You cannot use this function to perform select statements because you cannot get the private IldRequest object that was used by the IldDbms object.

Through the class IldSQLType, Rogue Wave DB Link offers a full interface to find out the database type names to be used when creating a table. The application can retrieve the proper RDBMS-dependent name for a column using the IldDbms::getTypeInfo function, which takes its first argument from the list at the end of the ildconst.h file. This function can return several objects in an array, or no objects if that specific type does not exist in the currently connected RDBMS.