What Bundle are you currently at?

Use this SQL to find which version are you currently at:

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG
FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like '%BUNDLE%' ORDER BY 2 DESC

Update all address types expect HOME and PERM to non-system data

--Update all address types expect home and perm to non-system data

UPDATE PS_ADDRESS_TYP_TBL
SET DATA_TYPE_CD = 'S'
WHERE ADDRESS_TYPE NOT IN ('HOME', 'PERM')

Copying Equation Engine from One Environment to Another

--SECURITY FOR  EQUATION ENGINE
INSERT INTO DBENVTARGET.dbo.PS_EQTN_ID_NAMAUTH
SELECT * FROM DBENVSOURCE.dbo.PS_EQTN_ID_NAMAUTH WHERE EQUATION_NAME = 'EQUATION_ENGINE_NAME'

-- ADD TABLES INTO EQUATION ENGINE
INSERT INTO DBENVTARGET.dbo.PS_EQTN_DATA_TBL
SELECT * FROM DBENVSOURCE.dbo.PS_EQTN_DATA_TBL WHERE EQTN_DATA_RECNAME IN ('TABLE_NAME1', 'TABLE_NAME2', 'TABLE_NAME3'')

-- SECURITY FOR TABLES
INSERT INTO DBENVTARGET.dbo.PS_EQTN_TB_RECAUTH
SELECT * FROM DBENVSOURCE.dbo.PS_EQTN_TB_RECAUTH WHERE EQTN_DATA_RECNAME IN ('TABLE_NAME1', 'TABLE_NAME2', 'TABLE_NAME3'')

--SECURITY FOR EQUATION_ENGINE SQL
INSERT INTO DBENVTARGET.dbo.PS_EQTN_SQ_SQLAUTH
SELECT * FROM DBENVSOURCE.dbo.PS_EQTN_SQ_SQLAUTH WHERE EQTN_OPERAND_SQL = 'SL_NAME'
AND EFFDT = '2014-07-01'

--ALL NEW EQUATION ENGINE TABLE
INSERT INTO DBENVTARGET.dbo.PS_EQUATION_TBL
SELECT * FROM DBENVSOURCE.dbo.PS_EQUATION_TBL WHERE EFFDT = '2014-07-01'
AND EQUATION_NAME = 'EQN_NAME'

--ALL NEW EQUATION ENGINE CODE
INSERT INTO DBENVTARGET.dbo.PS_EQUATION_DTL
SELECT * FROM DBENVSOURCE.dbo.PS_EQUATION_DTL WHERE EFFDT = '2014-07-01'
AND EQUATION_NAME = 'EQN_NAME'