Hi All, I am new to making web programs.
Situation is that we have a word file of 7 lacs rows. In the file, simple commands of dropping indexes and then recreating them again is there. Most of the indexes are getting recreated. I need to find such indexes which are getting dropped but not getting recreated. sample of the concerned word file is as follows -
---------------------------------------------------------
DROP INDEX DATABASE.PS_SCON_ATT_LNG
;
COMMIT
;
CREATE UNIQUE INDEX DATABASE.PS_SCON_ATT_LNG ON PFPRGP.PS_SCON_ATT_LNG
(SETID,
CNTRCT_ID,
LINE_NBR,
SCHED_LINE_NBR,
FILE_EXTENSION,
DOCUMENT,
LANGUAGE_CD) USING STOGROUP PRDGROUP PRIQTY 48 SECQTY 720 CLUSTER
BUFFERPOOL BP2 CLOSE NO
;
COMMIT
;
DROP INDEX DATABASE.PS_SCON_COMPTTRS
;
COMMIT
;
CREATE INDEX DATABASE.PS_SCON_COMPTTRS ON PFPRGP.PS_SCON_COMPTTRS
(SETID,
CNTRCT_ID,
LINE_NBR,
SCHED_LINE_NBR,
COMPETITOR_CD) USING STOGROUP PRDGROUP PRIQTY 48 SECQTY 720 CLUSTER
BUFFERPOOL BP2 CLOSE NO
;
COMMIT
;
DROP INDEX DATABASE.PSASCON_CUST_CGRP
;
DROP INDEX DATABASE.PS_SCON_CUST_CGRP
;
COMMIT
;
CREATE UNIQUE INDEX DATABASE.PS_SCON_CUST_CGRP ON
PFPRGP.PS_SCON_CUST_CGRP (SETID,
CNTRCT_ID,
SOLD_TO_CUST_ID,
CUSTOMER_GROUP) USING STOGROUP PRDGROUP PRIQTY 48 SECQTY 720
CLUSTER BUFFERPOOL BP2 CLOSE NO
;
CREATE INDEX DATABASE.PSASCON_CUST_CGRP ON PFPRGP.PS_SCON_CUST_CGRP
(SETID,
SOLD_TO_CUST_ID) USING STOGROUP PRDGROUP PRIQTY 48 SECQTY 720
BUFFERPOOL BP2 CLOSE NO
;
COMMIT
;
-------------------------------------------------------------------------------------------------
Can anyone help me with any web program which can find such indexes which are getting dropped and not getting recreated
Kindly help...
Thanks in advance.
Anshu.