DB29 for Linux,UNIX,and WINDOWS - section 6(DB2 SQL)

OLD/New/Final Table:

SELECT salary FROM OLD TABLE (
UPDATE employee SET salary = salary* 1.07 WHERE empno= '000220'
);

 

SQL error msg

Signal Sqlstate '70001'

set message_text='Record not found';

 

Deletable view.

only one base table,no functions, such as distinct,max,group by and so on.

 

Trigger:

when insert one row, then update some columns

Create Trigger a after insert on table1

referencing new as N

for each row mode DB2SQL

update table1

 

Grouping sets/Rollup/Cube/TableSample(Bernoulli)

 

Values
Values Year('1996');

 

SYSCAT/SYSIBMADM/SYSSTAT:

db2 "select 'grant select on table '||(tabschema)||'.'||tabname||'to user user1;' from syscat.tables where type='T' and tabschema not in ('SYSIBM','SYSCAT','SYSSTAT','SYSTOOLS')">grant.sql