Progress
Embedded SQL-92
Guide and Reference
DDL Statements in Long-running Transactions
In an ESQL program, DDL statements have the same transaction semantics as other SQL statements. You must explicitly COMMIT or ROLLBACK DDL operations in an ESQL application.
You can execute DDL statements as part of a long-running transaction. To avoid locking database resources such as tables and views for a long period, Progress Software recommends that you commit the DDL operations. This also improves the concurrency of database operations.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |