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

Zuordnung neuer Kindtabellen

Keine neuen Kindtabellen vorhanden.

Vorbelegung für neue Datenbankfelder in bestehenden Tabellen

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'

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, '') = ''