scripts/LJCOPY/env_updates/UAT3_MDM_EV_update.sql

-- Phase UAT3_MDM Environment Variables Update
-- Date: 24-07-2019
-- Author: Pooja/Joe

-- Navigation key: Menu -> Admin Menu -> 'N' -> 'Navigation Key'
UPDATE mdmadm.CI_MD_NAV SET URL_OVRD='http://sit3.mdm.energy.coop.local/mdm/cm/MDMUAT3.gif' WHERE NAVIGATION_KEY='CM_logoImage';

-- Menu -> Admin Menu -> 'F' -> 'Feature Configuration' -> 
UPDATE mdmadm.CI_WFM_OPT SET WFM_OPT_VAL='http://uat3.ccb.energy.coop.local/ccb/loginPage.jsp' WHERE WFM_NAME='CM-GENSYSCFG';

-- Menu -> Admin Menu -> 'M' -> 'Master Configuration' -> Click on 'Migration Assistant Configuration' (pencil)
UPDATE mdmadm.F1_MST_CONFIG SET MST_CONFIG_DATA='<configuration><exportDirectory>/u01/ouaf/ouafoutput/MDMUAT3/CCB240_THORCFG/cma/export</exportDirectory><importDirectory>/u01/ouaf/ouafoutput/MDMUAT3/CCB240_THORCFG/cma/import</importDirectory><fileExtension>txt</fileExtension></configuration>' WHERE BUS_OBJ_CD='F1-MigrationAssistantConfig';

-- Menu -> Admin Menu -> Master Configuration -> Generic BI Configuration -> File Path needs to be updated to reflect the environment.
UPDATE mdmadm.F1_MST_CONFIG SET MST_CONFIG_DATA='<description>Master Configuration for BI</description><generalMasterConfiguration><filePath>/u01/ouaf/ouafoutput/MDMSIT3/D1ExtractFiles</filePath><characterEncoding>UTF-8</characterEncoding></generalMasterConfiguration>' WHERE BUS_OBJ_CD='F1-BIGeneralMasterConfig';

-- Menu -> Admin Menu -> 'X' -> 'XAI JNDI server'
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.139:6950' WHERE XAI_JNDI_SVR_ID = 'CCB_JMS';		
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6951' WHERE XAI_JNDI_SVR_ID = 'CCB_JNDI';		
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6953' WHERE XAI_JNDI_SVR_ID = 'SGG_JNDI';
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6972' WHERE XAI_JNDI_SVR_ID = 'DM_BOL_JNDI';
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.140:6950' WHERE XAI_JNDI_SVR_ID = 'MDM_JMS';