Beim Wechsel auf Release 4.6 sind zusätzlich zu den Allgemeinen Hinweisen noch folgende Punkte zu beachten.

Zuordnung neuer Kindtabellen

• IAG_PRD
  • IAG_PRD10
  • IAG_PRD11

*Die folgenden Änderungen sollten vom Upgrade-Wizard vollautomatisch angewendet werden. Die manuelle Durchführung ist nur nötig falls während des Upgrade-Prozesses Fehler auftreten.

Vorbelegung für neue Datenbankfelder in bestehenden Tabellen

HANA

Setting default value for @IAG_PRD8.U_ProvType
UPDATE "@IAG_PRD8" 
SET "U_ProvType" = 'FP' 
WHERE ISNULL("U_ProvType", '') = ''

Setting default value for @IAG_PRD8.U_QtyPerHr
UPDATE "@IAG_PRD8" 
SET "U_QtyPerHr" = '0' 
WHERE "U_QtyPerHr" IS NULL

Setting default value for @IAG_APR10.U_ProvType
UPDATE "@IAG_APR10" 
SET "U_ProvType" = 'FP' 
WHERE ISNULL("U_ProvType", '') = ''

Setting default value for @IAG_APR10.U_QtyPerHr
UPDATE "@IAG_APR10" 
SET "U_QtyPerHr" = '0' 
WHERE "U_QtyPerHr" IS NULL

UPDATE "@IAG_PRD0" 
SET "U_Type" = 'G' 
WHERE "U_Type" = 'K' 
AND ISNULL("U_Itemcode", '') = ''

Setting default value for @IAG_TOL0.U_Strokes
UPDATE "@IAG_TOL0" 
SET "U_Strokes" = '0' 
WHERE "U_Strokes" IS NULL

Setting default value for @IAG_MCH0.U_Strokes
UPDATE "@IAG_MCH0" 
SET "U_Strokes" = '0' 
WHERE "U_Strokes" IS NULL

Setting default value for @IAG_TOL0.U_MntStrks
UPDATE "@IAG_TOL0" 
SET "U_MntStrks" = '0' 
WHERE "U_MntStrks" IS NULL

Setting default value for @IAG_MCH0.U_MntStrks
UPDATE "@IAG_MCH0" 
SET "U_MntStrks" = '0' 
WHERE "U_MntStrks" IS NULL

Setting default value for @IAG_TOL0.U_MntIntvl
UPDATE "@IAG_TOL0" 
SET "U_MntIntvl" = '0' 
WHERE "U_MntIntvl" IS NULL

Setting default value for @IAG_MCH0.U_MntIntvl
UPDATE "@IAG_MCH0" 
SET "U_MntIntvl" = '0' 
WHERE "U_MntIntvl" IS NULL

Setting default value for @IAG_TOL0.U_MntDurtn
UPDATE "@IAG_TOL0" 
SET "U_MntDurtn" = '0' 
WHERE "U_MntDurtn" IS NULL

Setting default value for @IAG_MCH0.U_MntDurtn
UPDATE "@IAG_MCH0" 
SET "U_MntDurtn" = '0' 
WHERE "U_MntDurtn" IS NULL

Replacing value 'ZAV' with 'PROFORMA_INVOICE' in field "@IAG_POT0".U_Gpr
UPDATE "@IAG_POT0" 
SET "U_Gpr" = 'PROFORMA_INVOICE' 
WHERE "U_Gpr" = 'ZAV'

Replacing value 'GUT' with 'PROFORMA_INVOICE' in field "@IAG_HSV0".U_Gpr 
WHERE "U_Prozkz" = 'PROFORMA_INVOICE'
UPDATE "@IAG_HSV0" 
SET "U_Gpr" = 'PROFORMA_INVOICE' 
WHERE "U_Gpr" = 'GUT' 
AND "U_Prozkz" = 'PROFORMA_INVOICE'

Setting default value for "@IAG_ATM_BPE0".U_DelPus
UPDATE "@IAG_ATM_BPE0" 
SET "U_DelPus" = 'N' 
WHERE ISNULL("U_DelPus", '') = ''

SQL

-- Setting default value for @IAG_PRD8.U_ProvType
UPDATE [@IAG_PRD8]
SET U_ProvType = 'FP'
WHERE ISNULL(U_ProvType, '') = ''

-- Setting default value for @IAG_PRD8.U_QtyPerHr
UPDATE [@IAG_PRD8]
SET U_QtyPerHr = '0'
WHERE U_QtyPerHr IS NULL

-- Setting default value for @IAG_APR10.U_ProvType
UPDATE [@IAG_APR10]
SET U_ProvType = 'FP'
WHERE ISNULL(U_ProvType, '') = ''

-- Setting default value for @IAG_APR10.U_QtyPerHr
UPDATE [@IAG_APR10]
SET U_QtyPerHr = '0'
WHERE U_QtyPerHr IS NULL

-- Update @IAG_PRD0
UPDATE [@IAG_PRD0]
SET U_Type = 'G'
WHERE U_Type = 'K' AND ISNULL(U_Itemcode, '') = ''

-- Setting default value for @IAG_TOL0.U_Strokes
UPDATE [@IAG_TOL0]
SET U_Strokes = '0'
WHERE U_Strokes IS NULL

-- Setting default value for @IAG_MCH0.U_Strokes
UPDATE [@IAG_MCH0]
SET U_Strokes = '0'
WHERE U_Strokes IS NULL

-- Setting default value for @IAG_TOL0.U_MntStrks
UPDATE [@IAG_TOL0]
SET U_MntStrks = '0'
WHERE U_MntStrks IS NULL

-- Setting default value for @IAG_MCH0.U_MntStrks
UPDATE [@IAG_MCH0]
SET U_MntStrks = '0'
WHERE U_MntStrks IS NULL

-- Setting default value for @IAG_TOL0.U_MntIntvl
UPDATE [@IAG_TOL0]
SET U_MntIntvl = '0'
WHERE U_MntIntvl IS NULL

-- Setting default value for @IAG_MCH0.U_MntIntvl
UPDATE [@IAG_MCH0]
SET U_MntIntvl = '0'
WHERE U_MntIntvl IS NULL

-- Setting default value for @IAG_TOL0.U_MntDurtn
UPDATE [@IAG_TOL0]
SET U_MntDurtn = '0'
WHERE U_MntDurtn IS NULL

-- Setting default value for @IAG_MCH0.U_MntDurtn
UPDATE [@IAG_MCH0]
SET U_MntDurtn = '0'
WHERE U_MntDurtn IS NULL

-- Replacing value 'ZAV' with 'PROFORMA_INVOICE' in field @IAG_POT0.U_Gpr
UPDATE [@IAG_POT0]
SET U_Gpr = 'PROFORMA_INVOICE'
WHERE U_Gpr = 'ZAV'

-- Replacing value 'GUT' with 'PROFORMA_INVOICE' in field @IAG_HSV0.U_Gpr where U_Prozkz is 'PROFORMA_INVOICE'
UPDATE [@IAG_HSV0]
SET U_Gpr = 'PROFORMA_INVOICE'
WHERE U_Gpr = 'GUT' AND U_Prozkz = 'PROFORMA_INVOICE'

-- Setting default value for @IAG_ATM_BPE0.U_DelPus
UPDATE [@IAG_ATM_BPE0]
SET U_DelPus = 'N'
WHERE ISNULL(U_DelPus, '') = ''