Database Table: CLEANCONF

The Database Cleanup utility configuration table.

Column Name Column Type Column Description
DAYSARG CHARACTER (10)
NOT NULL
Indicates if the days argument is used in the condition, which specifies the minimum days in existence for a record to be deleted:
yes = use the days argument,
no = do not use the days argument.
NAMEARG CHARACTER (10)
NOT NULL
Indicates if the name argument is used in the condition, which specifies the ID of the object to be deleted:
yes = use the name argument,
no = do not use the name argument.
OBJECTNAME CHARACTER (40)
NOT NULL
The name of the WebSphere Commerce object to be cleaned.
SEQUENCE INTEGER
NOT NULL
Sequence number if more than one SQL statement is required to clean the WebSphere Commerce object.
STATEMENT VARCHAR (4000)
NOT NULL
The SQL statement used by the DBClean utility to clean up the entries in the database table.
STATEMENTTYPE VARCHAR (120)
NULL
The type of value that a select statement returns. For example, absolute file, relative path, or URL.
TYPE CHARACTER (40)
NOT NULL
The type of the object you want to delete for this condition in this table. Refer to the Database Cleanup Utility command in the online help for more information.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034908900 OBJECTNAME, TYPE, SEQUENCE Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable