HowTo 2. Create new version for existing data table.
In this document we explain how to add another version 'TIFG-01' for node TIFG
in the ATLAS Geometry DB.
We assume that all the steps described in previous HowTo
have already been performed
and table TIFG_DATA contains two records with ID = 0,1. Say we want to modify
just one field in the first record and put Nelem=15. We produce a new record with
ID = 2 and call the records with ID = 2,1 the tag 'TIFG-01'.
- Step 1. Declare the new tag labeled 'TIFG-01' of TIFG node.
Go to
web tool, provide username/password and follow the link Create new tag. From drop-down list select TIFG and click Next. Enter new tag name TIFG-01 and click create. You will get
an ID for this new tag which should be used later in SQL scripts.
- Step 2.Insert new record in TIFG data table.
Modify ~tsulaia/public/start_sqlplus.sh replacing the user name atlasdd_reader by atlasdd_writer and start SQLPLUS by sourcing this script. Invoke following command.
# insert into atlasdd.tifg_data values (2, 1, 15, 43.05);
- Step 3. Commit your modifications.
# commit;
- Step 4. Exit sqlplus.
# exit
- Step 5. Assign two TIFG records with ID=1,2 to TIFG-01 tag.
Follow the link Collect leaf tags. Select the TIFG node from the list, then select TIFG-01 tag and click Collect.
You will get the entire TIFG data table. Select records to with ID=1,2 and click Collect Selected Records.
Back