Re: [U2] More questions on indexing

[George Gallen]

These are really annoying when you go to recover data from a tar'd
tape. Not realizing, you xvf the actual name, only to realize a
an hour later, you didn't use the truncated 'real' name it's stored
under the backup as!!

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
> Sent: Friday, July 17, 2009 12:05 PM
> To: U2 Users List
> Subject: Re: [U2] More questions on indexing
>
> This cries for a ICONV / OCONV code:
>
> George Gallen wrote:
> > In our case, we would also have to build a cross reference to all the
> > 'F' VOC's whose actual filenames are different from their ID's, since
> > we have a lot of longer filenames with truncated unix filenames.
> >
> > Or is there a system cross reference file already setup we could tap.
> >
> I wrote a "user-exit" style OCONV/ICONV  that will convert unix
> filenames to/from Universe names.
> It's mostly to handle the slashes, backslashes, question marks, etc.
> that are legal in UV but illegal UV.
> Works for filenames and type-19 "item" ids.
>
> It could be made to handles longname/shortname (type-1 vs -19)
> differences, too.
> I avoid the hated archaic type-1, so just always use type-19 &
> longnames
> on..
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Charles Stevenson]

This cries for a ICONV / OCONV code:

George Gallen wrote:

In our case, we would also have to build a cross reference to all the
'F' VOC's whose actual filenames are different from their ID's, since
we have a lot of longer filenames with truncated unix filenames.

Or is there a system cross reference file already setup we could tap.
  
I wrote a "user-exit" style OCONV/ICONV  that will convert unix 
filenames to/from Universe names.
It's mostly to handle the slashes, backslashes, question marks, etc. 
that are legal in UV but illegal UV.

Works for filenames and type-19 "item" ids.

It could be made to handles longname/shortname (type-1 vs -19) 
differences, too.
I avoid the hated archaic type-1, so just always use type-19 & longnames 
on..


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Charles Stevenson]

One more thing that we do. We build a database of our indexes every
night using a 'cron'. It does a 
find / \( -name 'idx001' -o -name 'X_*' \) at a UNIX level.
UV's SET.INDEX INFORM acting on an active select list of F- & Q-pointers 
will give you somethiong similar.
Contrary to syntax listed in UV's documentation, where "filename" seems 
to be necessary:

 "SET.INDEX [ DICT ] filename [ TO [ pathname | NULL ] ] [ options ]"

E.g.:
  >MAKE.LIST CUSTOMERS VOC ORDERS
  3 record(s) selected to select list 0.
  >> SET.INDEX INFORM
  Indices for file "CUSTOMERS" reside in "C:/UV/CDS/I_CUSTOMERS".
 
  File VOC has no secondary indices.
 
  Indices for file "ORDERS" reside in "C:/UV/CDS/I_ORDERS".
 
  >


I sometimes do this ad hoc:
  COMO ON CDS
  SELECTF
  SET.INDEX INFORM
  COMO OFF
  ED &COMO& CDS
 L Indices for file

Chuck Stevenson


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[George Gallen]

nice idea,

In our case, we would also have to build a cross reference to all the
'F' VOC's whose actual filenames are different from their ID's, since
we have a lot of longer filenames with truncated unix filenames.

Or is there a system cross reference file already setup we could tap.

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K
> Sent: Thursday, July 16, 2009 5:10 PM
> To: U2 Users List
> Subject: Re: [U2] More questions on indexing
>
>  One more thing that we do. We build a database of our indexes every
> night using a 'cron'. It does a
> find / \( -name 'idx001' -o -name 'X_*' \) at a UNIX level.
>
> The results of this 'find' are then passed into a Unidata program.
> Using
> a combination of LIST.INDEX and INDICES we get all the info we need to
> build the index and write a record to a database using the FILE.NAME as
> the key. We then have a process to rebuild indexes using this database.
> So if I want to re-build an index. I just type REBUILD.INDEX file name
> and everything gets redone. This is really nice for when you have a
> file
> with 10 indexes and you want to rebuild it. -Rod
>
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Anthony W. Youngman]

In message 
, 
bradley.sch...@usbank.com writes

Thanks, Rod. One more thing. I've written a test program to simplify index
creation and building. When I run it under type U or type P using
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to
continue..." prompt after each screen of *'s. Definitely not desirable for
an automated process. It doesn't do this at TCL.

How can I work around this? I'd rather not throw a bunch of DATA
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'

iirc, UniVerse has the NO.PAGE keyword. Does UniData have it? And if so, 
does it work for BUILD.INDEX?


Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Don Verhagen]

