home *** CD-ROM | disk | FTP | other *** search
DB2 Bind | 1999-11-22 | 12.8 KB | 283 lines |
- QECSWHV1AA21PIGKQE 3
- BEGIN DECLARE SECTION
- END DECLARE SECTION
- DECLARE C1 CURSOR WITH HOLD FOR S1
- PREPARE S1 FROM :stmtstr
- BEGIN DECLARE SECTION
- END DECLARE SECTION
- DECLARE C2 CURSOR WITH HOLD FOR S2
- PREPARE S2 FROM :stmtstr
- OPEN C2
- FETCH C2 INTO :buf
- CLOSE C2
- DECLARE C3 CURSOR WITH HOLD FOR S3
- PREPARE S3 FROM :stmtstr
- OPEN C3
- FETCH C3 INTO :buf
- CLOSE C3
- COMMIT
- ROLLBACK
- DECLARE C4 CURSOR WITH HOLD FOR S4
- PREPARE S4 INTO :Sqlda FROM :stmtstr
- DESCRIBE S4 INTO :Sqlda
- DECLARE C5 CURSOR WITH HOLD FOR S5
- CLOSE C5
- EXECUTE S5 USING DESCRIPTOR :ParamSqlda
- OPEN C5 USING DESCRIPTOR :ParamSqlda
- EXECUTE S5
- OPEN C5
- DECLARE C6 CURSOR WITH HOLD FOR S6
- FETCH C6 USING DESCRIPTOR :Sqlda
- CLOSE C6
- DECLARE C7 CURSOR WITH HOLD FOR S7
- CLOSE C7
- DECLARE C8 CURSOR WITH HOLD FOR S8
- DECLARE C9 CURSOR WITH HOLD FOR S9
- DECLARE C10 CURSOR WITH HOLD FOR S10
- DECLARE C11 CURSOR WITH HOLD FOR S11
- DECLARE C12 CURSOR WITH HOLD FOR S12
- DECLARE C13 CURSOR WITH HOLD FOR S13
- DECLARE C14 CURSOR WITH HOLD FOR S14
- DECLARE C15 CURSOR WITH HOLD FOR S15
- DECLARE C16 CURSOR WITH HOLD FOR S16
- DECLARE C17 CURSOR WITH HOLD FOR S17
- DECLARE C18 CURSOR WITH HOLD FOR S18
- DECLARE C19 CURSOR WITH HOLD FOR S19
- DECLARE C20 CURSOR WITH HOLD FOR S20
- DECLARE C21 CURSOR WITH HOLD FOR S21
- DECLARE C22 CURSOR WITH HOLD FOR S22
- DECLARE C23 CURSOR WITH HOLD FOR S23
- DECLARE C24 CURSOR WITH HOLD FOR S24
- DECLARE C25 CURSOR WITH HOLD FOR S25
- DECLARE C26 CURSOR WITH HOLD FOR S26
- DECLARE C27 CURSOR WITH HOLD FOR S27
- DECLARE C28 CURSOR WITH HOLD FOR S28
- DECLARE C29 CURSOR WITH HOLD FOR S29
- DECLARE C30 CURSOR WITH HOLD FOR S30
- DECLARE C31 CURSOR WITH HOLD FOR S31
- DECLARE C32 CURSOR WITH HOLD FOR S32
- DECLARE C33 CURSOR WITH HOLD FOR S33
- DECLARE C34 CURSOR WITH HOLD FOR S34
- DECLARE C35 CURSOR WITH HOLD FOR S35
- DECLARE C36 CURSOR WITH HOLD FOR S36
- DECLARE C37 CURSOR WITH HOLD FOR S37
- DECLARE C38 CURSOR WITH HOLD FOR S38
- DECLARE C39 CURSOR WITH HOLD FOR S39
- DECLARE C40 CURSOR WITH HOLD FOR S40
- DECLARE C41 CURSOR WITH HOLD FOR S41
- DECLARE C42 CURSOR WITH HOLD FOR S42
- DECLARE C43 CURSOR WITH HOLD FOR S43
- DECLARE C44 CURSOR WITH HOLD FOR S44
- DECLARE C45 CURSOR WITH HOLD FOR S45
- DECLARE C46 CURSOR WITH HOLD FOR S46
- DECLARE C47 CURSOR WITH HOLD FOR S47
- DECLARE C48 CURSOR WITH HOLD FOR S48
- DECLARE C49 CURSOR WITH HOLD FOR S49
- DECLARE C50 CURSOR WITH HOLD FOR S50
- DECLARE C51 CURSOR WITH HOLD FOR S51
- DECLARE C52 CURSOR WITH HOLD FOR S52
- DECLARE C53 CURSOR WITH HOLD FOR S53
- DECLARE C54 CURSOR WITH HOLD FOR S54
- DECLARE C55 CURSOR WITH HOLD FOR S55
- DECLARE C56 CURSOR WITH HOLD FOR S56
- DECLARE C57 CURSOR WITH HOLD FOR S57
- DECLARE C58 CURSOR WITH HOLD FOR S58
- DECLARE C59 CURSOR WITH HOLD FOR S59
- DECLARE C60 CURSOR WITH HOLD FOR S60
- DECLARE C61 CURSOR WITH HOLD FOR S61
- DECLARE C62 CURSOR WITH HOLD FOR S62
- DECLARE C63 CURSOR WITH HOLD FOR S63
- DECLARE C64 CURSOR WITH HOLD FOR S64
- DECLARE C65 CURSOR WITH HOLD FOR S65
- DECLARE C66 CURSOR WITH HOLD FOR S66
- DECLARE C67 CURSOR WITH HOLD FOR S67
- DECLARE C68 CURSOR WITH HOLD FOR S68
- DECLARE C69 CURSOR WITH HOLD FOR S69
- DECLARE C70 CURSOR WITH HOLD FOR S70
- DECLARE C71 CURSOR WITH HOLD FOR S71
- DECLARE C72 CURSOR WITH HOLD FOR S72
- DECLARE C73 CURSOR WITH HOLD FOR S73
- DECLARE C74 CURSOR WITH HOLD FOR S74
- DECLARE C75 CURSOR WITH HOLD FOR S75
- DECLARE C76 CURSOR WITH HOLD FOR S76
- DECLARE C77 CURSOR WITH HOLD FOR S77
- DECLARE C78 CURSOR WITH HOLD FOR S78
- DECLARE C79 CURSOR WITH HOLD FOR S79
- DECLARE C80 CURSOR WITH HOLD FOR S80
- DECLARE C81 CURSOR WITH HOLD FOR S81
- DECLARE C82 CURSOR WITH HOLD FOR S82
- DECLARE C83 CURSOR WITH HOLD FOR S83
- DECLARE C84 CURSOR WITH HOLD FOR S84
- DECLARE C85 CURSOR WITH HOLD FOR S85
- DECLARE C86 CURSOR WITH HOLD FOR S86
- DECLARE C87 CURSOR WITH HOLD FOR S87
- DECLARE C88 CURSOR WITH HOLD FOR S88
- DECLARE C89 CURSOR WITH HOLD FOR S89
- DECLARE C90 CURSOR WITH HOLD FOR S90
- DECLARE C91 CURSOR WITH HOLD FOR S91
- DECLARE C92 CURSOR WITH HOLD FOR S92
- DECLARE C93 CURSOR WITH HOLD FOR S93
- DECLARE C94 CURSOR WITH HOLD FOR S94
- DECLARE C95 CURSOR WITH HOLD FOR S95
- DECLARE C96 CURSOR WITH HOLD FOR S96
- DECLARE C97 CURSOR WITH HOLD FOR S97
- DECLARE C98 CURSOR WITH HOLD FOR S98
- DECLARE C99 CURSOR WITH HOLD FOR S99
- DECLARE C100 CURSOR WITH HOLD FOR S100
- DECLARE C101 CURSOR WITH HOLD FOR S101
- DECLARE C102 CURSOR WITH HOLD FOR S102
- DECLARE C103 CURSOR WITH HOLD FOR S103
- DECLARE C104 CURSOR WITH HOLD FOR S104
- DECLARE C105 CURSOR WITH HOLD FOR S105
- DECLARE C106 CURSOR WITH HOLD FOR S106
- DECLARE C107 CURSOR WITH HOLD FOR S107
- DECLARE C108 CURSOR WITH HOLD FOR S108
- DECLARE C109 CURSOR WITH HOLD FOR S109
- DECLARE C110 CURSOR WITH HOLD FOR S110
- DECLARE C111 CURSOR WITH HOLD FOR S111
- DECLARE C112 CURSOR WITH HOLD FOR S112
- DECLARE C113 CURSOR WITH HOLD FOR S113
- DECLARE C114 CURSOR WITH HOLD FOR S114
- DECLARE C115 CURSOR WITH HOLD FOR S115
- DECLARE C116 CURSOR WITH HOLD FOR S116
- DECLARE C117 CURSOR WITH HOLD FOR S117
- DECLARE C118 CURSOR WITH HOLD FOR S118
- DECLARE C119 CURSOR WITH HOLD FOR S119
- DECLARE C120 CURSOR WITH HOLD FOR S120
- DECLARE C121 CURSOR WITH HOLD FOR S121
- DECLARE C122 CURSOR WITH HOLD FOR S122
- DECLARE C123 CURSOR WITH HOLD FOR S123
- DECLARE C124 CURSOR WITH HOLD FOR S124
- DECLARE C125 CURSOR WITH HOLD FOR S125
- DECLARE C126 CURSOR WITH HOLD FOR S126
- DECLARE C127 CURSOR WITH HOLD FOR S127
- DECLARE C128 CURSOR WITH HOLD FOR S128
- DECLARE C129 CURSOR WITH HOLD FOR S129
- DECLARE C130 CURSOR WITH HOLD FOR S130
- DECLARE C131 CURSOR WITH HOLD FOR S131
- DECLARE C132 CURSOR WITH HOLD FOR S132
- DECLARE C133 CURSOR WITH HOLD FOR S133
- DECLARE C134 CURSOR WITH HOLD FOR S134
- DECLARE C135 CURSOR WITH HOLD FOR S135
- DECLARE C136 CURSOR WITH HOLD FOR S136
- DECLARE C137 CURSOR WITH HOLD FOR S137
- DECLARE C138 CURSOR WITH HOLD FOR S138
- DECLARE C139 CURSOR WITH HOLD FOR S139
- DECLARE C140 CURSOR WITH HOLD FOR S140
- DECLARE C141 CURSOR WITH HOLD FOR S141
- DECLARE C142 CURSOR WITH HOLD FOR S142
- DECLARE C143 CURSOR WITH HOLD FOR S143
- DECLARE C144 CURSOR WITH HOLD FOR S144
- DECLARE C145 CURSOR WITH HOLD FOR S145
- DECLARE C146 CURSOR WITH HOLD FOR S146
- DECLARE C147 CURSOR WITH HOLD FOR S147
- DECLARE C148 CURSOR WITH HOLD FOR S148
- DECLARE C149 CURSOR WITH HOLD FOR S149
- DECLARE C150 CURSOR WITH HOLD FOR S150
- DECLARE C151 CURSOR WITH HOLD FOR S151
- DECLARE C152 CURSOR WITH HOLD FOR S152
- DECLARE C153 CURSOR WITH HOLD FOR S153
- DECLARE C154 CURSOR WITH HOLD FOR S154
- DECLARE C155 CURSOR WITH HOLD FOR S155
- DECLARE C156 CURSOR WITH HOLD FOR S156
- DECLARE C157 CURSOR WITH HOLD FOR S157
- DECLARE C158 CURSOR WITH HOLD FOR S158
- DECLARE C159 CURSOR WITH HOLD FOR S159
- DECLARE C160 CURSOR WITH HOLD FOR S160
- DECLARE C161 CURSOR WITH HOLD FOR S161
- DECLARE C162 CURSOR WITH HOLD FOR S162
- DECLARE C163 CURSOR WITH HOLD FOR S163
- DECLARE C164 CURSOR WITH HOLD FOR S164
- DECLARE C165 CURSOR WITH HOLD FOR S165
- DECLARE C166 CURSOR WITH HOLD FOR S166
- DECLARE C167 CURSOR WITH HOLD FOR S167
- DECLARE C168 CURSOR WITH HOLD FOR S168
- DECLARE C169 CURSOR WITH HOLD FOR S169
- DECLARE C170 CURSOR WITH HOLD FOR S170
- DECLARE C171 CURSOR WITH HOLD FOR S171
- DECLARE C172 CURSOR WITH HOLD FOR S172
- DECLARE C173 CURSOR WITH HOLD FOR S173
- DECLARE C174 CURSOR WITH HOLD FOR S174
- DECLARE C175 CURSOR WITH HOLD FOR S175
- DECLARE C176 CURSOR WITH HOLD FOR S176
- DECLARE C177 CURSOR WITH HOLD FOR S177
- DECLARE C178 CURSOR WITH HOLD FOR S178
- DECLARE C179 CURSOR WITH HOLD FOR S179
- DECLARE C180 CURSOR WITH HOLD FOR S180
- DECLARE C181 CURSOR WITH HOLD FOR S181
- DECLARE C182 CURSOR WITH HOLD FOR S182
- DECLARE C183 CURSOR WITH HOLD FOR S183
- DECLARE C184 CURSOR WITH HOLD FOR S184
- DECLARE C185 CURSOR WITH HOLD FOR S185
- DECLARE C186 CURSOR WITH HOLD FOR S186
- DECLARE C187 CURSOR WITH HOLD FOR S187
- DECLARE C188 CURSOR WITH HOLD FOR S188
- DECLARE C189 CURSOR WITH HOLD FOR S189
- DECLARE C190 CURSOR WITH HOLD FOR S190
- DECLARE C191 CURSOR WITH HOLD FOR S191
- DECLARE C192 CURSOR WITH HOLD FOR S192
- DECLARE C193 CURSOR WITH HOLD FOR S193
- DECLARE C194 CURSOR WITH HOLD FOR S194
- DECLARE C195 CURSOR WITH HOLD FOR S195
- DECLARE C196 CURSOR WITH HOLD FOR S196
- DECLARE C197 CURSOR WITH HOLD FOR S197
- DECLARE C198 CURSOR WITH HOLD FOR S198
- DECLARE C199 CURSOR WITH HOLD FOR S199
- DECLARE C200 CURSOR WITH HOLD FOR S200
- DECLARE C201 CURSOR WITH HOLD FOR S201
- DECLARE C202 CURSOR WITH HOLD FOR S202
- DECLARE C203 CURSOR WITH HOLD FOR S203
- DECLARE C204 CURSOR WITH HOLD FOR S204
- DECLARE C205 CURSOR WITH HOLD FOR S205
- DECLARE C206 CURSOR WITH HOLD FOR S206
- DECLARE C207 CURSOR WITH HOLD FOR S207
- DECLARE C208 CURSOR WITH HOLD FOR S208
- DECLARE C209 CURSOR WITH HOLD FOR S209
- DECLARE C210 CURSOR WITH HOLD FOR S210
- DECLARE C211 CURSOR WITH HOLD FOR S211
- DECLARE C212 CURSOR WITH HOLD FOR S212
- DECLARE C213 CURSOR WITH HOLD FOR S213
- DECLARE C214 CURSOR WITH HOLD FOR S214
- DECLARE C215 CURSOR WITH HOLD FOR S215
- DECLARE C216 CURSOR WITH HOLD FOR S216
- DECLARE C217 CURSOR WITH HOLD FOR S217
- DECLARE C218 CURSOR WITH HOLD FOR S218
- DECLARE C219 CURSOR WITH HOLD FOR S219
- DECLARE C220 CURSOR WITH HOLD FOR S220
- DECLARE C221 CURSOR WITH HOLD FOR S221
- DECLARE C222 CURSOR WITH HOLD FOR S222
- DECLARE C223 CURSOR WITH HOLD FOR S223
- DECLARE C224 CURSOR WITH HOLD FOR S224
- DECLARE C225 CURSOR WITH HOLD FOR S225
- DECLARE C226 CURSOR WITH HOLD FOR S226
- DECLARE C227 CURSOR WITH HOLD FOR S227
- DECLARE C228 CURSOR WITH HOLD FOR S228
- DECLARE C229 CURSOR WITH HOLD FOR S229
- DECLARE C230 CURSOR WITH HOLD FOR S230
- DECLARE C231 CURSOR WITH HOLD FOR S231
- DECLARE C232 CURSOR WITH HOLD FOR S232
- DECLARE C233 CURSOR WITH HOLD FOR S233
- DECLARE C234 CURSOR WITH HOLD FOR S234
- DECLARE C235 CURSOR WITH HOLD FOR S235
- DECLARE C236 CURSOR WITH HOLD FOR S236
- DECLARE C237 CURSOR WITH HOLD FOR S237
- DECLARE C238 CURSOR WITH HOLD FOR S238
- DECLARE C239 CURSOR WITH HOLD FOR S239
- DECLARE C240 CURSOR WITH HOLD FOR S240
- DECLARE C241 CURSOR WITH HOLD FOR S241
- DECLARE C242 CURSOR WITH HOLD FOR S242
- DECLARE C243 CURSOR WITH HOLD FOR S243
- DECLARE C244 CURSOR WITH HOLD FOR S244
- DECLARE C245 CURSOR WITH HOLD FOR S245
- DECLARE C246 CURSOR WITH HOLD FOR S246
- DECLARE C247 CURSOR WITH HOLD FOR S247
- DECLARE C248 CURSOR WITH HOLD FOR S248
- DECLARE C249 CURSOR WITH HOLD FOR S249
- DECLARE C250 CURSOR WITH HOLD FOR S250
- DECLARE C251 CURSOR WITH HOLD FOR S251
- DECLARE C252 CURSOR WITH HOLD FOR S252
- DECLARE C253 CURSOR WITH HOLD FOR S253
- DECLARE C254 CURSOR WITH HOLD FOR S254
- DECLARE C255 CURSOR WITH HOLD FOR S255
- stmtstr
-