SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-193
GET ALL SECURITY_ADMINS Statement
•
This is an example of insert…select with an IDENTITY column:
create table tab1(a largeint generated always as identity, b
int);
--- SQL operation complete.
prepare xx from insert into tab1 values(DEFAULT, 1);
--- SQL command prepared.
explain options 'f' xx;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- --------------- ---------
9 . 10 root r 1.00E+000
6 8 9 tuple_flow 1.00E+000
7 . 8 partition_access 1.00E+000
. . 7 insert TAB1 1.00E+000
1 5 6 nextvaluefor 1.00E+000
4 . 5 esp_access 1.00E+000
3 . 4 sequencegenerator 1.00E+000
2 . 3 partition_access 1.00E+002
. . 2 subset_update "@@INTERNAL_SG_19505 1.00E+002
. . 1 values 1.00E+000
--- SQL operation complete.
>>
GET ALL SECURITY_ADMINS Statement
Considerations for GET ALL SECURITY_ADMINS
Examples of GET ALL SECURITY_ADMINS
The GET ALL SECURITY_ADMINS statement lists the users in the Security
Administrators Group.
GET ALL SECURITY_ADMINS is an SQL/MX extension.
GET ALL SECURITY_ADMINS