zOs/SQL/FUNC

set current sqlid  = 'S100447';
-- drop   function t1.f1(n int);
create function A540769.fCr(i varchar(10)) returns varchar(50)
    return 'A540769.fCr(' || i || ')';
create function oa1a.fCr(i varchar(10)) returns varchar(50)
    return 'oa1a.fCr(' || i || ', ' || a540769.fCr('->' || i) || ')';
select A540769.fCr('eins'), oa1a.fCr('zwei') from sysibm.sysDummy1;
set path oa1a;
select fCr('paOA1A') from sysibm.sysDummy1;
set path A540769;
select fCr('paA540') from sysibm.sysDummy1;
create procedure A540769.pCr(in i varchar(10), out o varchar(50))
 -- qualifier A540769
    sql path sysproc, x540769
    set o = fCr(i)
;
;;,
    return 't1.f1=' || fosFmte7(n)
;
select t1.f1(123) from sysibm.sysDummy1;
set current path t1;
select    f1(456) from sysibm.sysDummy1;
call abc;
select 'sqlid ' || left(current sqlid, 9)
   ||  ' schema ' || left(current schema, 9) || 'path ' || current path
    from sysibm.sysDummy1
;
set current schema = 'S100447';
select 'sqlid ' || left(current sqlid, 9)
   ||  ' schema ' || left(current schema, 9) || 'path ' || current path
    from sysibm.sysDummy1
;
commit;
select 'sqlid ' || left(current sqlid, 9)
   ||  ' schema ' || left(current schema, 9) || 'path ' || current path
    from sysibm.sysDummy1
;
commit;
set current sqlid = 'A540769';
select 'sqlid ' || left(current sqlid, 9) || 'path ' || current path
    from sysibm.sysDummy1
;
;;;
set current sqlid = 'S100447';
select oa1a.fosFmtE7(123.45) from sysibm.sysDummy1;
set current path oa1a;
select      fosFmtE7(123.45) from sysibm.sysDummy1;
drop   function t1.f1(n int);
create function t1.f1(n int) returns varchar(11)
    return 't1.f1=' || fosFmte7(n)
;
select t1.f1(123) from sysibm.sysDummy1;
set current path t1;
select    f1(456) from sysibm.sysDummy1;