CREATE TABLE BANKROLL_SDEPO (
  ID_BANKROLL	INTEGER	NOT NULL,
  ID_PERSON_FUND	INTEGER	NOT NULL,
  ID_ALLOC_TIME	INTEGER	NOT NULL	DEFAULT 1,
  VARIANT_DATE	DATE	NOT NULL	DEFAULT '0001-01-01',
  BOOK_DATE	DATE	NOT NULL,
  QUANTITY_START	DECIMAL(31, 14)	NOT NULL,
  DELTA_IN	DECIMAL(31, 14)	NOT NULL	DEFAULT 0,
  DELTA_OUT	DECIMAL(31, 14)	NOT NULL	DEFAULT 0,
  DELTA_REV	DECIMAL(31, 14)
) in userspace1;

CREATE INDEX BANKROLL_SDEPO01
  ON BANKROLL_SDEPO
    ( ID_BANKROLL ASC, BOOK_DATE ASC, ID_PERSON_FUND ASC, ID_ALLOC_TIME ASC, VARIANT_DATE ASC );

alter table BANKROLL_SDEPO volatile;

CREATE OR REPLACE VIEW VBANKROLL_SDEPO
    ( ID_PERSON_FUND, ID_ALLOC_TIME, ID_BANKROLL, QUANTITY_START, DELTA_IN,
    DELTA_OUT, DELTA_REV, QUANTITY_END, START_DATE, END_DATE,
    VARIANT_DATE )
AS
select 
t1.ID_PERSON_FUND, t1.ID_ALLOC_TIME, t1.ID_BANKROLL, t1.QUANTITY_START, t1.DELTA_IN, t1.DELTA_OUT, t1.DELTA_REV
, t1.QUANTITY_START + t1.DELTA_IN - t1.DELTA_OUT + coalesce(t1.DELTA_REV, 0), t1.BOOK_DATE
, coalesce(max(t1.BOOK_DATE) over (partition by t1.ID_BANKROLL, t1.ID_ALLOC_TIME, t1.VARIANT_DATE, t1.ID_PERSON_FUND order by t1.BOOK_DATE ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) - 1 DAY, nullif(t1.VARIANT_DATE, '0001-01-01'), '9999-01-01'), t1.VARIANT_DATE 
from BANKROLL_SDEPO t1;

explain all for 
select * from VBANKROLL_SDEPO tTotal 
where tTotal.ID_PERSON_FUND = ?
and tTotal.ID_BANKROLL = ?
  and tTotal.ID_ALLOC_TIME = ?
  and tTotal.VARIANT_DATE = ?;

  public void FED_ACCELERATOR_01 (
// inputs
    String url
  , String stmt 
/* 
   Output fields.
   Their number and data types must correspond to the fields 
   of the select statement above
*/
  , String               __String
  , int                  __Int
  , String               __Timestamp
  , String               __Date
  , java.math.BigDecimal __Decimal
  , String               __Decfloat
  ) throws Exception {
    // the whole logic is already here
    FED_ACCELERATOR_00(url, stmt);
  }

SELECT T.TABNAME, C.*
FROM SYSCAT.TABLES T
, TABLE(FED.GET_VARCHAR(
  'com.ibm.db2.jcc.DB2Driver' 
, 'jdbc:db2://localhost:50002/sample:retrieveMessagesFromServerOnGetMessage=true;' 
, 'db2inst1', '***' 
, 'SELECT COLNAME FROM SYSCAT.COLUMNS WHERE TABSCHEMA='''||T.TABSCHEMA||''' AND TABNAME='''||T.TABNAME||''''
, NULL
)) C
WHERE T.TABSCHEMA='SYSCAT' AND T.TABNAME IN ('ATTRIBUTES', 'AUDITPOLICIES')