Creating a Database Using Dynamic SQL

Go Up to DSQL Limitations (Using Dynamic SQL)

To create a new database in a DSQL application:

1. Disconnect from any currently attached databases. Disconnecting from a database automatically sets its database handle to NULL.
2. Build the CREATE DATABASE statement to process.
3. Execute the statement with EXECUTE IMMEDIATE.

For example, the following statements disconnect from any currently connected databases, and create a new database. Any existing database handles are set to NULL, so that they can be used to connect to the new database in future DSQL statements.

char *str = "CREATE DATABASE \"new_emp.ib\"";
. . .
EXEC SQL
DISCONNECT ALL;
EXEC SQL
EXECUTE IMMEDIATE :str;

Advance To:

• Processing Blob Data (Using Dynamic SQL)