create table xxx_200101(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200101 check(td between '2001-01-01' and '2001-01-31'),
  constraint p200101 primary key(id));

create table xxx_200102(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200102 check(td between '2001-02-01' and '2001-02-28'),
  constraint p200102 primary key(id));

create table xxx_200103(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200103 check(td between '2001-03-01' and '2001-03-31'),
  constraint p200103 primary key(id));

create table xxx_200104(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200104 check(td between '2001-04-01' and '2001-04-30'),
  constraint p200104 primary key(id));

create table xxx_200105(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200105 check(td between '2001-05-01' and '2001-05-31'),
  constraint p200105 primary key(id));

create table xxx_200106(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200106 check(td between '2001-06-01' and '2001-06-30'),
  constraint p200106 primary key(id));

create table xxx_200107(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200107 check(td between '2001-07-01' and '2001-07-31'),
  constraint p200107 primary key(id));

create table xxx_200108(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200108 check(td between '2001-08-01' and '2001-08-31'),
  constraint p200108 primary key(id));

create table xxx_200109(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200109 check(td between '2001-09-01' and '2001-09-30'),
  constraint p200109 primary key(id));

create table xxx_200110(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200110 check(td between '2001-10-01' and '2001-10-31'),
  constraint p200110 primary key(id));

create table xxx_200111(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200111 check(td between '2001-11-01' and '2001-11-30'),
  constraint p200111 primary key(id));

create table xxx_200112(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200112 check(td between '2001-12-01' and '2001-12-31'),
  constraint p200112 primary key(id));

create table xxx_200201(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200201 check(td between '2002-01-01' and '2002-01-31'),
  constraint p200201 primary key(id));

create table xxx_200202(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200202 check(td between '2002-02-01' and '2002-02-28'),
  constraint p200202 primary key(id));

create table xxx_200203(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200203 check(td between '2002-03-01' and '2002-03-31'),
  constraint p200203 primary key(id));

create table xxx_200204(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200204 check(td between '2002-04-01' and '2002-04-30'),
  constraint p200204 primary key(id));

create table xxx_200205(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200205 check(td between '2002-05-01' and '2002-05-31'),
  constraint p200205 primary key(id));

create table xxx_200206(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200206 check(td between '2002-06-01' and '2002-06-30'),
  constraint p200206 primary key(id));

create table xxx_200207(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200207 check(td between '2002-07-01' and '2002-07-31'),
  constraint p200207 primary key(id));

create table xxx_200208(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200208 check(td between '2002-08-01' and '2002-08-31'),
  constraint p200208 primary key(id));

create table xxx_200209(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200209 check(td between '2002-09-01' and '2002-09-30'),
  constraint p200209 primary key(id));

create table xxx_200210(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200210 check(td between '2002-10-01' and '2002-10-31'),
  constraint p200210 primary key(id));

create table xxx_200211(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200211 check(td between '2002-11-01' and '2002-11-30'),
  constraint p200211 primary key(id));

create table xxx_200212(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200212 check(td between '2002-12-01' and '2002-12-31'),
  constraint p200212 primary key(id));

create table xxx_200301(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200301 check(td between '2003-01-01' and '2003-01-31'),
  constraint p200301 primary key(id));

create table xxx_200302(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200302 check(td between '2003-02-01' and '2003-02-28'),
  constraint p200302 primary key(id));

create table xxx_200303(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200303 check(td between '2003-03-01' and '2003-03-31'),
  constraint p200303 primary key(id));

create table xxx_200304(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200304 check(td between '2003-04-01' and '2003-04-30'),
  constraint p200304 primary key(id));

create table xxx_200305(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200305 check(td between '2003-05-01' and '2003-05-31'),
  constraint p200305 primary key(id));

create table xxx_200306(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200306 check(td between '2003-06-01' and '2003-06-30'),
  constraint p200306 primary key(id));

create table xxx_200307(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200307 check(td between '2003-07-01' and '2003-07-31'),
  constraint p200307 primary key(id));

create table xxx_200308(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200308 check(td between '2003-08-01' and '2003-08-31'),
  constraint p200308 primary key(id));

create table xxx_200309(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200309 check(td between '2003-09-01' and '2003-09-30'),
  constraint p200309 primary key(id));

create table xxx_200310(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200310 check(td between '2003-10-01' and '2003-10-31'),
  constraint p200310 primary key(id));

create table xxx_200311(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200311 check(td between '2003-11-01' and '2003-11-30'),
  constraint p200311 primary key(id));

create table xxx_200312(
  id integer not null generated by default as identity,
  td date not null,
  constraint c200312 check(td between '2003-12-01' and '2003-12-31'),
  constraint p200312 primary key(id));

create view xxx(td,id) as 
select td, id from xxx_200101
UNION ALL
select td, id from xxx_200102
UNION ALL
select td, id from xxx_200103
UNION ALL
select td, id from xxx_200104
UNION ALL
select td, id from xxx_200105
UNION ALL
select td, id from xxx_200106
UNION ALL
select td, id from xxx_200107
UNION ALL
select td, id from xxx_200108
UNION ALL
select td, id from xxx_200109
UNION ALL
select td, id from xxx_200110
UNION ALL
select td, id from xxx_200111
UNION ALL
select td, id from xxx_200112
UNION ALL
select td, id from xxx_200201
UNION ALL
select td, id from xxx_200202
UNION ALL
select td, id from xxx_200203
UNION ALL
select td, id from xxx_200204
UNION ALL
select td, id from xxx_200205
UNION ALL
select td, id from xxx_200206
UNION ALL
select td, id from xxx_200207
UNION ALL
select td, id from xxx_200208
UNION ALL
select td, id from xxx_200209
UNION ALL
select td, id from xxx_200210
UNION ALL
select td, id from xxx_200211
UNION ALL
select td, id from xxx_200212
UNION ALL
select td, id from xxx_200301
UNION ALL
select td, id from xxx_200302
UNION ALL
select td, id from xxx_200303
UNION ALL
select td, id from xxx_200304
UNION ALL
select td, id from xxx_200305
UNION ALL
select td, id from xxx_200306
UNION ALL
select td, id from xxx_200307
UNION ALL
select td, id from xxx_200308
UNION ALL
select td, id from xxx_200309
UNION ALL
select td, id from xxx_200310
UNION ALL
select td, id from xxx_200311
UNION ALL
select td, id from xxx_200312
;
insert into xxx(td) values(current date);

select * from xxx where td between '2001-03-07' and '2001-05-05'
;

SELECT Q7.$C0 AS  "TD" , Q7.$C1 AS  "ID"  
FROM (SELECT Q1. "TD" , Q1. "ID"  
            FROM VVM.XXX_200103 AS Q1 
          WHERE (Q1. "TD"  <= '2001-05-05') AND ('2001-03-07' <=  Q1. "TD" ) 
UNION ALL 
SELECT Q3. "TD" , Q3. "ID"  
FROM VVM.XXX_200104 AS Q3 
WHERE (Q3. "TD"  <= '2001-05-05') AND ('2001-03-07' <=  Q3. "TD" ) 
UNION ALL 
SELECT Q5. "TD" , Q5. "ID"  
FROM VVM.XXX_200105 AS Q5 
WHERE (Q5. "TD"  <= '2001-05-05') AND ('2001-03-07' <=  Q5. "TD" ) ) AS Q7