Saved Bookmarks
| 1. |
Solve : Help needed in making a program or any batch file? |
|
Answer» 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.There is a REPLY to this question on the DOS board. Please do not double post, it causes much confusion and gets the natives very restless. |
|