In Unidata (v6.x) you can issue the command BUILD.INDEX MYFILE ALL. With the
KEYWORD ALL it's builds/rebuilds all the indexes that have been created on
the file.  I would hate to have to remember that INDEX_1 is say, Customer
Name, verus a dictionary named CUST_NAME.

I would agree with others, I rarely had any need to rebuild any indexes with
Unidata, other than part of a file resizing/space considerations.

Donald Verhagen
People 2.0

 



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
> Bill Haskett
> Sent: Thursday, July 16, 2009 4:52 PM
> To: U2 Users List
> Subject: Re: [U2] More questions on indexing
> 
> Brad:
> 
> I've defined indexes in my files with dictionary items like 
> "INDEX_1", 
> etc.  Thus only these dictionaries are ever used for 
> indexing.  A file 
> may have 4 or 5 indexes (INDEX_1 - INDEX_4).
> 
> I wrote another program to do the indexing for a single file or an 
> entire account by executing the command...
> 
> :ACCT-INDEX  CUSTFILE  -IINDEX_
> 
> ...which will create all the indexes on the CUSTFILE.  Also, my 
> dictionary listing will show these indexes separately so it 
> looks like:
> 
> Dictionary of File: APPO  
> 13:48:38 Jul 16 2009
> Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt 
> Assoc...
> 
> @UQ Phr   VENDNO CLIEN
>   TNO DISSUE A
>   UTH DESCT DC
>   LOSED
> INDEX_1 Indx  IF DCLOSED N
>   18L   S
>   E "" THEN CL
>   IENTNO "R(%4
>   )" : UNITNO
>   "R(%7)" : SE
>   QNO "R(%7)"
> @ID D 0   APPO
>   6RS
> PONOD 0   PO# 
>   7RS
> VENDNO  D 1   VEND#   
>   5RS
> CLIENTNOD 2   CLNT
>   4RS
> 
> 
> We don't normally rebuild indexes on UD v7.1 or v7.2.
> 
> HTH,
> 
> Bill
> 
> --
> --
> bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM:
> > Thanks, Rod. One more thing. I've written a test program to 
> simplify index 
> > creation and building. When I run it under type U or type P using 
> > BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
> > continue..." prompt after each screen of *'s. Definitely 
> not desirable for 
> > an automated process. It doesn't do this at TCL. 
> >
> > How can I work around this? I'd rather not throw a bunch of DATA 
> > statements in there.
> >
> >
> > EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
> > DATA 20
> > EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
> > EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'
> >
> >
> > TIA,
> > Brad.
> >
> >   
> >> Please respond to U2 Users List
> >>
> >>  I think Oracle's indexing scheme is much more complicated that
> >> Unidata's, so I don't think you can compare the two. I do 
> rebuild some
> >> of the dynamic files on occasion to get some space back. Other than
> >> that, I leave them alone and haven't had problems. - Rod
> >>
> >> 
> >
> >
> >   
> >> Research continues and I have more question for the group: 
> my Oracle 
> >> buddies rebuild their indexes at least weekly. Seems to be a best 
> >> practice. Seems odd to not be able to trust that your 
> index is correct.
> >> Is 
> >> this a concern for ud 7.1? 
> >>
> >> TIA,
> >> Brad.
> >>
> >> ud 7.1
> >> AIX 5.3
> >> U.S. BANCORP made the following annotations
> >> 
> >
> > U.S. BANCORP made the following annotations
> > 
> -
> > Electronic Privacy Notice. This e-mail, and any 
> attachments, contains information that is, or may be, covered 
> by electronic communications privacy laws, and is also 
> confidential and proprietary in nature. If you are not the 
> intended recipient, ple

Re: [U2] More questions on indexing

[Baakkonen, Rodney A (Rod) 46K]

 One more thing that we do. We build a database of our indexes every
night using a 'cron'. It does a 
find / \( -name 'idx001' -o -name 'X_*' \) at a UNIX level.

The results of this 'find' are then passed into a Unidata program. Using
a combination of LIST.INDEX and INDICES we get all the info we need to
build the index and write a record to a database using the FILE.NAME as
the key. We then have a process to rebuild indexes using this database.
So if I want to re-build an index. I just type REBUILD.INDEX file name
and everything gets redone. This is really nice for when you have a file
with 10 indexes and you want to rebuild it. -Rod


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: Thursday, July 16, 2009 3:25 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

 I usually do a TERM 132,999

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is
correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Bill Haskett]

Brad:

