zOs/SQL/CATDBALT
with d as
(
select name db
from sysibm.sysDatabase
where name like 'DG%' or name like '%A1X%'
)
, v0 (ty, db, cr, vw, at, lv) as
(
select type, dbname, creator, name, alteredTs, 0
from sysibm.sysTables
where dbName in (select db from d) and type = 'T'
union all select dtype, db, dCreator, dName, t.alteredTs, lv+1
from v0, sysibm.sysViewDep q, sysibm.sysTables t
where lv < 99 and q.bcreator = v0.cr and q.bName = v0.vw
and t.creator = dCreator and t.name = dName
)
, v as
( select db, cr, vw, max(ty) ty, max(at) at
from v0
group by db, cr, vw
union all select dbName db , creator cr, name vw, 'ix' ty,
alteredTs at
from sysibm.sysIndexes
where dbName in (select db from d)
)
select db, count(*), max(at)
from v
group by db
order by db
$#out 20120419 16:24:54
DB OL2 COL3
AV01A1X 325 2009-03-06-09.56.13.347096
AV02A1X 29 2009-11-05-15.04.31.233447
AV03A1X 162 2012-02-15-15.56.00.992980
AV04A1X 70 2012-02-15-15.56.20.101081
AV05A1X 30 2011-09-09-16.04.25.659715
AV06A1X 126 2012-02-15-15.56.44.900875
AV07A1X 126 2012-02-15-15.56.56.623324
AV08A1X 126 2012-02-15-15.57.08.237247
AV09A1X 126 2012-02-15-15.57.19.005186
AV10A1X 126 2012-02-15-15.57.29.100327
AV11A1X 126 2012-02-15-15.57.45.244556
AV12A1X 126 2012-02-15-15.57.59.382430
AV13A1X 126 2012-02-15-15.58.18.653586
AV14A1X 126 2012-02-15-15.58.34.142134
AV15A1X 176 2012-03-15-14.59.55.329691
AV16A1X 126 2012-02-15-15.58.50.859737
AV17A1X 126 2012-02-15-15.59.09.054278
AV18A1X 126 2012-02-15-15.59.22.097118
DG01A1A 201 2012-04-02-08.38.16.929850
DG02A1A 122 2012-01-30-12.54.53.534434
DG666308 2 2009-02-18-12.35.14.395438
DGDB0008 153 2008-03-14-13.04.33.490511
DGDB0009 9 2004-10-26-15.13.54.114580
DGDB0015 201 2012-03-29-12.45.42.624562
DGDB0031 60 2007-07-25-07.17.23.210039
DGDB0033 6 2004-10-26-15.13.58.488538
DGDB0035 21 2007-06-22-13.26.09.175553
DGDB0039 36 2006-05-19-14.17.02.071896
DGDB0041 46 2004-10-26-15.14.09.759890
DGDB0042 3 2004-10-26-15.14.09.826515
DGDB0044 4 2004-10-26-15.14.09.914919
DGDB0047 5 2004-10-26-15.14.12.791258
DGDB0049 13 2010-07-29-15.27.33.622954
DGDB0052 378 2006-09-08-10.13.08.350741
DGDB0056 6 2004-10-26-15.14.49.340828
DGDB0057 152 2010-06-25-10.55.07.240600
DGDB0058 77 2009-02-16-16.24.51.053775
DGDB0059 34 2008-12-23-12.47.57.841673
DGDB0060 121 2009-04-21-07.25.35.986757
DGDB0061 8 2004-10-26-15.15.04.437668
DGDB0062 49 2010-04-22-13.19.16.615883
DGDB0065 39 2004-10-26-15.15.20.634315
DGDB0067 75 2011-09-27-15.04.49.189528
DGDB0072 90 2008-01-17-18.27.15.263195
DGDB0074 228 2004-10-26-15.15.43.907806
DGDB0078 74 2008-04-22-11.08.37.492940
DGDB0080 27 2004-10-26-15.15.53.616592
DGDB0082 145 2004-10-26-15.16.16.107311
DGDB0084 571 2008-10-30-17.23.26.248352
DGDB0085 6 2004-10-26-15.16.45.326968
DGDB0086 3 2004-10-26-15.16.45.450493
DGDB0088 26 2011-01-12-14.58.17.403487
DGDB0089 4 2004-10-26-15.16.46.747597
DGDB0090 24 2007-07-10-13.33.01.985987
DGDB0091 57 2009-07-31-16.24.24.282235
DGDB0093 18 2004-10-26-15.17.05.688324
DGDB0094 51 2004-10-26-15.17.07.479274
DGDB0095 18 2004-10-26-15.17.07.906538
DGDB0098 3 2004-10-26-15.17.08.024597
DGDB0103 52 2005-08-23-15.04.51.695020
DGDB0104 89 2011-03-07-11.24.47.409982
DGDB0105 146 2006-05-09-15.29.38.403093
DGDB0106 112 2012-02-06-15.47.39.861403
DGDB0110 25 2011-02-02-13.45.07.510254
DGDB0112 688 2012-02-16-11.41.10.222958
DGDB0113 258 2012-01-12-17.24.32.566470
DGDB0120 338 2011-09-22-08.37.30.692568
DGDB0121 21 2012-03-06-15.01.59.414022
DGDB0125 37 2009-11-18-13.37.33.681197
DGDB0129 12 2004-10-26-15.43.54.433882
DGDB0130 24 2004-11-03-11.12.47.882202
DGDB0131 49 2011-11-01-08.45.13.650123
DGDB0132 9 2006-10-03-18.07.12.156178
DGDB0133 371 2012-04-10-15.19.08.010289
DGDB0135 78 2010-12-15-10.44.14.150780
DGDB0136 192 2011-09-23-12.40.35.137113
DGDB0137 191 2012-04-12-10.51.12.318909
DGDB0139 92 2006-09-08-10.15.11.761270
DGDB0140 120 2010-04-08-11.28.21.175572
DGDB0141 21 2006-09-05-18.21.37.237084
DGDB0142 75 2009-03-06-11.40.05.708110
DGDB0143 49 2004-10-26-15.46.50.593341
DGDB0144 4 2004-10-26-15.46.50.627553
DGDB0145 25 2006-05-09-15.29.38.740267
DGDB0151 40 2010-08-17-10.26.47.966178
DGDB0153 44 2012-04-17-11.42.11.416017
DGDB0154 113 2007-04-26-14.52.26.375676
DGDB0155 96 2011-11-07-10.00.24.371112
DGDB0156 146 2012-02-13-18.17.12.526169
DGDB0159 2 2004-10-26-15.47.54.862251
DGDB0162 37 2010-03-01-13.34.58.807827
DGDB0166 45 2009-06-24-10.11.34.524267
DGDB0167 165 2004-10-26-15.48.12.096602
DGDB0168 65 2011-03-02-13.22.04.943211
DGDB0169 43 2010-06-17-08.44.11.264635
DGDB0171 56 2012-03-26-09.49.28.897080
DGDB0173 350 2010-02-24-13.44.34.529229
DGDB0174 8 2011-11-16-12.03.38.194573
DGDB0175 47 2004-10-26-15.49.17.533858
DGDB0177 38 2004-10-26-15.50.02.498005
DGDB0178 186 2011-08-15-13.52.20.151219
DGDB0179 173 2010-05-28-11.32.55.602101
DGDB0180 15 2004-10-26-15.50.50.978297
DGDB0181 23 2007-02-27-11.06.10.205960
DGDB0182 12 2004-10-26-15.50.51.737228
DGDB0183 367 2012-03-06-14.14.38.800727
DGDB0185 10 2004-10-26-15.50.57.210769
DGDB0186 26 2007-10-01-07.39.03.571013
DGDB0187 172 2008-05-06-22.33.40.942777
DGDB0189 140 2012-04-19-15.10.21.608464
DGDB0192 126 2012-01-30-12.36.00.752766
DGDB0193 141 2008-01-15-16.26.26.452125
DGDB0194 17 2008-12-19-14.13.25.529939
DGDB0195 11 2004-10-26-15.52.05.192138
DGDB0196 76 2012-02-21-16.04.41.114114
DGDB0200 310 2004-10-27-10.25.57.753074
DGDB0201 22 2007-04-13-17.31.09.157936
DGDB0202 241 2012-02-13-18.19.03.741293
DGDB0203 40 2012-02-28-09.52.36.737259
DGDB0205 10 2004-10-27-10.26.32.469902
DGDB0206 22 2004-10-27-10.26.34.590578
DGDB0207 237 2011-04-28-15.56.57.412443
DGDB0209 12 2004-10-27-10.26.39.896668
DGDB0211 105 2011-02-03-16.43.44.123978
DGDB0212 27 2006-09-08-10.35.00.000617
DGDB0213 251 2012-04-11-13.28.46.995190
DGDB0214 5 2004-10-27-10.26.51.819135
DGDB0215 9 2004-10-27-10.26.52.282957
DGDB0217 199 2012-01-11-15.16.53.415090
DGDB0218 65 2009-10-01-15.48.29.999826
DGDB0220 6 2006-11-08-13.03.57.222846
DGDB0222 159 2004-10-27-10.27.15.092403
DGDB0223 107 2011-12-13-12.48.31.089270
DGDB0224 27 2009-06-17-13.09.50.284614
DGDB0226 60 2006-06-08-15.44.50.793406
DGDB0227 15 2008-10-21-10.34.03.396936
DGDB0228 187 2011-12-15-13.29.03.118489
DGDB0231 41 2006-12-13-10.05.01.238523
DGDB0232 17 2009-04-02-14.54.06.617324
DGDB0235 279 2011-08-23-12.15.47.899057
DGDB0236 17 2006-08-17-10.44.37.822719
DGDB0237 330 2012-03-26-15.15.02.794184
DGDB0238 33 2006-09-08-10.40.16.350739
DGDB0239 47 2011-11-29-13.05.21.939649
DGDB0241 78 2012-03-01-07.57.16.326406
DGDB0242 53 2004-10-27-10.29.15.688356
DGDB0243 4 2001-07-04-15.24.14.921785
DGDB0244 102 2011-03-17-13.11.56.616841
DGDB0247 83 2010-09-01-11.15.27.735671
DGDB0248 4 2004-10-27-10.29.23.052453
DGDB0254 149 2006-07-12-16.35.49.369482
DGDB0255 6 2009-06-11-08.44.03.203655
DGDB0256 19 2011-09-06-15.28.09.229664
DGDB0257 59 2011-09-06-15.29.42.960811
DGDB0258 20 2009-09-29-15.19.57.611661
DGDB0260 17 2009-06-25-08.22.17.297017
DGDB0261 5 2009-06-25-08.23.28.423606
DGDB0262 5 2009-06-25-08.25.18.112304
DGDB0263 35 2004-10-27-10.29.41.195829
DGDB0264 9 2004-10-27-10.29.41.877308
DGDB0265 76 2012-03-16-09.46.15.968614
DGDB0266 20 2007-11-26-08.14.38.947415
DGDB0268 51 2007-05-31-10.41.51.640387
DGDB0269 16 2004-10-27-10.29.57.644724
DGDB0272 45 2004-10-27-10.30.13.604279
DGDB0273 37 2011-11-28-10.57.30.181899
DGDB0274 6 2006-09-08-10.40.29.777600
DGDB0275 221 2012-04-13-08.50.28.813048
DGDB0276 30 2011-02-15-07.53.02.085361
DGDB0277 2 2004-10-27-10.30.16.265751
DGDB0278 32 2004-10-27-10.30.17.040738
DGDB0279 25 2005-08-22-10.08.55.624049
DGDB0281 171 2008-07-21-14.31.34.649556
DGDB0282 27 2012-04-14-11.40.20.325701
DGDB0283 71 2010-02-10-14.19.39.422838
DGDB0284 7 2009-06-25-07.31.45.485555
DGDB0285 31 2009-11-18-13.24.14.262770
DGDB0286 44 2012-01-06-06.41.49.700114
DGDB0287 30 2011-01-26-14.51.07.826564
DGDB0288 33 2007-12-21-13.07.55.406211
DGDB0289 11 2007-05-24-15.42.08.563298
DGDB0290 287 2012-01-05-09.39.36.559408
DGDB0291 8 2012-02-14-10.45.10.650668
DGDB0292 44 2011-08-25-15.45.12.998437
DGDB0295 43 2004-10-27-11.06.06.170413
DGDB0296 51 2009-12-02-14.26.17.948619
DGDB0297 4 2004-10-27-11.06.07.558401
DGDB0300 34 2006-04-27-14.26.20.464157
DGDB0308 26 2004-10-27-10.37.34.302559
DGDB0309 5 2004-10-27-10.37.34.405394
DGDB0310 29 2004-10-27-10.37.34.983835
DGDB0311 46 2004-10-27-10.37.35.686834
DGDB0312 44 2004-10-27-10.37.36.700587
DGDB0313 4 2004-10-27-10.37.36.761966
DGDB0315 87 2007-11-21-07.34.14.982034
DGDB0316 42 2004-11-25-15.18.17.018574
DGDB0317 36 2010-03-05-15.50.28.944976
DGDB0319 57 2004-10-27-10.37.46.607315
DGDB0320 42 2004-10-27-10.37.47.417532
DGDB0321 48 2004-10-27-10.37.48.446302
DGDB0322 111 2004-10-27-10.37.49.957114
DGDB0323 48 2007-08-29-15.03.45.341618
DGDB0324 39 2011-06-09-11.12.50.962332
DGDB0325 9 2004-10-27-10.37.51.070278
DGDB0326 46 2007-06-08-12.42.42.737442
DGDB0327 12 2011-01-31-13.38.16.901852
DGDB0328 6 2004-10-27-10.37.51.987275
DGDB0329 36 2011-12-29-15.47.21.565017
DGDB0330 260 2004-10-27-10.38.06.389515
DGDB0331 20 2004-12-29-11.24.35.814504
DGDB0332 145 2004-10-27-10.38.18.950946
DGDB0334 26 2004-10-27-10.38.20.840649
DGDB0336 41 2011-01-31-13.22.20.144663
DGDB0337 23 2010-03-05-15.53.42.060703
DGDB0338 20 2006-11-03-09.17.17.281054
DGDB0339 163 2010-05-11-12.02.39.073483
DGDB0340 48 2006-08-22-15.43.55.718488
DGDB0341 23 2007-10-09-13.06.32.319986
DGDB0342 166 2005-10-18-16.50.49.693781
DGDB0343 51 2004-10-27-10.38.52.739428
DGDB0344 47 2004-10-27-10.38.54.194384
DGDB0346 13 2005-07-12-11.28.55.165917
DGDB0348 27 2004-10-27-10.39.16.348035
DGDB0349 32 2009-04-03-13.41.43.533715
DGDB0351 188 2012-02-23-13.02.25.753177
DGDB0352 9 2005-03-01-09.24.30.322573
DGDB0354 130 2012-04-10-12.24.27.906766
DGDB0358 49 2010-10-18-16.37.47.140905
DGDB0359 176 2012-02-16-15.28.38.250825
DGDB0360 23 2012-02-16-15.39.32.680807
DGDB0361 4 2004-10-27-10.45.55.286884
DGDB0362 183 2007-11-08-10.54.38.483692
DGDB0363 24 2005-03-04-12.58.24.634911
DGDB0364 105 2004-10-27-10.46.06.076344
DGDB0365 62 2010-03-30-10.33.31.788061
DGDB0366 140 2006-08-11-16.05.44.163608
DGDB0368 10 2012-02-24-15.12.26.189389
DGDB0369 59 2004-12-07-14.12.33.241170
DGDB0370 2 2007-01-30-15.24.18.000563
DGDB0371 36 2006-08-03-14.24.35.904079
DGDB0372 15 2005-06-01-17.07.03.460778
DGDB0373 51 2006-05-09-15.29.40.469475
DGDB0374 196 2011-08-31-17.10.49.928103
DGDB0375 2 2004-10-27-10.48.08.689781
DGDB0376 181 2010-09-29-14.05.30.417429
DGDB0378 12 2005-11-10-11.55.59.849415
DGDB0380 24 2010-02-10-11.37.58.389299
DGDB0381 32 2011-09-13-18.12.47.849518
DGDB0383 21 2007-04-03-18.43.48.575619
DGDB0384 110 2011-09-20-12.27.03.548968
DGDB0385 21 2006-05-09-16.03.41.066883
DGDB0386 37 2006-05-18-14.03.34.184573
DGDB0387 8 2006-01-12-12.57.56.183975
DGDB0388 78 2011-04-20-17.29.21.080223
DGDB0389 176 2011-09-20-15.39.51.976393
DGDB0390 29 2005-10-05-08.57.04.766439
DGDB0391 27 2005-08-25-11.23.21.295470
DGDB0392 36 2010-11-30-09.41.05.588493
DGDB0394 12 2005-05-24-17.53.44.644243
DGDB0395 297 2011-06-09-16.32.36.818613
DGDB0396 57 2011-07-05-14.42.35.712514
DGDB0399 22 2012-04-13-14.30.31.758354
DGDB0400 24 2008-09-05-12.41.37.447612
DGDB0401 84 2011-08-18-14.17.50.966395
DGDB0402 62 2011-04-05-07.22.13.038016
DGDB0403 12 2007-08-02-15.01.49.279712
DGDB0404 51 2005-09-19-11.51.05.491506
DGDB0405 14 2011-11-28-16.16.09.744385
DGDB0406 48 2005-06-08-13.53.30.572456
DGDB0412 220 2011-11-07-13.49.18.749770
DGDB0416 11 2005-10-10-13.35.03.891626
DGDB0417 9 2005-08-10-15.21.24.767924
DGDB0418 26 2008-01-07-13.16.34.910529
DGDB0419 4 2011-03-25-12.47.40.552238
DGDB0420 65 2011-10-11-14.19.07.782165
DGDB0421 11 2009-07-03-13.33.38.613923
DGDB0423 8 2008-01-10-14.50.37.984697
DGDB0424 216 2012-04-13-13.40.37.250468
DGDB0426 314 2007-11-19-11.35.16.571883
DGDB0431 206 2011-11-11-11.06.18.557060
DGDB0432 206 2011-11-11-11.06.18.953307
DGDB0433 175 2011-11-11-11.06.19.338967
DGDB0434 175 2011-11-11-11.06.19.811567
DGDB0435 175 2011-11-11-11.06.20.149377
DGDB0436 175 2011-11-11-11.06.20.614490
DGDB0439 125 2011-12-23-10.46.26.050337
DGDB0441 61 2007-04-10-17.01.59.786020
DGDB0442 68 2007-12-05-11.22.07.796985
DGDB0443 23 2006-06-21-12.01.49.732236
DGDB0444 12 2008-06-26-13.56.23.725837
DGDB0446 47 2010-11-25-11.01.16.065087
DGDB0448 3 2006-11-07-13.48.38.391975
DGDB0449 10 2007-02-22-18.21.36.616246
DGDB0450 36 2011-01-06-00.05.31.564479
DGDB0451 45 2006-10-02-13.22.51.890066
DGDB0452 54 2007-07-06-15.35.21.362996
DGDB0454 15 2007-02-27-15.07.23.973506
DGDB0455 14 2007-03-06-12.10.47.308374
DGDB0456 11 2007-03-06-12.12.25.339149
DGDB0457 12 2007-02-06-13.05.57.831276
DGDB0460 175 2011-11-11-11.06.20.951273
DGDB0463 19 2011-05-26-08.14.11.538447
DGDB0466 106 2010-06-17-12.03.20.687745
DGDB0467 99 2011-07-14-08.53.42.802215
DGDB0468 63 2012-01-09-10.38.16.942277
DGDB0470 6 2008-01-14-13.19.17.936519
DGDB0471 1 2007-04-05-08.09.21.530616
DGDB0472 91 2011-12-15-10.33.00.293887
DGDB0473 57 2011-04-04-17.19.32.307455
DGDB0474 36 2012-02-27-13.52.12.774518
DGDB0475 23 2007-06-26-13.46.14.204488
DGDB0476 16 2012-03-29-12.07.04.466512
DGDB0478 277 2010-05-15-09.25.09.288955
DGDB0479 277 2011-11-04-10.16.27.336216
DGDB0480 43 2010-09-17-18.08.08.876526
DGDB0481 9 2007-09-26-15.51.50.914007
DGDB0482 169 2012-03-07-11.27.46.542459
DGDB0483 3 2008-09-01-09.33.39.312408
DGDB0484 36 2008-09-08-10.01.03.725452
DGDB0485 65 2012-02-08-13.58.37.250580
DGDB0486 213 2012-04-03-11.06.33.703349
DGDB0494 24 2009-06-16-14.33.13.522117
DGDB0495 175 2011-11-11-11.06.21.269834
DGDB0496 175 2011-11-11-11.06.21.620887
DGDB0497 175 2011-11-11-11.06.21.993914
DGDB0498 175 2011-11-11-11.06.22.390687
DGDB0499 38 2010-09-24-15.16.39.934793
DGDB0500 152 2011-01-14-15.36.57.314514
DGDB0501 4 2009-02-04-13.13.45.476435
DGDB0502 6 2009-05-04-12.22.26.732774
DGDB0503 46 2010-11-26-14.51.58.901951
DGDB0504 352 2008-09-29-18.11.51.855204
DGDB0505 52 2011-02-21-18.04.00.438971
DGDB0506 192 2011-12-02-11.42.24.425738
DGDB0509 22 2008-10-06-14.23.27.354520
DGDB0510 18 2008-10-17-15.45.38.642431
DGDB0511 3 2008-11-11-19.19.50.921896
DGDB0513 9 2008-10-16-10.34.43.834006
DGDB0514 44 2011-07-01-09.53.45.583816
DGDB0515 59 2009-06-02-09.39.32.305035
DGDB0516 36 2011-10-27-11.02.46.180128
DGDB0517 5 2008-12-17-14.51.44.330750
DGDB0518 10 2011-08-03-09.49.50.966829
DGDB0519 90 2011-09-22-13.28.20.262347
DGDB0520 175 2011-11-11-11.06.22.757670
DGDB0521 175 2011-11-11-11.06.23.329570
DGDB0522 26 2010-02-26-13.33.41.444428
DGDB0523 7 2010-02-25-09.51.34.640754
DGDB0524 102 2010-11-16-12.44.38.747763
DGDB0525 12 2010-02-02-11.30.57.909044
DGDB0526 2 2010-03-09-09.01.29.460049
DGDB0527 5 2010-09-03-12.45.17.717523
DGDB0528 109 2012-04-13-15.22.09.442700
DGDB0530 4 2010-07-02-15.47.56.155215
DGDB0531 3 2010-09-23-13.08.55.621643
DGDB0532 41 2012-03-21-14.27.34.410053
DGDB0535 6 2012-03-05-18.56.40.857804
DGDB0537 9 2011-12-23-11.50.25.850467
DGDB0544 75 2012-04-04-08.14.10.385242
DGDB0545 11 2012-02-10-11.16.01.047999
DGDB0546 35 2012-02-07-07.56.45.853935
DGDB0547 4 2012-03-28-15.36.32.255944
DGDB0549 25 2012-04-19-11.10.51.095930
DGDB0550 222 2012-04-11-10.19.41.648048
DGDB0637 23 2008-05-14-13.57.46.949266
DGDB0638 32 2011-08-23-16.05.12.759488
DGDB0639 52 2012-01-12-17.46.02.351192
DGDB0668 38 2006-07-07-13.57.03.529288
DGDB0669 34 2007-02-16-10.51.37.229471
DGDB0670 4 2007-02-16-10.51.30.970612
DGDB0671 119 2012-03-14-01.44.21.325314
DGDB0672 8 2009-09-30-17.20.42.593724
DGDB0673 417 2011-11-21-07.49.01.349758
DGDB0674 16 2012-01-23-16.19.46.217184
DGDB0675 24 2011-12-23-13.41.31.721097
DGDB0676 24 2011-12-23-13.42.18.336935
DGDB0677 24 2011-12-23-13.45.13.116665
DGDB0678 24 2011-12-23-13.38.40.186996
DGDB0679 20 2012-04-13-11.35.52.553230
DGDB0680 9 2012-02-03-13.34.57.714327
DGDB0681 64 2012-02-07-13.58.45.450658
DGDB0999 3 2006-08-02-17.04.48.795859
DGDB6663 84 2008-12-16-11.00.34.036780
DGDB9991 3 2010-03-10-17.51.18.864416
DGDB9992 3 2010-03-10-17.51.20.104435
DGDB9993 3 2010-03-10-17.51.21.415808
DGDB9996 15 2012-03-14-16.20.29.519115
DGDB9997 24 2009-10-21-16.03.17.745454
DGDB9998 331 2012-04-17-11.18.48.221102
DGDB9999 25 2005-06-02-12.56.05.901310
DGOCB130 195 2008-01-11-13.10.57.152269
DGOCF101 217 2003-10-02-11.52.21.535732
DGOCF102 96 2002-05-27-10.09.04.384760
DGOCK310 61 2003-08-18-19.35.03.473574
DGOKB701 34 2006-03-07-13.10.56.348447
DGOMA24N 2 2004-10-29-11.15.54.055296
DGOMM700 125 2003-08-18-19.35.05.963203
DGOWA200 54 2010-08-18-16.12.20.421306
DGOWB420 25 2011-05-31-15.58.01.748775
DGOWD501 36 2011-09-14-09.35.44.132928
DGOWD502 32 2011-09-13-18.01.39.070889
DGOWD503 10 2010-04-29-10.25.04.876989
DGOWD504 16 2010-04-29-12.19.53.240238
DGOWD600 97 2012-03-27-09.24.03.252276
DGOWD700 35 2004-10-28-10.26.00.904484
DGOWM200 4 2004-10-28-10.26.01.000641
DGOWM301 369 2010-10-25-13.40.35.625293
DSN8DA1X 27 2012-04-03-13.11.17.644146
DXB03A1X 629 2012-04-03-08.55.56.154808
DXB04A1X 50 2009-12-15-18.24.16.145724
DXB05A1X 116 2009-03-04-09.01.13.643837
DXB07A1X 129 2011-03-28-14.58.08.134166
ED06A1X 7 2009-08-28-15.38.57.030399
EL01A1X 89 2011-08-18-09.39.17.820486
EU02A1X 5 2010-07-02-11.08.17.078666
KT01A1X 5 2010-07-02-11.12.19.036057
RG01A1X 6 2009-06-18-14.43.25.871094
SV30A1X 45 2010-11-04-11.13.35.516893
SV31A1X 31 2011-05-18-10.36.35.986528
TG01A1X 61 2012-04-02-14.59.27.053202
VV21A1X 412 2012-04-10-11.37.08.065762
VV22A1X 196 2012-02-06-11.55.49.598181
VV23A1X 414 2012-04-10-11.37.08.065762
VV24A1X 385 2012-04-10-11.37.08.065762
VV25A1X 158 2012-04-10-12.44.58.385957
VV26A1X 190 2011-12-04-11.53.07.423236
VV27A1X 197 2012-04-10-12.40.42.540084
VV28A1X 193 2012-04-10-12.40.42.818874
VV29A1X 105 2012-04-04-14.12.34.285387
WG01A1X 132 2010-12-07-11.45.46.327279
430 rows fetched: with d as ( select name db from sysibm.sysDatabase where...
$#out 20120419 16:24:36
*** run error ***
unclosed ' string: where name like 'DG%' or name like '%A1X%
$#out 20120419 15:41:12
DB OL2 COL3
DGDB0008 153 2008-03-14-13.04.33.490511
DGDB0009 9 2004-10-26-15.13.54.114580
DGDB0015 201 2012-03-29-12.45.42.624562
DGDB0031 60 2007-07-25-07.17.23.210039
DGDB0033 6 2004-10-26-15.13.58.488538
DGDB0035 21 2007-06-22-13.26.09.175553
DGDB0039 36 2006-05-19-14.17.02.071896
DGDB0041 46 2004-10-26-15.14.09.759890
DGDB0042 3 2004-10-26-15.14.09.826515
DGDB0044 4 2004-10-26-15.14.09.914919
DGDB0047 5 2004-10-26-15.14.12.791258
DGDB0049 13 2010-07-29-15.27.33.622954
DGDB0052 378 2006-09-08-10.13.08.350741
DGDB0056 6 2004-10-26-15.14.49.340828
DGDB0057 152 2010-06-25-10.55.07.240600
DGDB0058 77 2009-02-16-16.24.51.053775
DGDB0059 34 2008-12-23-12.47.57.841673
DGDB0060 121 2009-04-21-07.25.35.986757
DGDB0061 8 2004-10-26-15.15.04.437668
DGDB0062 49 2010-04-22-13.19.16.615883
DGDB0065 39 2004-10-26-15.15.20.634315
DGDB0067 75 2011-09-27-15.04.49.189528
DGDB0072 90 2008-01-17-18.27.15.263195
DGDB0074 228 2004-10-26-15.15.43.907806
DGDB0078 74 2008-04-22-11.08.37.492940
DGDB0080 27 2004-10-26-15.15.53.616592
DGDB0082 145 2004-10-26-15.16.16.107311
DGDB0084 571 2008-10-30-17.23.26.248352
DGDB0085 6 2004-10-26-15.16.45.326968
DGDB0086 3 2004-10-26-15.16.45.450493
DGDB0088 26 2011-01-12-14.58.17.403487
DGDB0089 4 2004-10-26-15.16.46.747597
DGDB0090 24 2007-07-10-13.33.01.985987
DGDB0091 57 2009-07-31-16.24.24.282235
DGDB0093 18 2004-10-26-15.17.05.688324
DGDB0094 51 2004-10-26-15.17.07.479274
DGDB0095 18 2004-10-26-15.17.07.906538
DGDB0098 3 2004-10-26-15.17.08.024597
DGDB0103 52 2005-08-23-15.04.51.695020
DGDB0104 89 2011-03-07-11.24.47.409982
DGDB0105 146 2006-05-09-15.29.38.403093
DGDB0106 112 2012-02-06-15.47.39.861403
DGDB0110 25 2011-02-02-13.45.07.510254
DGDB0112 688 2012-02-16-11.41.10.222958
DGDB0113 258 2012-01-12-17.24.32.566470
DGDB0120 338 2011-09-22-08.37.30.692568
DGDB0121 21 2012-03-06-15.01.59.414022
DGDB0125 37 2009-11-18-13.37.33.681197
DGDB0129 12 2004-10-26-15.43.54.433882
DGDB0130 24 2004-11-03-11.12.47.882202
DGDB0131 49 2011-11-01-08.45.13.650123
DGDB0132 9 2006-10-03-18.07.12.156178
DGDB0133 371 2012-04-10-15.19.08.010289
DGDB0135 78 2010-12-15-10.44.14.150780
DGDB0136 192 2011-09-23-12.40.35.137113
DGDB0137 191 2012-04-12-10.51.12.318909
DGDB0139 92 2006-09-08-10.15.11.761270
DGDB0140 120 2010-04-08-11.28.21.175572
DGDB0141 21 2006-09-05-18.21.37.237084
DGDB0142 75 2009-03-06-11.40.05.708110
DGDB0143 49 2004-10-26-15.46.50.593341
DGDB0144 4 2004-10-26-15.46.50.627553
DGDB0145 25 2006-05-09-15.29.38.740267
DGDB0151 40 2010-08-17-10.26.47.966178
DGDB0153 44 2012-04-17-11.42.11.416017
DGDB0154 113 2007-04-26-14.52.26.375676
DGDB0155 96 2011-11-07-10.00.24.371112
DGDB0156 146 2012-02-13-18.17.12.526169
DGDB0159 2 2004-10-26-15.47.54.862251
DGDB0162 37 2010-03-01-13.34.58.807827
DGDB0166 45 2009-06-24-10.11.34.524267
DGDB0167 165 2004-10-26-15.48.12.096602
DGDB0168 65 2011-03-02-13.22.04.943211
DGDB0169 43 2010-06-17-08.44.11.264635
DGDB0171 56 2012-03-26-09.49.28.897080
DGDB0173 350 2010-02-24-13.44.34.529229
DGDB0174 8 2011-11-16-12.03.38.194573
DGDB0175 47 2004-10-26-15.49.17.533858
DGDB0177 38 2004-10-26-15.50.02.498005
DGDB0178 186 2011-08-15-13.52.20.151219
DGDB0179 173 2010-05-28-11.32.55.602101
DGDB0180 15 2004-10-26-15.50.50.978297
DGDB0181 23 2007-02-27-11.06.10.205960
DGDB0182 12 2004-10-26-15.50.51.737228
DGDB0183 367 2012-03-06-14.14.38.800727
DGDB0185 10 2004-10-26-15.50.57.210769
DGDB0186 26 2007-10-01-07.39.03.571013
DGDB0187 172 2008-05-06-22.33.40.942777
DGDB0189 140 2012-04-19-15.10.21.608464
DGDB0192 126 2012-01-30-12.36.00.752766
DGDB0193 141 2008-01-15-16.26.26.452125
DGDB0194 17 2008-12-19-14.13.25.529939
DGDB0195 11 2004-10-26-15.52.05.192138
DGDB0196 76 2012-02-21-16.04.41.114114
DGDB0200 310 2004-10-27-10.25.57.753074
DGDB0201 22 2007-04-13-17.31.09.157936
DGDB0202 241 2012-02-13-18.19.03.741293
DGDB0203 40 2012-02-28-09.52.36.737259
DGDB0205 10 2004-10-27-10.26.32.469902
DGDB0206 22 2004-10-27-10.26.34.590578
DGDB0207 237 2011-04-28-15.56.57.412443
DGDB0209 12 2004-10-27-10.26.39.896668
DGDB0211 105 2011-02-03-16.43.44.123978
DGDB0212 27 2006-09-08-10.35.00.000617
DGDB0213 251 2012-04-11-13.28.46.995190
DGDB0214 5 2004-10-27-10.26.51.819135
DGDB0215 9 2004-10-27-10.26.52.282957
DGDB0217 199 2012-01-11-15.16.53.415090
DGDB0218 65 2009-10-01-15.48.29.999826
DGDB0220 6 2006-11-08-13.03.57.222846
DGDB0222 159 2004-10-27-10.27.15.092403
DGDB0223 107 2011-12-13-12.48.31.089270
DGDB0224 27 2009-06-17-13.09.50.284614
DGDB0226 60 2006-06-08-15.44.50.793406
DGDB0227 15 2008-10-21-10.34.03.396936
DGDB0228 187 2011-12-15-13.29.03.118489
DGDB0231 41 2006-12-13-10.05.01.238523
DGDB0232 17 2009-04-02-14.54.06.617324
DGDB0235 279 2011-08-23-12.15.47.899057
DGDB0236 17 2006-08-17-10.44.37.822719
DGDB0237 330 2012-03-26-15.15.02.794184
DGDB0238 33 2006-09-08-10.40.16.350739
DGDB0239 47 2011-11-29-13.05.21.939649
DGDB0241 78 2012-03-01-07.57.16.326406
DGDB0242 53 2004-10-27-10.29.15.688356
DGDB0243 4 2001-07-04-15.24.14.921785
DGDB0244 102 2011-03-17-13.11.56.616841
DGDB0247 83 2010-09-01-11.15.27.735671
DGDB0248 4 2004-10-27-10.29.23.052453
DGDB0254 149 2006-07-12-16.35.49.369482
DGDB0255 6 2009-06-11-08.44.03.203655
DGDB0256 19 2011-09-06-15.28.09.229664
DGDB0257 59 2011-09-06-15.29.42.960811
DGDB0258 20 2009-09-29-15.19.57.611661
DGDB0260 17 2009-06-25-08.22.17.297017
DGDB0261 5 2009-06-25-08.23.28.423606
DGDB0262 5 2009-06-25-08.25.18.112304
DGDB0263 35 2004-10-27-10.29.41.195829
DGDB0264 9 2004-10-27-10.29.41.877308
DGDB0265 76 2012-03-16-09.46.15.968614
DGDB0266 20 2007-11-26-08.14.38.947415
DGDB0268 51 2007-05-31-10.41.51.640387
DGDB0269 16 2004-10-27-10.29.57.644724
DGDB0272 45 2004-10-27-10.30.13.604279
DGDB0273 37 2011-11-28-10.57.30.181899
DGDB0274 6 2006-09-08-10.40.29.777600
DGDB0275 221 2012-04-13-08.50.28.813048
DGDB0276 30 2011-02-15-07.53.02.085361
DGDB0277 2 2004-10-27-10.30.16.265751
DGDB0278 32 2004-10-27-10.30.17.040738
DGDB0279 25 2005-08-22-10.08.55.624049
DGDB0281 171 2008-07-21-14.31.34.649556
DGDB0282 27 2012-04-14-11.40.20.325701
DGDB0283 71 2010-02-10-14.19.39.422838
DGDB0284 7 2009-06-25-07.31.45.485555
DGDB0285 31 2009-11-18-13.24.14.262770
DGDB0286 44 2012-01-06-06.41.49.700114
DGDB0287 30 2011-01-26-14.51.07.826564
DGDB0288 33 2007-12-21-13.07.55.406211
DGDB0289 11 2007-05-24-15.42.08.563298
DGDB0290 287 2012-01-05-09.39.36.559408
DGDB0291 8 2012-02-14-10.45.10.650668
DGDB0292 44 2011-08-25-15.45.12.998437
DGDB0295 43 2004-10-27-11.06.06.170413
DGDB0296 51 2009-12-02-14.26.17.948619
DGDB0297 4 2004-10-27-11.06.07.558401
DGDB0300 34 2006-04-27-14.26.20.464157
DGDB0308 26 2004-10-27-10.37.34.302559
DGDB0309 5 2004-10-27-10.37.34.405394
DGDB0310 29 2004-10-27-10.37.34.983835
DGDB0311 46 2004-10-27-10.37.35.686834
DGDB0312 44 2004-10-27-10.37.36.700587
DGDB0313 4 2004-10-27-10.37.36.761966
DGDB0315 87 2007-11-21-07.34.14.982034
DGDB0316 42 2004-11-25-15.18.17.018574
DGDB0317 36 2010-03-05-15.50.28.944976
DGDB0319 57 2004-10-27-10.37.46.607315
DGDB0320 42 2004-10-27-10.37.47.417532
DGDB0321 48 2004-10-27-10.37.48.446302
DGDB0322 111 2004-10-27-10.37.49.957114
DGDB0323 48 2007-08-29-15.03.45.341618
DGDB0324 39 2011-06-09-11.12.50.962332
DGDB0325 9 2004-10-27-10.37.51.070278
DGDB0326 46 2007-06-08-12.42.42.737442
DGDB0327 12 2011-01-31-13.38.16.901852
DGDB0328 6 2004-10-27-10.37.51.987275
DGDB0329 36 2011-12-29-15.47.21.565017
DGDB0330 260 2004-10-27-10.38.06.389515
DGDB0331 20 2004-12-29-11.24.35.814504
DGDB0332 145 2004-10-27-10.38.18.950946
DGDB0334 26 2004-10-27-10.38.20.840649
DGDB0336 41 2011-01-31-13.22.20.144663
DGDB0337 23 2010-03-05-15.53.42.060703
DGDB0338 20 2006-11-03-09.17.17.281054
DGDB0339 163 2010-05-11-12.02.39.073483
DGDB0340 48 2006-08-22-15.43.55.718488
DGDB0341 23 2007-10-09-13.06.32.319986
DGDB0342 166 2005-10-18-16.50.49.693781
DGDB0343 51 2004-10-27-10.38.52.739428
DGDB0344 47 2004-10-27-10.38.54.194384
DGDB0346 13 2005-07-12-11.28.55.165917
DGDB0348 27 2004-10-27-10.39.16.348035
DGDB0349 32 2009-04-03-13.41.43.533715
DGDB0351 188 2012-02-23-13.02.25.753177
DGDB0352 9 2005-03-01-09.24.30.322573
DGDB0354 130 2012-04-10-12.24.27.906766
DGDB0358 49 2010-10-18-16.37.47.140905
DGDB0359 176 2012-02-16-15.28.38.250825
DGDB0360 23 2012-02-16-15.39.32.680807
DGDB0361 4 2004-10-27-10.45.55.286884
DGDB0362 183 2007-11-08-10.54.38.483692
DGDB0363 24 2005-03-04-12.58.24.634911
DGDB0364 105 2004-10-27-10.46.06.076344
DGDB0365 62 2010-03-30-10.33.31.788061
DGDB0366 140 2006-08-11-16.05.44.163608
DGDB0368 10 2012-02-24-15.12.26.189389
DGDB0369 59 2004-12-07-14.12.33.241170
DGDB0370 2 2007-01-30-15.24.18.000563
DGDB0371 36 2006-08-03-14.24.35.904079
DGDB0372 15 2005-06-01-17.07.03.460778
DGDB0373 51 2006-05-09-15.29.40.469475
DGDB0374 196 2011-08-31-17.10.49.928103
DGDB0375 2 2004-10-27-10.48.08.689781
DGDB0376 181 2010-09-29-14.05.30.417429
DGDB0378 12 2005-11-10-11.55.59.849415
DGDB0380 24 2010-02-10-11.37.58.389299
DGDB0381 32 2011-09-13-18.12.47.849518
DGDB0383 21 2007-04-03-18.43.48.575619
DGDB0384 110 2011-09-20-12.27.03.548968
DGDB0385 21 2006-05-09-16.03.41.066883
DGDB0386 37 2006-05-18-14.03.34.184573
DGDB0387 8 2006-01-12-12.57.56.183975
DGDB0388 78 2011-04-20-17.29.21.080223
DGDB0389 176 2011-09-20-15.39.51.976393
DGDB0390 29 2005-10-05-08.57.04.766439
DGDB0391 27 2005-08-25-11.23.21.295470
DGDB0392 36 2010-11-30-09.41.05.588493
DGDB0394 12 2005-05-24-17.53.44.644243
DGDB0395 297 2011-06-09-16.32.36.818613
DGDB0396 57 2011-07-05-14.42.35.712514
DGDB0399 22 2012-04-13-14.30.31.758354
DGDB0400 24 2008-09-05-12.41.37.447612
DGDB0401 84 2011-08-18-14.17.50.966395
DGDB0402 62 2011-04-05-07.22.13.038016
DGDB0403 12 2007-08-02-15.01.49.279712
DGDB0404 51 2005-09-19-11.51.05.491506
DGDB0405 14 2011-11-28-16.16.09.744385
DGDB0406 48 2005-06-08-13.53.30.572456
DGDB0412 220 2011-11-07-13.49.18.749770
DGDB0416 11 2005-10-10-13.35.03.891626
DGDB0417 9 2005-08-10-15.21.24.767924
DGDB0418 26 2008-01-07-13.16.34.910529
DGDB0419 4 2011-03-25-12.47.40.552238
DGDB0420 65 2011-10-11-14.19.07.782165
DGDB0421 11 2009-07-03-13.33.38.613923
DGDB0423 8 2008-01-10-14.50.37.984697
DGDB0424 216 2012-04-13-13.40.37.250468
DGDB0426 314 2007-11-19-11.35.16.571883
DGDB0431 206 2011-11-11-11.06.18.557060
DGDB0432 206 2011-11-11-11.06.18.953307
DGDB0433 175 2011-11-11-11.06.19.338967
DGDB0434 175 2011-11-11-11.06.19.811567
DGDB0435 175 2011-11-11-11.06.20.149377
DGDB0436 175 2011-11-11-11.06.20.614490
DGDB0439 125 2011-12-23-10.46.26.050337
DGDB0441 61 2007-04-10-17.01.59.786020
DGDB0442 68 2007-12-05-11.22.07.796985
DGDB0443 23 2006-06-21-12.01.49.732236
DGDB0444 12 2008-06-26-13.56.23.725837
DGDB0446 47 2010-11-25-11.01.16.065087
DGDB0448 3 2006-11-07-13.48.38.391975
DGDB0449 10 2007-02-22-18.21.36.616246
DGDB0450 36 2011-01-06-00.05.31.564479
DGDB0451 45 2006-10-02-13.22.51.890066
DGDB0452 54 2007-07-06-15.35.21.362996
DGDB0454 15 2007-02-27-15.07.23.973506
DGDB0455 14 2007-03-06-12.10.47.308374
DGDB0456 11 2007-03-06-12.12.25.339149
DGDB0457 12 2007-02-06-13.05.57.831276
DGDB0460 175 2011-11-11-11.06.20.951273
DGDB0463 19 2011-05-26-08.14.11.538447
DGDB0466 106 2010-06-17-12.03.20.687745
DGDB0467 99 2011-07-14-08.53.42.802215
DGDB0468 63 2012-01-09-10.38.16.942277
DGDB0470 6 2008-01-14-13.19.17.936519
DGDB0471 1 2007-04-05-08.09.21.530616
DGDB0472 91 2011-12-15-10.33.00.293887
DGDB0473 57 2011-04-04-17.19.32.307455
DGDB0474 36 2012-02-27-13.52.12.774518
DGDB0475 23 2007-06-26-13.46.14.204488
DGDB0476 16 2012-03-29-12.07.04.466512
DGDB0478 277 2010-05-15-09.25.09.288955
DGDB0479 277 2011-11-04-10.16.27.336216
DGDB0480 43 2010-09-17-18.08.08.876526
DGDB0481 9 2007-09-26-15.51.50.914007
DGDB0482 169 2012-03-07-11.27.46.542459
DGDB0483 3 2008-09-01-09.33.39.312408
DGDB0484 36 2008-09-08-10.01.03.725452
DGDB0485 65 2012-02-08-13.58.37.250580
DGDB0486 213 2012-04-03-11.06.33.703349
DGDB0494 24 2009-06-16-14.33.13.522117
DGDB0495 175 2011-11-11-11.06.21.269834
DGDB0496 175 2011-11-11-11.06.21.620887
DGDB0497 175 2011-11-11-11.06.21.993914
DGDB0498 175 2011-11-11-11.06.22.390687
DGDB0499 38 2010-09-24-15.16.39.934793
DGDB0500 152 2011-01-14-15.36.57.314514
DGDB0501 4 2009-02-04-13.13.45.476435
DGDB0502 6 2009-05-04-12.22.26.732774
DGDB0503 46 2010-11-26-14.51.58.901951
DGDB0504 352 2008-09-29-18.11.51.855204
DGDB0505 52 2011-02-21-18.04.00.438971
DGDB0506 192 2011-12-02-11.42.24.425738
DGDB0509 22 2008-10-06-14.23.27.354520
DGDB0510 18 2008-10-17-15.45.38.642431
DGDB0511 3 2008-11-11-19.19.50.921896
DGDB0513 9 2008-10-16-10.34.43.834006
DGDB0514 44 2011-07-01-09.53.45.583816
DGDB0515 59 2009-06-02-09.39.32.305035
DGDB0516 36 2011-10-27-11.02.46.180128
DGDB0517 5 2008-12-17-14.51.44.330750
DGDB0518 10 2011-08-03-09.49.50.966829
DGDB0519 90 2011-09-22-13.28.20.262347
DGDB0520 175 2011-11-11-11.06.22.757670
DGDB0521 175 2011-11-11-11.06.23.329570
DGDB0522 26 2010-02-26-13.33.41.444428
DGDB0523 7 2010-02-25-09.51.34.640754
DGDB0524 102 2010-11-16-12.44.38.747763
DGDB0525 12 2010-02-02-11.30.57.909044
DGDB0526 2 2010-03-09-09.01.29.460049
DGDB0527 5 2010-09-03-12.45.17.717523
DGDB0528 109 2012-04-13-15.22.09.442700
DGDB0530 4 2010-07-02-15.47.56.155215
DGDB0531 3 2010-09-23-13.08.55.621643
DGDB0532 41 2012-03-21-14.27.34.410053
DGDB0535 6 2012-03-05-18.56.40.857804
DGDB0537 9 2011-12-23-11.50.25.850467
DGDB0544 75 2012-04-04-08.14.10.385242
DGDB0545 11 2012-02-10-11.16.01.047999
DGDB0546 35 2012-02-07-07.56.45.853935
DGDB0547 4 2012-03-28-15.36.32.255944
DGDB0549 25 2012-04-19-11.10.51.095930
DGDB0550 222 2012-04-11-10.19.41.648048
DGDB0637 23 2008-05-14-13.57.46.949266
DGDB0638 32 2011-08-23-16.05.12.759488
DGDB0639 52 2012-01-12-17.46.02.351192
DGDB0668 38 2006-07-07-13.57.03.529288
DGDB0669 34 2007-02-16-10.51.37.229471
DGDB0670 4 2007-02-16-10.51.30.970612
DGDB0671 119 2012-03-14-01.44.21.325314
DGDB0672 8 2009-09-30-17.20.42.593724
DGDB0673 417 2011-11-21-07.49.01.349758
DGDB0674 16 2012-01-23-16.19.46.217184
DGDB0675 24 2011-12-23-13.41.31.721097
DGDB0676 24 2011-12-23-13.42.18.336935
DGDB0677 24 2011-12-23-13.45.13.116665
DGDB0678 24 2011-12-23-13.38.40.186996
DGDB0679 20 2012-04-13-11.35.52.553230
DGDB0680 9 2012-02-03-13.34.57.714327
DGDB0681 64 2012-02-07-13.58.45.450658
DGDB0999 3 2006-08-02-17.04.48.795859
DGDB6663 84 2008-12-16-11.00.34.036780
DGDB9991 3 2010-03-10-17.51.18.864416
DGDB9992 3 2010-03-10-17.51.20.104435
DGDB9993 3 2010-03-10-17.51.21.415808
DGDB9996 15 2012-03-14-16.20.29.519115
DGDB9997 24 2009-10-21-16.03.17.745454
DGDB9998 331 2012-04-17-11.18.48.221102
DGDB9999 25 2005-06-02-12.56.05.901310
369 rows fetched: with d as ( select name db from sysibm.sysDatabase where...
$#out 20120419 15:39:58
DB OL2 COL3
DGDB0380 24 2010-02-10-11.37.58.389299
DGDB0381 32 2011-09-13-18.12.47.849518
DGDB0383 21 2007-04-03-18.43.48.575619
DGDB0384 110 2011-09-20-12.27.03.548968
DGDB0385 21 2006-05-09-16.03.41.066883
DGDB0386 37 2006-05-18-14.03.34.184573
DGDB0387 8 2006-01-12-12.57.56.183975
DGDB0388 78 2011-04-20-17.29.21.080223
DGDB0389 176 2011-09-20-15.39.51.976393
9 rows fetched: with d as ( select name db from sysibm.sysDatabase where n...
$#out 20120419 15:38:39
DB TY L3 COL4
DGDB0380 T 8 2010-02-10-11.37.58.130586
DGDB0380 V 8 2010-02-10-11.37.58.389299
DGDB0380 ix 8 2010-02-10-11.37.58.182409
DGDB0381 T 7 2011-09-13-18.12.47.849518
DGDB0381 ix 25 2011-03-11-11.14.40.735444
DGDB0383 T 5 2007-03-27-19.45.43.349765
DGDB0383 V 1 2007-04-03-18.43.48.575619
DGDB0383 ix 15 2007-03-27-19.45.44.239856
DGDB0384 T 30 2011-09-20-12.27.03.548968
DGDB0384 V 30 2011-09-20-12.27.03.509150
DGDB0384 ix 50 2011-09-20-12.27.03.250716
DGDB0385 T 5 2006-01-31-14.41.21.042825
DGDB0385 V 8 2006-05-09-16.03.41.066883
DGDB0385 ix 8 2006-01-31-14.41.21.182119
DGDB0386 T 9 2005-07-12-18.18.49.591562
DGDB0386 V 9 2005-07-12-18.18.49.565084
DGDB0386 ix 19 2006-05-18-14.03.34.184573
DGDB0387 T 2 2005-05-26-17.14.59.864175
DGDB0387 V 2 2005-05-26-17.15.01.494312
DGDB0387 ix 4 2006-01-12-12.57.56.183975
DGDB0388 T 28 2011-04-20-17.29.18.870285
DGDB0388 V 3 2008-04-23-09.00.49.671155
DGDB0388 ix 47 2011-04-20-17.29.21.080223
DGDB0389 T 46 2011-09-20-15.39.51.557962
DGDB0389 V 31 2011-06-17-16.03.25.380888
DGDB0389 ix 99 2011-09-20-15.39.51.976393
26 rows fetched: with d as ( select name db from sysibm.sysDatabase where ...
$#out 20120419 15:38:11
DB TY L3 COL4
DGDB0389 T 46 2011-09-20-15.39.51.557962
DGDB0389 V 31 2011-06-17-16.03.25.380888
DGDB0389 ix 99 2011-09-20-15.39.51.976393
3 rows fetched: with d as ( select name db from sysibm.sysDatabase where n...
$#out 20120419 15:37:51
*** run error ***
SQLCODE = -206: AT IS NOT VALID IN THE CONTEXT WHERE IT IS
USED
stmt = prepare s10 into :M.SQL.10.D from :src
with into :M.SQL.10.D = M.SQL.10.D
from :src = with d as
$#out 20120419 15:37:22
*** run error ***
SQLCODE = -206: DB IS NOT VALID IN THE CONTEXT WHERE IT IS
USED
stmt = prepare s10 into :M.SQL.10.D from :src
with into :M.SQL.10.D = M.SQL.10.D
from :src = with d as
$#out 20120419 15:34:48
*** run error ***
SQLCODE = -421: THE OPERANDS OF A SET OPERATOR DO NOT HAVE
THE SAME NUMBER OF COLUMNS
stmt = prepare s10 into :M.SQL.10.D from :src
with into :M.SQL.10.D = M.SQL.10.D
from :src = with d as
$#out 20120419 15:33:22
*** run error ***
SQLCODE = -122: COLUMN OR EXPRESSION IN THE SELECT LIST IS
NOT VALID
stmt = prepare s10 into :M.SQL.10.D from :src
with into :M.SQL.10.D = M.SQL.10.D
from :src = with d as
$#out 20120419 15:30:21
CO L2 COL3
T 46 2011-09-20-15.39.51.557962
V 31 2011-06-17-16.03.25.380888
ix 99 2011-09-20-15.39.51.976393
3 rows fetched: with d as ( select name db from sysibm.sysDatabase where n...
$#out 20120419 15:30:04
CO 2 COL
ix 0 ---
1 rows fetched: with d as ( select name db from sysibm.sysDatabase where n...
$#out 20120419 15:28:08