home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
netviwdm.zip
/
RFGDBASC.BND
(
.txt
)
< prev
next >
Wrap
DB2 Bind
|
1995-04-19
|
8KB
|
109 lines
RFGDBASCcAq8PbCLNULLID 0
INCLUDE SQLCA
BEGIN DECLARE SECTION
END DECLARE SECTION
CONNECT TO :dbname IN SHARE MODE
CONNECT RESET
COMMIT WORK
ROLLBACK WORK
DECLARE C1 CURSOR FOR SELECT VARIABLE, VARTYPE, VALUE FROM RFGTABLE.GROUPVALUES WHERE CONFPG = :ConfPG AND PRODUCT = :Product
OPEN C1
FETCH C1 INTO :Variable, :VarType, :Value
INSERT INTO RFGTABLE.GROUPVALUES VALUES (:ConfPG, :Product, :Variable, :VarType, :Value)
UPDATE RFGTABLE.GROUPVALUES SET VARTYPE = :VarType, VALUE = :Value WHERE CONFPG = :ConfPG AND PRODUCT = :Product AND VARIABLE = :Variable
CLOSE C1
DECLARE C2 CURSOR FOR SELECT VARIABLE, VARTYPE, VALUE FROM RFGTABLE.LOCALVALUES WHERE WORKSTATION = :Workstation AND PRODUCT = :Product
OPEN C2
FETCH C2 INTO :Variable, :VarType, :Value
INSERT INTO RFGTABLE.LOCALVALUES VALUES (:Workstation, :Product, :Variable, :VarType, :Value)
UPDATE RFGTABLE.LOCALVALUES SET VARTYPE = :VarType, VALUE = :Value WHERE WORKSTATION = :Workstation AND PRODUCT = :Product AND VARIABLE = :Variable
CLOSE C2
SELECT STATUS INTO :Status FROM RFGTABLE.CONFPGSTATUS WHERE CONFPG = :ConfPG
SELECT MODELID INTO :ModelID FROM RFGTABLE.CONFIGUREDPGS WHERE CONFPG = :ConfPG AND PRODUCT = :Product
DECLARE C3 CURSOR FOR SELECT MODELID FROM RFGTABLE.PRODUCTS WHERE PRODUCT = :Product
OPEN C3
FETCH C3 INTO :ModelID
CLOSE C3
SELECT MODRSPFILE INTO :ModRSPFile FROM RFGTABLE.MODELS WHERE MODELID = :ModelID AND SEQNO = 1
INSERT INTO RFGTABLE.CONFIGUREDPGS (CONFPG, PRODUCT, MODELID) VALUES (:ConfPG, :Product, :ModelID)
UPDATE RFGTABLE.CONFIGUREDPGS SET MODELID = :ModelID WHERE CONFPG = :ConfPG AND PRODUCT = :Product
INSERT INTO RFGTABLE.CONFPGSTATUS (CONFPG, CONFIGURED, STATUS) VALUES (:ConfPG, CURRENT TIMESTAMP, :Status)
UPDATE RFGTABLE.CONFPGSTATUS SET CONFIGURED = CURRENT TIMESTAMP, STATUS = :Status WHERE CONFPG = :ConfPG
DECLARE C4 CURSOR FOR SELECT MODELID, TYPE, MODRSPFILE FROM RFGTABLE.MODELS WHERE SEQNO = 1
OPEN C4
FETCH C4 INTO :ModelID, :Type, :ModRSPFile
CLOSE C4
DELETE FROM RFGTABLE.MODELS WHERE MODELID = :ModelID
INSERT INTO RFGTABLE.MODELS (MODELID, TYPE, MODRSPFILE, REGISTERED, SEQNO, CONTENT) VALUES (:ModelID, :Type, :ModRSPFile, CURRENT TIMESTAMP, 0, :ModelBuffer)
DECLARE C5 CURSOR FOR SELECT MODELID FROM RFGTABLE.PRODUCTS WHERE PRODUCT = :Product
OPEN C5
FETCH C5 INTO :ModelID
CLOSE C5
DELETE FROM RFGTABLE.PRODUCTS WHERE PRODUCT = :Product AND MODELID = :ModelID
INSERT INTO RFGTABLE.PRODUCTS (PRODUCT, MODELID) VALUES (:Product, :ModelID)
DECLARE C6 CURSOR FOR SELECT PRODUCT, MODELID FROM RFGTABLE.CONFIGUREDPGS WHERE CONFPG = :ConfPG
OPEN C6
FETCH C6 INTO :Product, :ModelID
CLOSE C6
INSERT INTO RFGTABLE.WSSOFTWARE (WORKSTATION, CONFPG, CONFIGURED, STATUS) VALUES (:Workstation, :ConfPG, CURRENT TIMESTAMP, :Status)
UPDATE RFGTABLE.WSSOFTWARE SET CONFIGURED = CURRENT TIMESTAMP, STATUS = :Status WHERE WORKSTATION = :Workstation AND CONFPG = :ConfPG
INSERT INTO RFGTABLE.WSHARDWARE (WORKSTATION, MODELID, CONFIGURED, STATUS) VALUES (:Workstation, :ModelID, CURRENT TIMESTAMP, :Status)
UPDATE RFGTABLE.WSHARDWARE SET MODELID = :ModelID, CONFIGURED = CURRENT TIMESTAMP, STATUS = :Status WHERE WORKSTATION = :Workstation
SELECT MODELID INTO :ModelID FROM RFGTABLE.WSHARDWARE WHERE WORKSTATION = :Workstation
UPDATE RFGTABLE.CONFPGSTATUS SET STATUS = :Status WHERE CONFPG = :ConfPG
DELETE FROM RFGTABLE.CONFIGUREDPGS WHERE MODELID = :ModelID
DELETE FROM RFGTABLE.PRODUCTS WHERE MODELID = :ModelID
DECLARE C7 CURSOR FOR SELECT CONFPG, PRODUCT FROM RFGTABLE.CONFIGUREDPGS WHERE MODELID = :ModelID
OPEN C7
FETCH C7 INTO :ConfPG, :Product
CLOSE C7
UPDATE RFGTABLE.WSSOFTWARE SET STATUS = :Status WHERE CONFPG = :ConfPG
SELECT TYPE INTO :Type FROM RFGTABLE.MODELS WHERE MODELID = :ModelID AND SEQNO = 1
DECLARE C9 CURSOR FOR SELECT WORKSTATION FROM RFGTABLE.WSHARDWARE WHERE MODELID = :ModelID
OPEN C9
FETCH C9 INTO :Workstation
CLOSE C9
UPDATE RFGTABLE.WSHARDWARE SET STATUS = :Status WHERE WORKSTATION = :Workstation
DECLARE C8 CURSOR FOR SELECT CONFPG FROM RFGTABLE.CONFIGUREDPGS WHERE PRODUCT = :Product
OPEN C8
FETCH C8 INTO :ConfPG
CLOSE C8
DELETE FROM RFGTABLE.PRODUCTS WHERE PRODUCT = :Product
DELETE FROM RFGTABLE.CONFIGUREDPGS WHERE PRODUCT = :Product
DELETE FROM RFGTABLE.GROUPVALUES WHERE PRODUCT = :Product
DELETE FROM RFGTABLE.LOCALVALUES WHERE PRODUCT = :Product
DECLARE C10 CURSOR FOR SELECT CONFPG, STATUS FROM RFGTABLE.CONFPGSTATUS WHERE CONFPG LIKE :ConfPG
OPEN C10
FETCH C10 INTO :ConfPG, :Status
CLOSE C10
DELETE FROM RFGTABLE.WSSOFTWARE WHERE CONFPG = :ConfPG
DELETE FROM RFGTABLE.WSSOFTWARE WHERE CONFPG LIKE :ConfPG
DELETE FROM RFGTABLE.GROUPVALUES WHERE CONFPG = :ConfPG
DELETE FROM RFGTABLE.GROUPVALUES WHERE CONFPG LIKE :ConfPG
DELETE FROM RFGTABLE.CONFPGSTATUS WHERE CONFPG = :ConfPG
DELETE FROM RFGTABLE.CONFPGSTATUS WHERE CONFPG LIKE :ConfPG
DELETE FROM RFGTABLE.CONFIGUREDPGS WHERE CONFPG = :ConfPG
DELETE FROM RFGTABLE.CONFIGUREDPGS WHERE CONFPG LIKE :ConfPG
DELETE FROM RFGTABLE.LOCALVALUES WHERE WORKSTATION = :Workstation
DELETE FROM RFGTABLE.WSSOFTWARE WHERE WORKSTATION = :Workstation
DELETE FROM RFGTABLE.WSHARDWARE WHERE WORKSTATION = :Workstation
SELECT MODELID, STATUS INTO :ModelID, :Status FROM RFGTABLE.WSHARDWARE WHERE WORKSTATION = :Workstation
DELETE FROM RFGTABLE.CONFIGUREDPGS WHERE CONFPG = :ConfPG AND PRODUCT = :Product
UPDATE RFGTABLE.WSSOFTWARE SET STATUS = :Status WHERE WORKSTATION = :Workstation
DECLARE C11 CURSOR FOR SELECT CONFPG FROM RFGTABLE.CONFIGUREDPGS WHERE PRODUCT = :Product AND MODELID = :ModelID
OPEN C11
FETCH C11 INTO :ConfPG
CLOSE C11
SELECT STATUS INTO :Status FROM RFGTABLE.WSSOFTWARE WHERE WORKSTATION = :Workstation AND CONFPG = :ConfPG
dbname
ConfPG
Workstation
Product
Variable
VarType
Value
ModelID
Status
ModRSPFile
ModelBuffer