SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—523723-004
9-25
Altering Triggers
4. Enter the ALTER TABLE statement.
5. Revise the application source code as needed to reflect your changes to the
database. Process and compile the updated source file. For more information, see
the SQL/MX Programming Manual for C and COBOL and the SQL/MX
Programming Manual for Java.
Examples of Altering Table File Attributes
These examples demonstrate altering the file attributes of a table:
>> ALTER TABLE CAT.SCH.EMPLOYEE
+> MAXEXTENTS 200;
--- SQL operation complete.
>> ALTER TABLE CAT.SCH.EMPLOYEE
+> ALLOCATE 175;
--- SQL operation complete.
>> ALTER TABLE CAT.SCH.EMPLOYEE
+> NO AUDITCOMPRESS;
--- SQL operation complete.
Altering Table Privileges
To alter table privileges, use the GRANT and REVOKE statements.
For more information, see the SQL/MX Reference Manual.
Steps for Altering a Table’s Privileges
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine the name of the table you want to alter and what privileges you want to
change.
3. Enter the GRANT or REVOKE statement.
For more information and examples of altering table privileges, see the SQL/MX
Reference Manual.
Altering Triggers
To alter triggers, use the ALTER TRIGGER statement.
You can alter triggers by either enabling or disabling them with the ALTER TRIGGER
statement.
For more information, see the SQL/MX Reference Manual.