home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: InfoMgt
/
InfoMgt.zip
/
dclgen.zip
/
IBMSDBTL.BND
(
.txt
)
< prev
next >
Wrap
DB2 Bind
|
1998-04-20
|
676b
|
20 lines
IBMSDBTLNBz3IOLKUSERID 0
BEGIN DECLARE SECTION
END DECLARE SECTION
INCLUDE SQLCA
WHENEVER SQLERROR goto L1
WHENEVER SQLWARNING goto L1
WHENEVER NOT FOUND GO TO L2
CONNECT TO :DG_DBNAME
PREPARE ZNAME FROM :ZSQLSTMT
DECLARE c1 CURSOR FOR ZNAME
OPEN c1 USING :USERID
FETCH c1 INTO :TABLENAME
CLOSE c1
CONNECT RESET
WHENEVER SQLERROR CONTINUE
ZSQLSTMT
DG_DBNAME
USERID
TABLENAME