jsranko

x

jsranko

CREATE or replace function siiia.select_spool_data (in_user char(10), in_file char(10), in_startdatum char(8), in_enddatum char(8))
Returns Table (spooldata Varchar(32656))
Language Sql
Specific siiia/SISFSSD
Not Deterministic
modifies sql data
Returns Null On Null Input
Set Option Dbgview = *Source
Begin 
Declare Continue Handler For Sqlexception

jsranko

Create or Replace Function siiia.getQueryDefinition (qrylibrary char(10), qryfile char(10))
Returns Table(qrylib char(10),
              qryfile char(10),
              qrydef varchar(500))
language sql
Modifies Sql Data 
not fenced
begin 
declare clstmt varchar(1000);

jsranko

select a.table_schema,  a.table_name, b.table_partition, c.recorddata 
  from systables a
  join syspartitionstat b
    on a.table_name = b.table_name
   and a.table_schema = b.table_schema
  join table(siiia/SIPFM_ListData(a.table_schema,  a.table_name, b.table_partition)) c 
    on 1 = 1
 where a.file_type = 'S'
;

jsranko

-- UDTF:VIEW_DEPENDENCIES determines view dependencies


Create or Replace Function SI_VIEW_DEPENDENCIES(File Varchar(10), 
                                                Library Varchar(10))
Returns Table (Level Integer, 
               File Varchar(10),
               Library Varchar(10))
Language Sql
Specific SIVWDEPS