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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034908900 | OBJECTNAME, TYPE, SEQUENCE | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|