The tables /QTQVC/CONTROL and /QTQVC/JOB_SQL contains information about
The table /QTQVC/TRACE is used to store trace information for the
The table /QTQVC/STATUS contains information about jobs started for all connectors. It is also used for
Delete the database table content in dialog mode
Use transaction /N/QTQVC/DELETE. This mode is suitable to use when the number of records to delete are not too many. The reason is that there is a timeout after a while in
With this transaction it is possible to delete records from the /QTQVC/ tables or a single record from the table /QTQVC/STATUS. For the first four options all records from the specified table and year are deleted at one time. The option can be used to see how many records will be deleted (no deletion takes place). To delete the records, select the option .
Click the button when the appropriate options have been selected.
Delete database table content in background mode
This mode is suitable to use for tables with a large amount of records. Since the job is performed in the background there is no timeout.
Schedule the deletion job from an
Use transaction /N/QTQVC/DELETE_BGD.
Select which table(s) to delete records from. It is possible to limit the number of records to be deleted in the job. It is also possible to change the number of records to be deleted between each database Commit.
Start the background job by pressing the button .
Check the status of the background job in the
The result of the finished deletion job is also stored in a record in the table /QTQVC/STATUS. Key to the record is = ‘’, = current date and = current time.
Records in the table /QTQVC/STATUS with = ‘K’ will never be deleted, because they are used by the
Schedule the deletion job by using the
Enter ‘X’ for the table(s) where records should be deleted. It is possible to change the values for ‘’ and ‘’. should be ‘D’.
Reload the BAPI script. A field () is received as
To fetch status table records containing the result of previous deletion jobs, use the same function module with the following parameters:
- CONNECTOR: DELETION
- JOBSTATUS: F
- MAX_RECORDS: 99999999
- MODE: G
Schedule the deletion job directly in
It is possible to schedule a deletion job directly in
Update database table content
Use Transaction /N/QTQVC/UPDATE.
With this transaction it is possible to update single records from the tables /QTQVC/CONTROL and /QTQVC/STATUS. To update a record, select the wanted table, enter the key for the record, enter a new value in JOBSTATUS and click the button.