SQL Maintenance Table

Maintenance commands to Dynamic System Tables can be issued using a Dynamic System Table named SQL_CONSOLE (SQX). SQL maintenance is only done to the SQX table.

The SQX table lets you do an insert with a character -string that is formatted by all the console commands. The command is processed as if issued through the console. The results, if any, are returned to the caller. The SQX table can therefore be used to issue the same commands that can be requested using the DBUTLTY function COMM OPTION=CONSOLE,OPTION2=. For details about using OPTION2=, see the CA Datacom/DB DBUTLTY Reference Guide).

The ability for SQL to insert, update, or delete Dynamic System Table rows is folded into the common component console APIs that allow the MUF changes to occur. The MUF changes occur the same as they do through all the console-like paths. For example, in a previous release, a user of SQL could change the BREAK value by reading and updating the BREAK field in the MUF_OPTIONS table.After Version 12.0, SQL users can instead issue the change as an insert into the SQL_CONSOLE (SQX) table.

Note: For information about CA Datacom/DB maintenance using console commands, see the CA Datacom/DB Database and System Administration Guide.

If a command would normally produce console output, that output is written to the console and is also returned to the application in the SQL feedback area.

The SQX table can be externally secured, but external security is not content based. With external security, therefore, any user who has ADD rights to a table can issue any insert into the table, causing the console-like request to be executed. If you are concerned about the possibility that this ability could be misused, the table can be deleted from CA Datacom Datadictionary and the database can be cataloged without the deleted table being present.