zOs/SQL/MFPART
--lect 'when MF150013 <= ''' || strip(limitKey) || ''' then '
-- || right(' ' || strip(char(partition)), 5) ,
-- partition, limitkey, limitkey_internal,
-- hex(limitkey_internal)
-- from sysibm.systablePart
-- where dbName = 'MF01A1P' and tsName = 'A150A'
-- order by partition
with p as
(
select case
when MF150013 <= '31.12.2000' then 1
when MF150013 <= '31.12.2001' then 2
when MF150013 <= '31.12.2002' then 3
when MF150013 <= '31.12.2003' then 4
when MF150013 <= '31.12.2004' then 5
when MF150013 <= '31.12.2005' then 6
when MF150013 <= '31.12.2006' then 7
when MF150013 <= '31.12.2007' then 8
when MF150013 <= '31.12.2008' then 9
when MF150013 <= '03.01.2009' then 10
when MF150013 <= '06.01.2009' then 11
when MF150013 <= '09.01.2009' then 12
when MF150013 <= '12.01.2009' then 13
when MF150013 <= '15.01.2009' then 14
when MF150013 <= '18.01.2009' then 15
when MF150013 <= '21.01.2009' then 16
when MF150013 <= '24.01.2009' then 17
when MF150013 <= '27.01.2009' then 18
when MF150013 <= '31.01.2009' then 19
when MF150013 <= '03.02.2009' then 20
when MF150013 <= '06.02.2009' then 21
when MF150013 <= '09.02.2009' then 22
when MF150013 <= '12.02.2009' then 23
when MF150013 <= '15.02.2009' then 24
when MF150013 <= '18.02.2009' then 25
when MF150013 <= '21.02.2009' then 26
when MF150013 <= '24.02.2009' then 27
when MF150013 <= '27.02.2009' then 28
when MF150013 <= '28.02.2009' then 29
when MF150013 <= '03.03.2009' then 30
when MF150013 <= '06.03.2009' then 31
when MF150013 <= '09.03.2009' then 32
when MF150013 <= '12.03.2009' then 33
when MF150013 <= '15.03.2009' then 34
when MF150013 <= '18.03.2009' then 35
when MF150013 <= '21.03.2009' then 36
when MF150013 <= '24.03.2009' then 37
when MF150013 <= '27.03.2009' then 38
when MF150013 <= '31.03.2009' then 39
when MF150013 <= '03.04.2009' then 40
when MF150013 <= '06.04.2009' then 41
when MF150013 <= '09.04.2009' then 42
when MF150013 <= '12.04.2009' then 43
when MF150013 <= '15.04.2009' then 44
when MF150013 <= '18.04.2009' then 45
when MF150013 <= '21.04.2009' then 46
when MF150013 <= '24.04.2009' then 47
when MF150013 <= '27.04.2009' then 48
when MF150013 <= '30.04.2009' then 49
when MF150013 <= '03.05.2009' then 50
when MF150013 <= '06.05.2009' then 51
when MF150013 <= '09.05.2009' then 52
when MF150013 <= '12.05.2009' then 53
when MF150013 <= '15.05.2009' then 54
when MF150013 <= '18.05.2009' then 55
when MF150013 <= '21.05.2009' then 56
when MF150013 <= '24.05.2009' then 57
when MF150013 <= '27.05.2009' then 58
when MF150013 <= '31.05.2009' then 59
when MF150013 <= '03.06.2009' then 60
when MF150013 <= '06.06.2009' then 61
when MF150013 <= '09.06.2009' then 62
when MF150013 <= '12.06.2009' then 63
when MF150013 <= '15.06.2009' then 64
when MF150013 <= '18.06.2009' then 65
when MF150013 <= '21.06.2009' then 66
when MF150013 <= '24.06.2009' then 67
when MF150013 <= '27.06.2009' then 68
when MF150013 <= '30.06.2009' then 69
when MF150013 <= '03.07.2009' then 70
when MF150013 <= '06.07.2009' then 71
when MF150013 <= '09.07.2009' then 72
when MF150013 <= '12.07.2009' then 73
when MF150013 <= '15.07.2009' then 74
when MF150013 <= '18.07.2009' then 75
when MF150013 <= '21.07.2009' then 76
when MF150013 <= '24.07.2009' then 77
when MF150013 <= '27.07.2009' then 78
when MF150013 <= '31.07.2009' then 79
when MF150013 <= '03.08.2009' then 80
when MF150013 <= '06.08.2009' then 81
when MF150013 <= '09.08.2009' then 82
when MF150013 <= '12.08.2009' then 83
when MF150013 <= '15.08.2009' then 84
when MF150013 <= '18.08.2009' then 85
when MF150013 <= '21.08.2009' then 86
when MF150013 <= '24.08.2009' then 87
when MF150013 <= '27.08.2009' then 88
when MF150013 <= '31.08.2009' then 89
when MF150013 <= '03.09.2009' then 90
when MF150013 <= '06.09.2009' then 91
when MF150013 <= '09.09.2009' then 92
when MF150013 <= '12.09.2009' then 93
when MF150013 <= '15.09.2009' then 94
when MF150013 <= '18.09.2009' then 95
when MF150013 <= '21.09.2009' then 96
when MF150013 <= '24.09.2009' then 97
when MF150013 <= '27.09.2009' then 98
when MF150013 <= '30.09.2009' then 99
when MF150013 <= '03.10.2009' then 100
when MF150013 <= '06.10.2009' then 101
when MF150013 <= '09.10.2009' then 102
when MF150013 <= '12.10.2009' then 103
when MF150013 <= '15.10.2009' then 104
when MF150013 <= '18.10.2009' then 105
when MF150013 <= '21.10.2009' then 106
when MF150013 <= '24.10.2009' then 107
when MF150013 <= '27.10.2009' then 108
when MF150013 <= '31.10.2009' then 109
when MF150013 <= '03.11.2009' then 110
when MF150013 <= '06.11.2009' then 111
when MF150013 <= '09.11.2009' then 112
when MF150013 <= '12.11.2009' then 113
when MF150013 <= '15.11.2009' then 114
when MF150013 <= '18.11.2009' then 115
when MF150013 <= '21.11.2009' then 116
when MF150013 <= '24.11.2009' then 117
when MF150013 <= '27.11.2009' then 118
when MF150013 <= '30.11.2009' then 119
when MF150013 <= '03.12.2009' then 120
when MF150013 <= '06.12.2009' then 121
when MF150013 <= '09.12.2009' then 122
when MF150013 <= '12.12.2009' then 123
when MF150013 <= '15.12.2009' then 124
when MF150013 <= '18.12.2009' then 125
when MF150013 <= '21.12.2009' then 126
when MF150013 <= '24.12.2009' then 127
when MF150013 <= '27.12.2009' then 128
when MF150013 <= '31.12.2009' then 129
when MF150013 <= '03.01.2010' then 130
when MF150013 <= '06.01.2010' then 131
when MF150013 <= '09.01.2010' then 132
when MF150013 <= '12.01.2010' then 133
when MF150013 <= '15.01.2010' then 134
when MF150013 <= '18.01.2010' then 135
when MF150013 <= '21.01.2010' then 136
when MF150013 <= '24.01.2010' then 137
when MF150013 <= '27.01.2010' then 138
when MF150013 <= '31.01.2010' then 139
when MF150013 <= '03.02.2010' then 140
when MF150013 <= '06.02.2010' then 141
when MF150013 <= '09.02.2010' then 142
when MF150013 <= '12.02.2010' then 143
when MF150013 <= '15.02.2010' then 144
when MF150013 <= '18.02.2010' then 145
when MF150013 <= '21.02.2010' then 146
when MF150013 <= '24.02.2010' then 147
when MF150013 <= '27.02.2010' then 148
when MF150013 <= '28.02.2010' then 149
when MF150013 <= '03.03.2010' then 150
when MF150013 <= '06.03.2010' then 151
when MF150013 <= '09.03.2010' then 152
when MF150013 <= '12.03.2010' then 153
when MF150013 <= '15.03.2010' then 154
when MF150013 <= '18.03.2010' then 155
when MF150013 <= '21.03.2010' then 156
when MF150013 <= '24.03.2010' then 157
when MF150013 <= '27.03.2010' then 158
when MF150013 <= '31.03.2010' then 159
when MF150013 <= '03.04.2010' then 160
when MF150013 <= '06.04.2010' then 161
when MF150013 <= '09.04.2010' then 162
when MF150013 <= '12.04.2010' then 163
when MF150013 <= '15.04.2010' then 164
when MF150013 <= '18.04.2010' then 165
when MF150013 <= '21.04.2010' then 166
when MF150013 <= '24.04.2010' then 167
when MF150013 <= '27.04.2010' then 168
when MF150013 <= '30.04.2010' then 169
when MF150013 <= '03.05.2010' then 170
when MF150013 <= '06.05.2010' then 171
when MF150013 <= '09.05.2010' then 172
when MF150013 <= '12.05.2010' then 173
when MF150013 <= '15.05.2010' then 174
when MF150013 <= '18.05.2010' then 175
when MF150013 <= '21.05.2010' then 176
when MF150013 <= '24.05.2010' then 177
when MF150013 <= '27.05.2010' then 178
when MF150013 <= '31.05.2010' then 179
when MF150013 <= '03.06.2010' then 180
when MF150013 <= '06.06.2010' then 181
when MF150013 <= '09.06.2010' then 182
when MF150013 <= '12.06.2010' then 183
when MF150013 <= '15.06.2010' then 184
when MF150013 <= '18.06.2010' then 185
when MF150013 <= '21.06.2010' then 186
when MF150013 <= '24.06.2010' then 187
when MF150013 <= '27.06.2010' then 188
when MF150013 <= '30.06.2010' then 189
when MF150013 <= '03.07.2010' then 190
when MF150013 <= '06.07.2010' then 191
when MF150013 <= '09.07.2010' then 192
when MF150013 <= '12.07.2010' then 193
when MF150013 <= '15.07.2010' then 194
when MF150013 <= '18.07.2010' then 195
when MF150013 <= '21.07.2010' then 196
when MF150013 <= '24.07.2010' then 197
when MF150013 <= '27.07.2010' then 198
when MF150013 <= '31.07.2010' then 199
when MF150013 <= '03.08.2010' then 200
when MF150013 <= '06.08.2010' then 201
when MF150013 <= '09.08.2010' then 202
when MF150013 <= '12.08.2010' then 203
when MF150013 <= '15.08.2010' then 204
when MF150013 <= '18.08.2010' then 205
when MF150013 <= '21.08.2010' then 206
when MF150013 <= '24.08.2010' then 207
when MF150013 <= '27.08.2010' then 208
when MF150013 <= '31.08.2010' then 209
when MF150013 <= '03.09.2010' then 210
when MF150013 <= '06.09.2010' then 211
when MF150013 <= '09.09.2010' then 212
when MF150013 <= '12.09.2010' then 213
when MF150013 <= '15.09.2010' then 214
when MF150013 <= '18.09.2010' then 215
when MF150013 <= '21.09.2010' then 216
when MF150013 <= '24.09.2010' then 217
when MF150013 <= '27.09.2010' then 218
when MF150013 <= '30.09.2010' then 219
when MF150013 <= '03.10.2010' then 220
when MF150013 <= '06.10.2010' then 221
when MF150013 <= '09.10.2010' then 222
when MF150013 <= '12.10.2010' then 223
when MF150013 <= '15.10.2010' then 224
when MF150013 <= '18.10.2010' then 225
when MF150013 <= '21.10.2010' then 226
when MF150013 <= '24.10.2010' then 227
when MF150013 <= '27.10.2010' then 228
when MF150013 <= '31.10.2010' then 229
when MF150013 <= '03.11.2010' then 230
when MF150013 <= '06.11.2010' then 231
when MF150013 <= '09.11.2010' then 232
when MF150013 <= '12.11.2010' then 233
when MF150013 <= '15.11.2010' then 234
when MF150013 <= '18.11.2010' then 235
when MF150013 <= '21.11.2010' then 236
when MF150013 <= '24.11.2010' then 237
when MF150013 <= '27.11.2010' then 238
when MF150013 <= '30.11.2010' then 239
when MF150013 <= '03.12.2010' then 240
when MF150013 <= '06.12.2010' then 241
when MF150013 <= '09.12.2010' then 242
when MF150013 <= '12.12.2010' then 243
when MF150013 <= '15.12.2010' then 244
when MF150013 <= '18.12.2010' then 245
when MF150013 <= '21.12.2010' then 246
when MF150013 <= '24.12.2010' then 247
when MF150013 <= '27.12.2010' then 248
when MF150013 <= '31.12.2010' then 249
when MF150013 <= '03.01.2011' then 250
when MF150013 <= '06.01.2011' then 251
when MF150013 <= '09.01.2011' then 252
when MF150013 <= '12.01.2011' then 253
when MF150013 <= '31.12.2099' then 254
else 9999
end part
, count(*) cnt, mf150013
from oa1p.tmf150a1
-- where mf150013 < '31.12.2004'
GROUP BY mf150013
)
select part, sum(cnt), min(mf150013), max(mf150013)
from p
group by part
with ur
;