Deleting Records through CIM

QAD 2017 Enterprise Edition > User Guides > System Administration > CIM Interface > Deleting Records through CIM

You can use CIM to delete records created with any of the programs listed in Programs with batchdelete Functionality. In each of these programs, an updateable, single-character field, batchdelete, exists at the end of the header- and detail-record key frames. This field can be updated only when the program is accessed through a batch process, that is, when batchrun = true.

Note: In the character UI, when you press Ctrl+F in a field of a program with batchdelete enabled, a pop-up window appears, indicating that you can use batch delete.

Programs with batchdelete Functionality


Menu Label	Program Name
Customer Item Maintenance	ppcpmt.p
Generalized Codes Maintenance	mgcodemt.p
Site Maintenance	icsimt.p
Price List Maintenance	pppimt.p
Price List Maintenance	pppcmt.p
Item Master Maintenance	ppptmt.p
Installed Base Item Maintenance	fsisbmt.p

Because the batchdelete value exists at the end of key frames, it does not affect existing CIM input files and can be omitted from these files when not used. Since it is only one character, unlabeled, and hidden, the field also does not change the visible interface.

Creating Input Files to Delete Records

Use these guidelines when creating input files that include deletes:

1 To determine if batchdelete is enabled in a particular program, check the list in Programs with batchdelete Functionality.

2 To invoke the batch delete functionality, place an x at the end of the header- or detail-record key frame line in the input file.

3 Follow the key frame with a blank line consisting of a single hyphen so that the program executes the code that would be executed if an F5 or Ctrl+D has been pressed in the first frame after the key frame.

4 Enter a subsequent line containing the string yes as an answer to the Please Confirm Delete prompt displayed for online deletes.

Example of CIM Delete

This sample CIM input file deletes a Site Maintenance record:

@@BATCHLOAD icsimt.p

mysite

yes

@@END

Clearing a Field Value

To blank out an input string using CIM load, you can place the empty string in the input file as two quotation marks (“”) at the correct position in the line. If the field is not a string, specify another value appropriate for the data type such as 0 for a number or a high date (in the year 9999, for example) for a date type field.