home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
On Hand
/
On_Hand_From_Softbank_1994_Release_2_Disc_1_1994.iso
/
00083
/
s
/
123
/
dmsqc.bnd
(
.txt
)
< prev
next >
Wrap
DB2 Bind
|
1993-09-24
|
3KB
|
78 lines
DMSQC MAWdKBHJDLEEDM 3
BEGIN DECLARE SECTION
END DECLARE SECTION
PREPARE S1 INTO :p_da0 FROM :p_stment
PREPARE S2 INTO :p_da0 FROM :p_stment
PREPARE S3 INTO :p_da0 FROM :p_stment
PREPARE S4 INTO :p_da0 FROM :p_stment
PREPARE S5 INTO :p_da0 FROM :p_stment
PREPARE S6 INTO :p_da0 FROM :p_stment
PREPARE S7 INTO :p_da0 FROM :p_stment
PREPARE S8 INTO :p_da0 FROM :p_stment
PREPARE S9 INTO :p_da0 FROM :p_stment
PREPARE S10 INTO :p_da0 FROM :p_stment
DESCRIBE S1 INTO :p_da1
DESCRIBE S2 INTO :p_da1
DESCRIBE S3 INTO :p_da1
DESCRIBE S4 INTO :p_da1
DESCRIBE S5 INTO :p_da1
DESCRIBE S6 INTO :p_da1
DESCRIBE S7 INTO :p_da1
DESCRIBE S8 INTO :p_da1
DESCRIBE S9 INTO :p_da1
DESCRIBE S10 INTO :p_da1
DECLARE C1 CURSOR FOR S1
DECLARE C2 CURSOR FOR S2
DECLARE C3 CURSOR FOR S3
DECLARE C4 CURSOR FOR S4
DECLARE C5 CURSOR FOR S5
DECLARE C6 CURSOR FOR S6
DECLARE C7 CURSOR FOR S7
DECLARE C8 CURSOR FOR S8
DECLARE C9 CURSOR FOR S9
DECLARE C10 CURSOR FOR S10
OPEN C1 USING DESCRIPTOR :p_da2
OPEN C2 USING DESCRIPTOR :p_da2
OPEN C3 USING DESCRIPTOR :p_da2
OPEN C4 USING DESCRIPTOR :p_da2
OPEN C5 USING DESCRIPTOR :p_da2
OPEN C6 USING DESCRIPTOR :p_da2
OPEN C7 USING DESCRIPTOR :p_da2
OPEN C8 USING DESCRIPTOR :p_da2
OPEN C9 USING DESCRIPTOR :p_da2
OPEN C10 USING DESCRIPTOR :p_da2
FETCH C1 USING DESCRIPTOR :p_da1
FETCH C2 USING DESCRIPTOR :p_da1
FETCH C3 USING DESCRIPTOR :p_da1
FETCH C4 USING DESCRIPTOR :p_da1
FETCH C5 USING DESCRIPTOR :p_da1
FETCH C6 USING DESCRIPTOR :p_da1
FETCH C7 USING DESCRIPTOR :p_da1
FETCH C8 USING DESCRIPTOR :p_da1
FETCH C9 USING DESCRIPTOR :p_da1
FETCH C10 USING DESCRIPTOR :p_da1
CLOSE C1
CLOSE C2
CLOSE C3
CLOSE C4
CLOSE C5
CLOSE C6
CLOSE C7
CLOSE C8
CLOSE C9
CLOSE C10
EXECUTE S1 USING DESCRIPTOR :p_da2
EXECUTE S2 USING DESCRIPTOR :p_da2
EXECUTE S3 USING DESCRIPTOR :p_da2
EXECUTE S4 USING DESCRIPTOR :p_da2
EXECUTE S5 USING DESCRIPTOR :p_da2
EXECUTE S6 USING DESCRIPTOR :p_da2
EXECUTE S7 USING DESCRIPTOR :p_da2
EXECUTE S8 USING DESCRIPTOR :p_da2
EXECUTE S9 USING DESCRIPTOR :p_da2
EXECUTE S10 USING DESCRIPTOR :p_da2
EXECUTE IMMEDIATE :p_stment
COMMIT
ROLLBACK
p_stment