Reorganization message rgo0003

Official Content
This documentation is valid for:

rgo0003
Table ' Country ' is referenced by table ' City ' and at least one attribute in its foreign key ( CountryCode) does not allow nulls. A default record will be added in table ' Country ' if table ' Client ' has records and a record with default values does not exist in table ' Country '. .

Rgo0003 Example

Trn Client
ClientCode*
ClientName
Trn Country
CountryCode*
CountryName
Trn City
CityyCode*
CityName
CountryCode  // FK
<v:shapetype coordsize="21600&#44;21600" filled="f" id="&#95;x0000&#95;t75" o&#58;preferrelative="t" o&#58;spt="75" path="m&#64;4&#64;5l&#64;4&#64;11&#64;9&#64;11&#64;9&#64;5xe" stroked="f">rgo0003ClientsAntes.png</v:shapetype> rgo0003CountryAntes.png rgo0003CityAntes.png

The reorganization consists in adding the not nullable CityCode attribute to the Client Transaction. The CityCode has not initial value, and the CountryCode has initial value=1. So the Client transaction structure is now like follows:

Trn Cient
ClientCode*
ClientName
CityCode

The Impact Analysis report is:

rgo0003.png

And the generated SQL Statements to run in this reorganization are:

rgo0003statements.png

As a result of executing this reorganization, the tables and records are:

Trn Client
ClientCode*
ClientName
CityCode
Trn Country
CountryCode*
CountryName
Trn City
CityyCode*
CityName
CountryCode  // FK
<v:shapetype coordsize="21600&#44;21600" filled="f" id="&#95;x0000&#95;t75" o&#58;preferrelative="t" o&#58;spt="75" path="m&#64;4&#64;5l&#64;4&#64;11&#64;9&#64;11&#64;9&#64;5xe" stroked="f">rgo0003ClientsDespues.png</v:shapetype> rgo0003CountryDespues.png rgo0003CityDespues.png


NOTE: In case the attributes CityCode or CountryCode are autonumber, the reorg must disable this property before doing the corresponding insert, and setting it back after these inserts.