Hi All, I am new to making C or C++ 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 program or batch file which can find such indexes which are getting dropped and not getting recreated
Or any way to create such batch file ??
Kindly help...
Thanks in advance.
Anshu.