zOs/TX/QBSEQNX

select next     value for qTxCrX.sQbSeq1 next from sysibm.sysDummy1;
select previous value for qTxCrX.sQbSeq1 prev from sysibm.sysDummy1;
select next     value for qTxCrX.sQbSeq1 next from sysibm.sysDummy1;
select current timestamp from sysibm.sysDummy1;
declare global temporary table session.nx(nx int);
insert into session.nx
with l(l) as
(
  select 1 from sysibm.sysDummy1
  union all select l+1 from l where l < 100000
)
  select next value for qTxCrX.sQbSeq1
    from l
;
select count(*) c, min(nx), max(nx)
    from session.nx;
select current timestamp from sysibm.sysDummy1;
rollback;
;x;
select current timestamp from sysibm.sysDummy1;
with l(l) as
(
  select 1 from sysibm.sysDummy1
  union all select l+1 from l where l < 1000000
)
select min(l), max(l), count(*)
    from l
;
select current timestamp from sysibm.sysDummy1;