Home | Previous Page | Next Page   Using New Features in Dynamic Server > New Features in Version 9.3 >

SQL Enhancements

This release includes several new SQL statements that ease migration from non-Informix databases to Dynamic Server, Version 9.3.

Optional FROM in the DELETE Statement

The DELETE statement no longer requires the FROM keyword. You can use this syntax:

DELETE customer WHERE customer_num = 105;

For more information, see the IBM Informix Guide to SQL: Syntax.

REVOKE AS User

The REVOKE statement allows the owner of a database object to revoke the privileges of other users. REVOKE ... AS and REVOKE FRAGMENT .. AS allow user2 to revoke the privileges for user1. For example, you can revoke privileges from user names such as informix that are authorization identifiers but not users that the operating system recognizes. You can use this syntax:

REVOKE privilege FROM user1 AS user2;

For more information on the REVOKE statement, see the IBM Informix Guide to SQL: Syntax.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]