Data Director 구현 가이드

10.3
이전 다음
글로벌 속성 업데이트

글로벌 속성을 업데이트하려면 CMX_SYSTEM 스키마에 대해 다음 SQL 스크립트를 실행하면 됩니다.
다음 SQL 스크립트를 CMX_SYSTEM에 적용하면 해당 기본값을 사용하여 글로벌 속성이 초기화됩니다. 이러한 값을 수정하려면 이 스크립트의 VALUE 필드를 업데이트합니다.
insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.1', rowid_ds_pref, ' asyncChildLoading', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.2', rowid_ds_pref, 'bulkexportloadsize', '1000'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.3', rowid_ds_pref, 'CompositePagerTotalRecords', '5000'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';
insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.4', rowid_ds_pref, 'convert2DigitYearTo4Digit', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';
insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.5', rowid_ds_pref, 'credentialsAutofillDisabled', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.6', rowid_ds_pref, 'CSVColumnSeparator', ',' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, Create_Date, creator, Last_Update_Date, Updated_By, ROWID_DS_PREF, NAME, VALUE) 
select 
 'PREF_DET_4', sysdate, 'CMX', sysdate, 'admin', rowid_ds_pref, 'enableCreateBeMenuGrouping', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.7', rowid_ds_pref, 'enableRememberCredentials', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'IDDATT.0', rowid_ds_pref, 'enableTaskAttachments', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';


insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.8', rowid_ds_pref, 'expandDropDownListShowFullValue', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';
insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.9', rowid_ds_pref, 'exportusingmultithread', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.10', rowid_ds_pref, 'handleUserExitBeforeShowingDialog', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.11', rowid_ds_pref, 'HeaderBgColor', '#000000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.12', rowid_ds_pref, 'hmInactiveRelationshipsAvailable', 'false' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.13', rowid_ds_pref, 'IDD2COCSConverter.prefixCoNames', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.14', rowid_ds_pref, 'lookupCacheUpdatePeriod', '300000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.15', rowid_ds_pref, 'maxCopiedChildrenNumber', '10' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.16', rowid_ds_pref, 'maxCopiedGrandChildrenNumber', '10' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.17', rowid_ds_pref, 'maxImportThreads', '5'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.18', rowid_ds_pref, 'maxParallelPromoteThreads', '1' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.19', rowid_ds_pref, 'maxParallelBvtThreads', '1' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.20', rowid_ds_pref, 'maxSearchResultsExportedRows', '5000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.21', rowid_ds_pref, 'maxXrefSearchReturnCount', '100' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.22', rowid_ds_pref, 'openDashboardAfterTaskClose', 'false' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___'; 

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.23', rowid_ds_pref, 'proactiveMatchResultSort', 'sortbyscorethenaction'
from C_REPOS_DS_PREF where name = '__SYSTEM_PREFERENCES_ROOT__'; 

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.24', rowid_ds_pref, 'rememberCredentialsPeriod', '24' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.25', rowid_ds_pref, 'samCacheUpdatePeriod', '600000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.26', rowid_ds_pref, 'search_empty_date', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.27', rowid_ds_pref, 'searchForDuplicatesBeforeTaskDialog', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.28', rowid_ds_pref, 'serverPageSize', '100' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.29', rowid_ds_pref, 'shouldDisableSearchFieldIfDependentFieldAbsence', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.30', rowid_ds_pref, 'showMatchedColumns', '#DBF58C'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.31', rowid_ds_pref, 'subjectAreaCopyDisabled', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.32', rowid_ds_pref, 'table_default_width_key', '20' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
 'BDDGP.33', rowid_ds_pref, 'threadSchedulerIdleTime', '5000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.34', rowid_ds_pref, 'transactionTimeout', 300 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
 'BDDGP.35', rowid_ds_pref, 'updateExistingPeriodByDefault', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.36', rowid_ds_pref, 'writeBOM', 'false'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.37', rowid_ds_pref, 'isFillOnGap', 'false'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.38', rowid_ds_pref, 'maxXrefSearchReturnCount', '1000'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';
insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.39', rowid_ds_pref, 'deleteMovedRelInExplorerView', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

commit;
/
IDD 글로벌 속성
가이드 다운로드
피드백 보내기
커뮤니티
Knowledge Base
Success Portal
Rename Saved Search

목차

Data Director 구현 가이드

Data Director 구현 가이드

글로벌 속성 업데이트

글로벌 속성 업데이트
