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

Zuordnung neuer Kindtabellen

Keine neuen Kindtabellen vorhanden.

*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

update
    "@IAG_WAS0"
set
    "U_PackStats" = 'OPEN'
where
    ifnull("U_PackStats", '') = ''

update
    "@IAG_RAT1"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_PBS1"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_WAS4"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_WEN4"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_PRD1"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_APR31"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_MHU_MHU0"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_VVS3"
set
    "U_OrigPackg" = '0'
where
    "U_OrigPackg" is null

update
    "@IAG_VVS3"
set
    "U_DemandMhu" = '0'
where
    "U_DemandMhu" is null

update
    "@IAG_VVS3"
set
    "U_OrigMhu" = '0'
where
    "U_OrigMhu" is null

update
    "@IAG_VVS3"
set
    "U_NoOrigMhu" = '0'
where
    "U_NoOrigMhu" is null

update
    "@IAG_VVS3"
set
    "U_PossblMhu" = '0'
where
    "U_PossblMhu" is null

update
    "@IAG_VVS3"
set
    "U_Processing" = '1'
where
    ifnull("U_Processing", '0') = '0'

update
    "@IAG_VVS3"
set
    "U_GexNumber" = ''
where
    ifnull("U_GexNumber", '') = ''

update
    "@IAG_WEV3"
set
    "U_Processing" = '1'
where
    ifnull("U_Processing", '0') = '0'

update
    "@IAG_WEV3"
set
    "U_GenNumber" = ''
where
    ifnull("U_GenNumber", '') = ''

update
    "@IAG_PVS3"
set
    "U_Processing" = '1'
where
    ifnull("U_Processing", '0') = '0'

SQL

update
    [IAG_WAS0]
set
    U_PackStats = 'OPEN'
where
    isnull(U_PackStats, '') = ''

update
    [IAG_RAT1]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_PBS1]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_WAS4]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_WEN4]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_PRD1]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_APR31]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_MHU_MHU0]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_VVS3]
set
    U_OrigPackg = '0'
where
    U_OrigPackg is null

update
    [IAG_VVS3]
set
    U_DemandMhu = '0'
where
    U_DemandMhu is null

update
    [IAG_VVS3]
set
    U_OrigMhu = '0'
where
    U_OrigMhu is null

update
    [IAG_VVS3]
set
    U_NoOrigMhu = '0'
where
    U_NoOrigMhu is null

update
    [IAG_VVS3]
set
    U_PossblMhu = '0'
where
    U_PossblMhu is null

update
    [IAG_VVS3]
set
    U_Processing = '1'
where
    isnull(U_Processing, '') = ''

update
    [IAG_VVS3]
set
    U_GexNumber = ''
where
    isnull(U_GexNumber, '') = ''

update
    [IAG_WEV3]
set
    U_Processing = '1'
where
    isnull(U_Processing, '') = ''

update
    [IAG_WEV3]
set
    U_GenNumber = ''
where
    isnull(U_GenNumber, '') = ''

update
    [IAG_PVS3]
set
    U_Processing = '1'
where
    isnull(U_Processing, '') = ''