Home / Software / Computer programming / Help needed in making a program or any batch file
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] - (Bottom) Print
Author Topic: Help needed in making a program or any batch file  (Read 859 times)
anshu
Guest
« on: April 20, 2007, 12:44:13 AM »

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.
IP logged
Sidewinder
Guru



Thanked: 97
Posts: 4,341

Experience: Familiar
OS: Windows 7

« Reply #1 on: April 20, 2007, 05:01:39 AM »

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.

 8)
« Last Edit: April 20, 2007, 06:24:44 AM by Sidewinder » IP logged

If you don't know where you are going, any road will get you there

                                                                            -Lewis Carroll
Pages: [1] - (Top) Print 
Home / Software / Computer programming / Help needed in making a program or any batch file « previous next »
 


Login with username, password and session length

Old Forum Search | Forum Rules
Copyright © 2010 Computer Hope ® All rights reserved.
Powered by SMF 2.0 RC3 | SMF © 2006–2010, Simple Machines LLC
Page created in 0.098 seconds with 20 queries.