home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
tblcp2.zip
/
tblcop2i.bnd
(
.txt
)
< prev
next >
Wrap
DB2 Bind
|
1993-10-28
|
3KB
|
60 lines
TBLCOP2IAAGYWcKJUSERID 0
INCLUDE SQLDA
BEGIN DECLARE SECTION
END DECLARE SECTION
Prepare SINSERT From :FAKESQLSTMT
Prepare SINSERT From :FAKESQLSTMT
Prepare SUPDATE From :FAKEUSQLSTMT
Prepare SUPDATE From :FAKEUSQLSTMT
Execute Immediate :FAKESQLSTMT
Execute Immediate :FAKESQLSTMT
Commit
Execute Immediate :FAKESQLSTMT
Execute Immediate :FAKESQLSTMT
Commit
Execute Immediate :FAKESQLSTMT
Execute Immediate :FAKESQLSTMT
Commit
Execute Immediate :FAKESQLSTMT
Execute Immediate :FAKESQLSTMT
Commit
Commit
Execute SINSERT Using Descriptor :psqlda
RollBack
Execute SUPDATE Using Descriptor :pusqlda
RollBack
Prepare SCHECKSTRUCT Into :pssqlda From :FAKESQLSTMT
Prepare SCHECKSTRUCT Into :pssqlda From :FAKESQLSTMT
Prepare S1 Into :psqlda From :FAKESQLSTMT
BEGIN DECLARE SECTION
END DECLARE SECTION
BEGIN DECLARE SECTION
END DECLARE SECTION
SELECT CREATOR, NAME INTO :idxcreator, :idxname FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = :tbcreator AND TBNAME = :tbname AND UNIQUERULE = 'P'
SELECT CREATOR, NAME INTO :idxcreator, :idxname FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = :tbcreator AND TBNAME = :tbname AND UNIQUERULE = 'P'
SELECT CREATOR, NAME INTO :idxcreator, :idxname FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = :tbcreator AND TBNAME = :tbname AND UNIQUERULE = 'U'
Declare CGETKEYCOLS Cursor For SGETKEYCOLS
Prepare SGETKEYCOLS From :FAKEKSQLSTMT
Open CGETKEYCOLS Using Descriptor :pkasqlda
Fetch CGETKEYCOLS Into :colnames
Close CGETKEYCOLS
Commit
Declare CGETKEYCOLS2 Cursor For SGETKEYCOLS2
Prepare SGETKEYCOLS2 From :FAKEKSQLSTMT
Open CGETKEYCOLS2 Using Descriptor :pkasqlda
Fetch CGETKEYCOLS2 Into :colname
Fetch CGETKEYCOLS2 Into :colnames
Close CGETKEYCOLS2
Commit
FAKESQLSTMT
FAKEUSQLSTMT
colnames
colname
idxname
idxname2
tbname
idxcreator
idxcreator2
tbcreator
FAKEKSQLSTMT