zOs/SQL/HOSTVARS
$#@
call sqlConnect dbaf
call sqlPrepare 1, 'select count(*) from sysibm.sysTables' ,
' where name like ? and createdTS > ?'
c = sqlOpAllCl(1, st, ':cc', 'TWK60%', '1956-04-01-06.07.08.901234')
say 'sqlOpAllCl='c ' twk60%' cc
c = sqlOpAllCl(1, st, ':cc', 'TWK2%', '1967-05-31-06.07.08.901234')
say 'sqlOpAllCl='c ' twk2%' cc
c = sqlOpAllCl(1, st, ':cc', 'SYST%', '1978-06-30-12.34.56.789012')
say 'sqlOpAllCl='c 'sysT%' cc
call sqlPrepare 2, 'select count(*) from A540769.twk600a001' ,
' where i1 = ? and v2 > ? and upd > ?'
c = sqlOpAllCl(2, st, ':cc', 411, 'abc', '1956-04-01-06.07.08.901234')
say 'sqlOpAllCl='c '411 abc 1956-04-01' cc
$#out 20111021 10:06:36
$#out 20111021 10:06:32
$#out 20111021 10:05:59
$#out 20111021 10:00:19
$#out 20111021 09:58:17
$#out 20111021 09:58:04
$#out 20111021 09:37:18
$#out 20111021 09:37:14
$#out 20111021 09:36:53
$#out 20111020 16:40:12
$#out 20111020 16:40:03
$#out 20111020 16:34:00
$#out 20111020 16:33:55
$#out 20111020 16:31:28
$#out 20111020 16:31:24
$#out 20111020 16:31:03
$#out 20111020 16:30:56
$#out 20111020 16:30:49
$#out 20111020 16:30:42
$#out 20111020 16:30:36
$#out 20111020 16:30:14
$#out 20111020 16:29:06
$#out 20111020 16:27:12