5,891
社区成员




C:\>db2 connect to WLBUAT user db2 using db2
Database Connection Information
Database server = DB2/NT64 9.7.3
SQL authorization ID = DB2
Local database alias = WLBUAT
C:\>db2 get authorizations
Administrative Authorizations for Current User
Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = NO
Direct CREATETAB authority = NO
Direct BINDADD authority = NO
Direct CONNECT authority = NO
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = NO
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO
Indirect SYSADM authority = YES
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = YES
Indirect CREATETAB authority = YES
Indirect BINDADD authority = YES
Indirect CONNECT authority = YES
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = YES
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO
C:\>
C:\>db2 connect to WLBUAT user db2 using db2
Database Connection Information
Database server = DB2/NT64 9.7.3
SQL authorization ID = DB2
Local database alias = WLBUAT
C:\>db2 alter table COMDOI000 alter attr1_val set data type varchar(256)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0270N Function not supported (Reason code = "21"). SQLSTATE=42997
C:\>