Db2 learning instruction (III)

41. list all tables db2 list tables 42. insert data: db2 insert into tb1 values (1, 'Sam '); db2 insert into tb2 values (2, 'smitty'); www.2cto.com 42. create the SAMPLE database db2sampl db2sampl F :( specify the installation disk) 43. use the operating system command! Dir 44. cast select empno, CAST (resume as varchar (370) FROM EMP_RESUME WHERE RESUME_FORMAT = 'ascii '45. to run a DB2 Java stored procedure or UDF, you also need to update the DB2 database management program configuration on the server, including the path to install JDK on the machine db2 update dbm cfg using JDK11_PATH d: sqllibjavajdk TERMINATE update dbm cfg using SPM_NAME sample www.2cto.com 46. check that the DB2 database administrator configures db2 get dbm cfg 47. retrieve all privileged authorization names select distinct grantee, GRANTEETYPE, 'database' from syscat. dbauth union select distinct grantee, GRANTEETYPE, 'table' from syscat. tabauth union select distinct grantee, GRANTEETYPE, 'package' from syscat. packageauth union select distinct grantee, GRANTEETYPE, 'index' from syscat. indexauth union select distinct grantee, GRANTEETYPE, 'column' from syscat. colauth union select distinct grantee, GRANTEETYPE, 'scheme' from syscat. schemaauth union select distinct grantee, GRANTEETYPE, 'server' from syscat. passthruauth order by grantee, GRANTEETYPE, 3 create table yhdab www.2cto.com (id varchar (10), password varchar (10), ywlx varchar (10), kh varchar (10 )); create table ywlbb (ywlbbh varchar (8), ywmc varchar (60) 48. alter table yhdab ALTER kh set data type varchar (13); alter table yhdab alter id set data type varchar (13); alter table lst_bsi alter bsi_money set data type int; insert into yhdab values ('123456', '123456', 'user01', '1234568'), ('1234568', 'user02', '1234568 '); 49. business type description insert into ywlbb values www.2cto.com ('user01', 'business requests'), ('user02', 'business undo '), ('user03 ', 'fee query'), ('user04 ', 'fee self-paid'), ('user05 ', 'fee deposit'), ('user06', 'password modified '), ('user07', 'invoice print'), ('gl01', 'change user basic information'), ('gl02', 'change payment information '), ('gl03', 'daily statistical function'), ('gl04 ', 'accounting function'), ('gl05', 'reconciliation function'), ('gl06 ', 'billing function'), ('gl07', 'Comprehensive statistics') backup DATABASE: connect to exoa; quiesce database immediate force connections; connect reset; www.2cto.com backup database exoa to "/home/exoa2/db2bak/" WITH 2 buffers buffer 1024 PARALLELISM 1 without prompting; connect to exoa; unquiesce database; connect reset; author manULinux