To modify a schema extract file

From the HCOSS Extract Schema tool, click the Schema Extract tab.

Select an existing schema extract file from the Schema Extract Name drop-down list.

Using the fields and controls on the Schema Extract tab change the settings as required.

Note: If you change the properties from Local to Shared, or vice versa, you have the following options:

Move the existing extract file to the new location
Copy the existing extract file to the new location
Neither move nor copy the existing extract file

Click Extract.

On the Results tab, verify that the schema extract file has been generated properly.

Note: If you get a -551 SQL error extracting a table, no schema is extracted. To correct this, have your DB2 DBA grant you READ access to the table that generated the error; then rerun the Extract Schema tool.

On the Schema Extract tab, click Save to save the new settings.