IBM GC09-2830-00 manual Working with the System Administrative Group, OS/2

db2 => select empno, function, firstname, lastname, birthdate, from \ db2 (cont.) => employee where function=©service© and \

db2 (cont.) => firstname=©Lily© order by empno desc

To end interactive input mode, enter the quit command.

For more information on advanced topics using the CLP, refer to the Command Reference.

Working with the System Administrative Group

By default, System Administrative (SYSADM) authority is granted to the following:

OS/2	Any valid DB2 user ID which belongs to the Administrator or
	Local Administrator group.

Windows 9x Any Windows 9x user.

For information on how to change the default SYSADM settings and how to assign this authority to a different user or set of users, refer to the Administration Guide.

138Quick Beginnings