zOs/TX/PER05WSH

call sqlConnect dbaf
dv = '30.05.2011'
dt = '02.06.2011'
all =  'tPer05x0 tPer05x1 vPer05Union vPer05UnionWhere vPer05UnionJoin'
do vx=1 to words(all)
    vw = word(all, vx)
    $$- 'selecting' vw '.................'
    s = 'select count(*), min(ix), max(ix)',
            'from A540769.'vw 'where da between ? and ?'
    call sqlPrepare 1, s
    call sqlOpAllCl 1, st, ':cnt,:min :ii,:max :ia', dv, dt
    $$- m.st.0 'cnt' cnt':' min '-' max
    end
call sqlDisconnect
$#out                                              20100825 12:38:52
selecting tPer05x0 .................
1 cnt 0: 0 - 0
selecting tPer05x1 .................
1 cnt 800: 530000000 - 602000199
selecting vPer05Union .................
1 cnt 800: 530000000 - 602000199
selecting vPer05UnionWhere .................
1 cnt 800: 530000000 - 602000199
selecting vPer05UnionJoin .................
1 cnt 800: 530000000 - 602000199
$#out                                              20100825 12:35:47