This text was automatically converted from troff me macros to HTML. Information may have been lost, added, or changed in the process. Lars Aronsson and Lysator do not guarantee the correctness of this HTML document.
append *- append tuples to a relation
append classname
( att_name1 = expression1 {, att_name-i = expression-i} )
[ from from_list ] [ where qual ]
Append adds instances which satisfy the qualification, qual , to classname . Classname must be the name of an existing class. The target list specifies the values of the fields to be appended to classname . The fields may be listed in any order. Fields of the result class which do not appear in the target list are default a null value. If the expression for each field is not of the correct data type, automatic type coercion will be attempted.
The keyword all can be used when it is desired to append all domains of a class to another class.
/* Make a new employee Jones work for Smith */
append emp (newemp.name, newemp.salary, mgr = "Smith",
bdate = 1990 - newemp.age)
where newemp.name = "Jones"
/* same command using the from list clause */
append emp (n.name, n.salary, mgr = "Smith",
bdate = 1990 - n.age)
from n in newemp
where n.name = "Jones"
/* Append the newemp1 class to newemp */
append newemp (newemp1.all)
postquel(commands), retrieve(commands), define type(commands).