zOs/TX/TATFUN

set current sqlid = 'S100447';

drop   function qz92crT.countTAT(i int);
--#SET TERMINATOR ?
create function qz92crT.countTAT(i int) returns varchar(100)
   applCompat V11R1
begin
declare c int;
declare res varchar(100) default '';
select count(*) into c
    from qz92crT.tqz91TATA
    where i1 = i;
set res = 'cnt=' || c || ' getArc=' || SYSIBMADM.get_ARCHIVE;
set SYSIBMADM.get_ARCHIVE = 'Y';
select count(*) into c
    from qz92crT.tqz91TATA
    where i1 = i;
return res || '... cnt=' || c || ' getArc=' || SYSIBMADM.get_ARCHIVE;
end
?
--#SET TERMINATOR ;
set current sqlid = 'S100447';
create view qz92crT.vCountTAT7 as
select qz92crT.countTAT(7) tat7 from sysibm.sysDummy1;
select * from qz92crT.vCountTAT7
set current sqlid = 'S100447';
drop function qz92crT.countTAT(i int);