Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Help needed in making a web program  (Read 3504 times)

0 Members and 1 Guest are viewing this topic.

anshu

  • Guest
Help needed in making a web program
« on: April 20, 2007, 12:42:35 AM »
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.

Sidewinder



    Guru

    Thanked: 139
  • Experience: Familiar
  • OS: Windows 10
Re: Help needed in making a web program
« Reply #1 on: April 20, 2007, 04:45:16 PM »
You posted this here and you want a web solution. You posted this in Programming and wanted a C/C++ solution. You posted this in DOS and wanted a batch solution. When you finally make up your mind, please delete the duplicate posts and then perhaps someone will come along that can help you.

Duplicate posts only create confusion. They do not increase your chances of getting a response.  8)
The true sign of intelligence is not knowledge but imagination.

-- Albert Einstein

Dark Blade

  • Forum Gaming Master


  • Adviser

    Thanked: 24
    • Yes
  • Experience: Experienced
  • OS: Windows XP
Re: Help needed in making a web program
« Reply #2 on: April 20, 2007, 05:37:48 PM »
By the way, anshu, WHAT programming language is that? In all your other posts, you have the same code, but its not Batch or Web Design (I think so, at least).

And what is a lacs row?