Re: [U2] More questions on indexing

-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

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. 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

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

Re: [U2] More questions on indexing

...@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

[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

Re: [U2] More questions on indexing

-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

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 New line to continue... prompt after each screen of *'s. Definitely not desirable for an automated

Re: [U2] More questions on indexing

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

Re: [U2] More questions on indexing

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

Re: [U2] More questions on indexing

...@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

Re: [U2] More questions on indexing

: [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 New line to continue... prompt after each screen of *'s. Definitely

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

Re: [U2] More questions on indexing

: 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 New line

Re: [U2] More questions on indexing

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

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

Re: [U2] More questions on indexing

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

Re: [U2] More questions on indexing

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

Re: [U2] More questions on indexing

In message of44cc39a8.134b5a9d-on882575f5.006f2b76-862575f5.006fa...@usbank.com, 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