I've defined indexes in my files with dictionary items like "INDEX_1", 
etc.  Thus only these dictionaries are ever used for indexing.  A file 
may have 4 or 5 indexes (INDEX_1 - INDEX_4).


I wrote another program to do the indexing for a single file or an 
entire account by executing the command...


:ACCT-INDEX  CUSTFILE  -IINDEX_

...which will create all the indexes on the CUSTFILE.  Also, my 
dictionary listing will show these indexes separately so it looks like:


Dictionary of File: APPO  13:48:38 Jul 16 2009
Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt 
Assoc...


@UQ Phr   VENDNO CLIEN
 TNO DISSUE A
 UTH DESCT DC
 LOSED
INDEX_1 Indx  IF DCLOSED N  18L   S
 E "" THEN CL
 IENTNO "R(%4
 )" : UNITNO
 "R(%7)" : SE
 QNO "R(%7)"
@ID D 0   APPO  6RS
PONOD 0   PO#   7RS
VENDNO  D 1   VEND# 5RS
CLIENTNOD 2   CLNT  4RS


We don't normally rebuild indexes on UD v7.1 or v7.2.

HTH,

Bill


bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM:
Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.



EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

  

Please respond to U2 Users List

 I think Oracle's indexing scheme is much more complicated that
Unidata's, so I don't think you can compare the two. I do rebuild some
of the dynamic files on occasion to get some space back. Other than
that, I leave them alone and haven't had problems. - Rod





  
Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct.
Is 
this a concern for ud 7.1? 


TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations



U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[David A. Green]

TERM 132,0 should work too.

Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney
A (Rod) 46K
Sent: Thursday, July 16, 2009 1:25 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

 I usually do a TERM 132,999

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is
correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[David A. Green]

Any PRINT @ will turn off automatic pagination.  You can also use BPIOCPN.

Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 1:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank
you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Baakkonen, Rodney A (Rod) 46K]

 I usually do a TERM 132,999

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is
correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Mark Eastwood]

Try adding "CAPTURING TRASH" to the end of your EXECUTE statements.

Mark

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 1:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Israel, John R.]

In your program, do a CRT @(-1) at the top of the program to disable the paging.

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 4:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Doug]

Brad,

We have a client with over 3 million records with 14 indices running on
Unidata 7.2.  We have never rebuilt the indexes in over two years.  The last
time we rebuilt them we added some 2 more indexes.  We just purged about a
1/2 million records with no problems on the indexes that are used everyday
from our Web data entry and reports forms.

Regards,
Doug
www.u2logic.com  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney
A (Rod) 46K
Sent: Thursday, July 16, 2009 2:07 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

 I think Oracle's indexing scheme is much more complicated that Unidata's,
so I don't think you can compare the two. I do rebuild some of the dynamic
files on occasion to get some space back. Other than that, I leave them
alone and haven't had problems. - Rod

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:00 PM
To: U2 Users List
Subject: [U2] More questions on indexing

Research continues and I have more question for the group: my Oracle buddies
rebuild their indexes at least weekly. Seems to be a best practice. Seems
odd to not be able to trust that your index is correct.
Is
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank
you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users






--
CONFIDENTIALITY NOTICE: If you have received this email in error, please
immediately notify the sender by e-mail at the address shown.  This email
transmission may contain confidential information.  This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly.  Please delete it from your files if
you are not the intended recipient.  Thank you for your compliance.
Copyright 2009 CIGNA

==

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Mark Eastwood]

It's probably for performance - when a table has lots of
inserts/deletions the index gets "fragmented".


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 1:00 PM
To: U2 Users List
Subject: [U2] More questions on indexing

Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct.
Is 
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[bradley . schrag]

Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Baakkonen, Rodney A (Rod) 46K]

 I think Oracle's indexing scheme is much more complicated that
Unidata's, so I don't think you can compare the two. I do rebuild some
of the dynamic files on occasion to get some space back. Other than
that, I leave them alone and haven't had problems. - Rod

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:00 PM
To: U2 Users List
Subject: [U2] More questions on indexing

Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct.
Is 
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





--
CONFIDENTIALITY NOTICE: If you have received this email in error, please 
immediately notify the sender by e-mail at the address shown.  This email 
transmission may contain confidential information.  This information is 
intended only for the use of the individual(s) or entity to whom it is intended 
even if addressed incorrectly.  Please delete it from your files if you are not 
the intended recipient.  Thank you for your compliance.  Copyright 2009 CIGNA
==

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] More questions on indexing

[bradley . schrag]

Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct. Is 
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users