Reference Commands › pdm_load--Add, Update, and Delete Database Records

pdm_load--Add, Update, and Delete Database Records

Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.

pdm_load updates a CA SDM database using an input file you specify, up to a maximum of 112 attributes.

Whenever you upload tickets (such as requests or issues), your ticket number should include a unique prefix or suffix in its string. CA SDM views this number as a string of characters not as a sequential number, and thus cannot guarantee that it will assign a unique number to the uploaded tickets. As long as you assign a unique prefix or suffix using awk or another text processor, you can upload tickets without CA SDM writing over previously assigned numbers.

Syntax

This command has the following format:

pdm_load [-c] [-h] [-m] [-r] [-u] [-v] -f filename

The input file entries follow this format:

TABLE table_name
fieldname1 fieldname2 . . . . fieldnameN
{ "value11", "value12", . . . "value1N" }
{ "value21", "value22", . . . "value2N" }
.
.
.
{ "valueN1", "valueN2", . . . "valueNN" }

table_name is the name of the table to be loaded, as listed in the CA SDM database schema file, which is located in $NX_ROOT/site/schema.sch (UNIX) or installation-directory\site\schema.sch (Windows). $NX_ROOT or installation-directory is the directory where you installed CA SDM.

-f filename

Specifies an input ASCII file.

-c

Checks the input file against the database and reports on the updates that would be made, but does not make the updates.

-m

Specifies mass update. Specify when you are using pdm_load to add or delete a large number of records. This option suppresses all client notifications of updates and sends a cache refresh message for a table when pdm_load finishes processing the table.

-r

Removes database records that match input records.

Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records.

-u

Updates existing records, but does not insert new records into the database.

More information:

pdm_backup--Write Database to ASCII File

pdm_replace--Replace a Database Table

pdm_restore--Restore a Database

pdm_userload--Add, Update, and Delete Database Records