This release includes several new SQL statements that ease migration from non-Informix databases to Dynamic Server, Version 9.3.
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.
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 ]