CA SDM::. loading priority - pri

Document created by TMACUL Champion on Mar 24, 2017Last modified by TMACUL Champion on Mar 24, 2017
Version 3Show Document
  • View in full screen mode

The first thing what you need know: VERY 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.

 

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, use pdm_extract for this procedure.

 

1. BACKUP

 

BACKUP COMMAND
pdm_extract Priority > priority.txt

 

 

2. Structure table

 

bop_sinfo -dq pri

 

Factory pri < Priority >
Attributes:
id INTEGER UNIQUE
producer_id LOCAL STRING(20)
persistent_id LOCAL STRING(60)
sym STRING(60) REQUIRED SKEY UNIQUE
enum INTEGER REQUIRED
service_type SREL -> no_contract_sdsc.code
delete_flag del SREL -> actbool.enum REQUIRED
description desc<nx_desc> STRING(255)
last_mod_dt DATE
last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED

 

 

The original content

Structure load: pdm_extract Priority

TABLE Priority
del desc enum id last_mod_by last_mod_dt service_type sym
{ "0" ,"LOW Priority" ,"1" ,"500" ,"171E5C822F5AA4409145FC5220142A50","11/25/2016 14:34:38" ,"sdsc:5406" ,"5" }
{ "0" ,"MEDIUM-LOW Priority" ,"2" ,"501","171E5C822F5AA4409145FC5220142A50" ,"11/25/2016 14:34:22" ,"sdsc:5405" ,"4" }
{ "0" ,"MEDIUM Priority" ,"3" ,"502" ,"171E5C822F5AA4409145FC5220142A50","11/25/2016 14:34:01" ,"sdsc:5407" ,"3" }
{ "0" ,"MEDIUM-HIGH Priority" ,"4" ,"503","171E5C822F5AA4409145FC5220142A50" ,"11/25/2016 14:30:59" ,"sdsc:5404" ,"2" }
{ "0" ,"HIGH Priority" ,"5" ,"504" ,"" ,"" ,"sdsc:5403" ,"1" }
{ "0" ,"Priority unassigned" ,"0" ,"505" ,"" ,"" ,"" ,"None" }

 

 

idenumsymnx_descservice_type
50015LOW Prioritysdsc:5406
50124MEDIUM-LOW Prioritysdsc:5405
50233MEDIUM Prioritysdsc:5407
50342MEDIUM-HIGH Prioritysdsc:5404
50451HIGH Prioritysdsc:5403
5050NonePriority unassignedNULL

 

select * 
from pri

 

 

 

know_more.jpg

CA SDM Loading contacts pdm_load 

DEREF - pdm_deref - Everthing do you need know 

CA SDM Load department using pdm_load - dept - ca_resource_department 

CA SDM Load department using pdm_load - dept - ca_resource_department 

 

 

 

Was useful, please leave your feedback!

Attachments

    Outcomes