1. BACKUP
2. Structure table
C:\>bop_sinfo -dq conx
Factory conx < conx >
Attributes:
id <own_resource_uuid> SREL -> nr.id UNIQUE
producer_id LOCAL STRING(20)
persistent_id LOCAL STRING(60)
proj_code STRING(50)
con_num STRING(50)
con_ref STRING(50)
con_status SREL -> bms.status_no
con_type STRING(50)
con_start_date DATE
con_end_date DATE
con_renewal_date DATE
con_comments STRING(200)
delete_flag del SREL -> actbool.enum REQUIRED
version_number INTEGER
creation_date DATE
creation_user STRING(64)
last_mod_dt last_update_date DATE
last_mod_by last_update_user STRING(64)
mdr_name LOCAL STRING(0)
mdr_class LOCAL STRING(0)
audit_userid LOCAL SREL -> cnt.id TENANCY_UNRESTRICTED
warning_msg LOCAL STRING(0)
3. extract
C:\>pdm_extract conx
TABLE conx
con_comments con_end_date con_num con_ref con_renewal_date con_start_date con_status con_type creation_date creation_user del id last_update_date
last_update_user proj_code version_number
4. SQL Command
select * from ci_contract
select nr.resource_name, conx.*
from ci_contract as conx
inner join ca_owned_resource as nr on nr.own_resource_uuid = conx.own_resource_uuid
Contract Family - CA Service Management - 14.1 - CA Technologies Documentation
Família Contrato - CA Service Management - 14.1 - Portuguese - Brazil - CA Technologies Documentation
Familia Contrato - CA Service Management - 14.1 - Spanish - Spain - CA Technologies Documentation
Famille Contrat - CA Service Management - 14.1 - French - France - CA Technologies Documentation
Contract(契約)ファミリ - CA Service Management - 14.1 - Japanese - Japan - CA Technologies Documentation
pdm_load
Summary CA Service Management Community
Service Desk Manager 15 days Implementation