CA Ideal Commands › DELETE AUTHORIZATION Command (CA Datacom SQL Access)

DELETE AUTHORIZATION Command (CA Datacom SQL Access)

The DELETE AUTHORIZATION command deletes a previously defined plan for a program that uses CA Datacom SQL access. The plan is identified by a name created from the authorization ID, program name, and version number specified in the DEFINE AUTHORIZATION command. You can enter this command as DELETE AUTHORIZATION, DELETE ATZ, DELETE AUT, or as DELETE AUTH. You must enter the command from the system that contains the program object.

The statement‑IDs for each statement must match in every plan associated with the program or a runtime error occurs. This type of error can happen if the CA Datacom utility DDTRSLM exports a plan without its associated program or if the CA Ideal Object Transport Utility transports a program object without its associated plan.

This command has the following format:

DELETE AUTHORIZATION authid FOR PROGRAM name VERSION ver