08/03/81 builtin_functions The following builtin functions are implemented within LINUS. Set functions operate on the results of a SELECT-FROM-WHERE block, while scalar functions operate on single items. Refer to the LINUS manual (Order No. AZ49) for more complete information. Set functions: avg {select X from ...} average (mean) of all X values selected. count {select X1 X2 ... from ...} counts the number of sets of Xi which have been selected. max {select X from ...} maximum of all X values selected. min {select X from ...} minimum of all X values selected. sum {select X from ...} total of all X values selected. Scalar functions (arithmetic): abs (X) absolute value of X. ceil (X) the smallest integer larger than X. floor (X) the largest integer smaller than X. mod (X, Y) X modulus Y. round (X, Q) the rounding of the value of X. Scalar functions (string): after (S1, S2) that portion of S1 occurring after the leftmost occurrence of S2 within S1. before (S1, S2) that portion of S1 occurring before the leftmost occurrenceof S2 within S1. concat (S1, S2) the concatenation of S1 and S2. index (S1, S2) the position in S1 of the beginning of the leftmost occurrence of S2 within S1. reverse (S) the reverse of S. search (C1, C2) the position in C1 of the leftmost occurrence of any character contained in C2. substr (S, I, J) that portion of S beginning with the Ith position and of length J. verify (C1, C2) the position of the first character of C1 that does not occur in C2. ----------------------------------------------------------- Historical Background This edition of the Multics software materials and documentation is provided and donated to Massachusetts Institute of Technology by Group BULL including BULL HN Information Systems Inc. as a contribution to computer science knowledge. This donation is made also to give evidence of the common contributions of Massachusetts Institute of Technology, Bell Laboratories, General Electric, Honeywell Information Systems Inc., Honeywell BULL Inc., Groupe BULL and BULL HN Information Systems Inc. to the development of this operating system. Multics development was initiated by Massachusetts Institute of Technology Project MAC (1963-1970), renamed the MIT Laboratory for Computer Science and Artificial Intelligence in the mid 1970s, under the leadership of Professor Fernando Jose Corbato. Users consider that Multics provided the best software architecture for managing computer hardware properly and for executing programs. Many subsequent operating systems incorporated Multics principles. Multics was distributed in 1975 to 2000 by Group Bull in Europe , and in the U.S. by Bull HN Information Systems Inc., as successor in interest by change in name only to Honeywell Bull Inc. and Honeywell Information Systems Inc. . ----------------------------------------------------------- Permission to use, copy, modify, and distribute these programs and their documentation for any purpose and without fee is hereby granted,provided that the below copyright notice and historical background appear in all copies and that both the copyright notice and historical background and this permission notice appear in supporting documentation, and that the names of MIT, HIS, BULL or BULL HN not be used in advertising or publicity pertaining to distribution of the programs without specific prior written permission. Copyright 1972 by Massachusetts Institute of Technology and Honeywell Information Systems Inc. Copyright 2006 by BULL HN Information Systems Inc. Copyright 2006 by Bull SAS All Rights Reserved