The following CA Culprit parameters are used to drop SQL tables.
INPUT
An INPUT statement is always required for a CA Culprit job, even though it is irrelevant for the drop table function.
REC
A REC parameter is also required for every CA Culprit job. You define a single REC parameter when just drop table is being performed.
nnOUTPUT
The OUTPUT parameter is where you specify the SQLTABLE= clause and TYPE=DROP. You also specify the SQL dictionary and schema name on the OUTPUT parameter.
A complete discussion of the OUTPUT syntax is found in OUTPUT Parameter.
The clause CASCADE=YES is optional for TYPE=DROP. CASCADE instructs CA IDMS/DB to delete the definition of:
If the table you are trying to delete is involved in any linked referential constraints, and the related table is not empty, CA Culprit is not able to drop this table. You should then use the Command Facility to delete the data from both tables, drop the linked constraints, and then drop the table.
Note: For more information about the Command Facility, see the CA IDMS Common Facilities Guide.
Type 5
A type 5 parameter is required in every CA Culprit report, even though you do not want to print any output.
Type 7
To prevent data extraction, you code a single type 7 parameter to DROP the input record.
|
Copyright © 2014 CA.
All rights reserved.
|
|