International Uniform ChemicaL Information Database

1
International Uniform ChemicaL Information
Database Stefan J. Scheer Rémi Allanou
IUCLID
Advanced IUCLID Exercises
2
(No Transcript)
3
Merging of Data Sets
Ch. 1
Ch. 1
Ch. 2
Ch. 2
Copy chapter 5 from source 1 to source 2
Ch. 3
Ch. 5
Ch. 5
Source data set 1
Source data set 2 Destination
4
(No Transcript)
5
(No Transcript)
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
Practical Exercises
AD.1 A Now it is decided that both geraniol
data sets (from exercise DS1.6 and DS2.4 should
be merged into one with your data set (the one
from exercise DS1.6) to become the main one.
Merge both data sets! AD.2 A After the merge
it has been scientifically reported that purity
(chapter General Substance Information) has
generally to be seen as being greater than 93
g/l. You think this is worthwhile to be
acknowledged. Add another record! Check all
records of that sub-chapter. AD.3 A Create
your own chapter profile 0104 which filters
only chapter 1.0.4. AD.4 E Merge the
FreetextCollector template data set (from
exercise DS2.12) into your data set using the
new chapter profile 0104. AD.5 E Copy the
two available freetexts now into chapter 5.1.1
(using List available freetexts of same type).
14
Practical Exercises (cont.)
AD.6 A (Optional) Create your own chapter
profile in which you want to include only
non-confidential entries of the first chapter
(General Substance Information). Hint Usually
as confidential are regarded Production Amount,
Use Pattern, Additivies, Purity. AD.7 E Create
your own query For some reasons you have to find
out the internal data set number (DSN) together
with the revision date. As parameter a CAS number
will be inserted. Create a query for the English
language only. Define also a layout file. Leave
the font description part empty. Hint1 the SQL
is select dsn, rev_date_auto from ds_admin_tab
where subst_id like Hint 2 Copy an existing
layout file and modify it.