ALTER statement usage

The ALTER statement is used to modify a resource in IMS.

Each one of the alter commands has their own separate list of keywords available. You can issue the following alter commands:

ALTER DATABASE
ALTER TABLE
ALTER TABLESPACE

Example

Issuing the ALTER DATABASE statement, looks similar to the following.

ALTER DATABASE MYDB CCSID 'Cp1047' VERSION '1.8' DATXEXITYES

Note: This alter statement will only modify the given keywords, any other keywords that were originally defined will not change unless specified specifically in the ALTER statement.