Code:
-
- values current schema;
-
- cl: chgcurlib *crtdft;
- cl: rmvlible libsql1;
- cl: rmvlible libsql2;
-
- cl: dltlib libsql1;
- cl: dltlib libsql2;
-
- cl: crtlib libsql1;
- cl: crtlib libsql2;
-
- cl: chglibl (libsql1 libsql2);
-
- select *
- from qsys2.library_list_info;
-
- drop view view_one;
- drop view view_two;
- drop view view_two_subselect;
-
- drop table table_master;
- drop table table_child1;
- drop table table_child2;
-
- create table table_master
- (id int,
- text char(25));
-
- select *
- from systables
- where table_name = 'TABLE_MASTER';
-
- drop table qgpl.table_master;
-
- create table libsql1.table_master
- (id int,
- text char(25),
- foreign_key int);
-
- create table libsql1.table_child1
- (id int,
- text char(25));
-
- create table libsql2.table_child2
- (id int,
- text char(25));
-
- select *
- from qsys2.library_list_info;
-
- create view view_zero
- (id, text)
- as (select id, text from table_master);
-
- create view view_one
- (m_id, m_text, c_id, c_text)
- as (select m.id, m.text, m.foreign_key, c.text
- from table_master m
- left join table_child1 c on m.foreign_key = c.id);
-
- select *
- from sysviews
- where table_name = 'VIEW_ONE';
-
- create view view_two
- (m_id, m_text, c_id, c_text)
- as (select m.id, m.text, m.foreign_key, c.text
- from table_master m
- left join table_child2 c on m.foreign_key = c.id);
-
- select *
- from sysviews
- where table_name = 'VIEW_TWO';
-
- create view view_two_subselect
- (m_id, m_text, c_id, c_text)
- as (select m.id, m.text, m.foreign_key, (select text from table_child2)
- from table_master m);
-
- select *
- from sysviews
- where table_name like 'VIEW_%';
-
- select *
- from qsys2.library_list_info;
-
- values current schema;
-
|
|