zOs/SQL/BEY

select * from                oa1t.TPO001a1;
select * from                oa1t.TPO002a1;
select * from                oa1t.TPO003a1;
select * from                oa1t.TPO004a1;
select * from                oa1t.TPO005a1;
select * from                oa1t.TPO006a1;
sdf
set current sqlid = 's100447';
-- drop ALIAS oa1t.TPO001A1 ;
-- drop ALIAS oa1t.TPO001A3 ;
-- drop ALIAS oa1t.TPO001A4 ;
-- drop ALIAS oa1t.TPO001A5 ;
-- drop ALIAS oa1t.TPO001A6 ;
commit;
CREATE ALIAS oa1t.TPO001A1 FOR    OA1z.TPO001A1;
CREATE ALIAS oa1t.TPO003A1 FOR    OA1z.TPO003A1;
CREATE ALIAS oa1t.TPO004A1 FOR    OA1z.TPO004A1;
CREATE ALIAS oa1t.TPO005A1 FOR    OA1z.TPO005A1;
CREATE ALIAS oa1t.TPO006A1 FOR    OA1z.TPO006A1;
commit;
CREATE ALIAS oa1t.TPO001A1 FOR    CHSKA000DBZF.OA1t.TPO001A1;
CREATE ALIAS oa1t.TPO003A1 FOR    CHSKA000DBZF.OA1t.TPO003A1;
CREATE ALIAS oa1t.TPO004A1 FOR    CHSKA000DBZF.OA1t.TPO004A1;
CREATE ALIAS oa1t.TPO005A1 FOR    CHSKA000DBZF.OA1t.TPO005A1;
CREATE ALIAS oa1t.TPO006A1 FOR    CHSKA000DBZF.OA1t.TPO006A1;
commit;
CREATE ALIAS oa1t.TPO001A1 FOR    OA1z.TPO001A1;
CREATE ALIAS oa1t.TPO001A3 FOR    OA1z.TPO003A1;
CREATE ALIAS oa1t.TPO001A4 FOR    OA1z.TPO004A1;
CREATE ALIAS oa1t.TPO001A5 FOR    OA1z.TPO005A1;
CREATE ALIAS oa1t.TPO001A6 FOR    OA1z.TPO006A1;
commit;
select * from                oa1t.TPO002A1;
sdf
select * from        sysibm.locations;
--DROP   ALIAS oa1t.TPO002A1 ;
-- CREATE ALIAS oa1t.TPO002A1 FOR    CHSKA000DBZF.OA1t.TPO002A1;
CREATE ALIAS oa1t.TPO002A1 FOR    OA1z.TPO002A1;
commit;
-- select * from    CHSKA000DBZF.oa1z.TPO002A1;
select * from    oa1z.TPO002A1;
commit;
                     OA1Z. TPO002A1
                           TPO003A1
                           TPO004A1
                           TPO005A1
                           TPO006A1
                           TPO001A1