I just found out that the original indexes had a virtual path (correct
terminology?) (../directory.name), which didn't work with the new version of
UniVerse (10.2.7), so our vendor changed them to a physical path (u2/
directory.name), which didn't match our other system.
So now we do a SET.INDEX
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexes have disappeared
I just found out that the original indexes had a virtual path (correct
terminology?) (../directory.name), which didn't work with the new version of
UniVerse (10.2.7), so our vendor changed them to a physical path (u2
Certified Solutions Expert
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Tuesday, April 22, 2008 7:06 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexes have disappeared
No, but how could it have worked
Are the file systems truly identical, or are you using symbolic links
to make them look the same?
Use SET.INDEX filename INFORM
to see where your index is really pointing.
-Rick
On Apr 22, 2008, at 3:12 PM, Louie Bergsagel wrote:
We use flashcopy to move data from one computer to another,
Otherwise - did you make any changes to the indexes and copy the files
while the change was In progress?
Regards
JayJay
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Hi Louie,
Did you perform a SET.INDEX after moving the data?
-- Original message --
From: Louie Bergsagel [EMAIL PROTECTED]
We use flashcopy to move data from one computer to another, and recently
noticed that UniVerse is no longer recognizing the indexes even
Identical file system path to the files and indexes?
Wally Terhune
SWG Client Support - Information
Management
You probably just need to use SET.INDEX to change the pathname to where
the index file is now located. It's been discussed lots of times in
this forum is the most common problem with indexes in UV. It's a
feature!! :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
We've never done a SET.INDEX, but the indexes used to work just fine.
I wonder if they have to be set once and they work until the next upgrade?
-- Louie
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
No, but how could it have worked before? If a SET.INDEX was required,
wouldn't it have to be executed after every copy?
We've never done that.
On Tue, Apr 22, 2008 at 4:32 PM, Wally Terhune [EMAIL PROTECTED] wrote:
Identical file system path to the files and indexes?
---
u2-users mailing
Of Louie Bergsagel
Sent: Wednesday, April 23, 2008 10:06 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexes have disappeared
No, but how could it have worked before? If a SET.INDEX was required,
wouldn't it have to be executed after every copy?
We've never done that.
On Tue, Apr 22, 2008
:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Tuesday, April 22, 2008 7:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexes have disappeared
We've never done a SET.INDEX, but the indexes used to work just fine.
I wonder if they have to be set once and they work until the next
Wasn't there some talk at one point of using relative pathnames? Is that
supported in the newer releases?
-- Original message --
From: Wally Terhune [EMAIL PROTECTED]
Identical file system path to the files and indexes?
Wally Terhune
SWG Client Support -
You can also do the same with the LIST.DIFF, LIST.UNION, LIST.INTER, etc.
commands.
Eric
-Original Message-
From: Tom Dodds [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2008 6:38 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes
I recently put together a Tech Tip
Ya left out LIST.INTER, LIST.UNION and LIST.DIFF commands!
These, admittedly, work with saved - rather than active, in-memory - Select
Lists.
- Original Message -
From: Tom Dodds [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes
Date: Fri, 14 Mar 2008 08
Got me.
Thanks
Tom Dodds
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Sunday, March 16, 2008 6:59 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes
Ya left out LIST.INTER, LIST.UNION and LIST.DIFF commands
I would use the SAVING clause on a select of the repairs file to build a list
of stock id's then use a merge list command to see what stock ids do not have a
repairs record.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: 14
At the universe tcl:
SELECT REPAIR SAVING UNIQUE STOCK.ID
Providing the the id to the STOCK file is in a field called STOCK.ID.
Raul
- Original Message -
From: Dennis Bartlett [EMAIL PROTECTED]
Sent: 03/14/2008 12:03 PM ZE2
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes
Dennis
Two more ways to do this:
1/ you can use BASIC but it's a slight pig..
The SelectIndex statement selects keys from an index. But it generates a
select list, so you need to be careful about segregating these e.g. if
calling from a SUBR() in an Idescriptor.
2/ a way I'm clearly not
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen
Sent: Friday, March 14, 2008 5:38 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes
I would use the SAVING clause on a select of the repairs file to build a list
of stock id's then use a merge list
Thanks! This is by far the easiest, and it works!
-Original Message-
[EMAIL PROTECTED] wrote:
At the universe tcl:
SELECT REPAIR SAVING UNIQUE STOCK.ID
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
There is no function like the T correlative to translate to an indexed file
from a dict item, so you will need to do in BASIC as an I-type. The command
is BSCAN, e,g.
BSCAN BVAL,ID.LIST FROM FV,ID USING FIELDNAME ELSE BVAL =
ID.LIST contains an AM delimited list of keys to records in file FV
Dennis:
I would handle it with something like the following...
-Bill
*
equate true to 1, false to 0
open 'STOCK' to F.Stockelse null
open 'REPAIRS' to F.Repairs else null
clearselect ALL
execute SELECT REPAIRS
Dennis,
Create a subr/function routine to open the REPAIRS file, use BSCAN to find
the required records (using the passed STOCK code) and then DCOUNT the BSCAN
result. You can then return this value.
Create an ITYPE dictionary field (in STOCK file) which calls this routine,
passing the required
: [U2] Indexes
There is no function like the T correlative to translate to an indexed
file
from a dict item, so you will need to do in BASIC as an I-type. The
command
is BSCAN, e,g.
BSCAN BVAL,ID.LIST FROM FV,ID USING FIELDNAME ELSE BVAL =
ID.LIST contains an AM delimited list of keys
are then associated with each stock id
SELECTINDEX STOCK.ID, STOCK.ID FROM F.REPAIR
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: 14 March 2008 13:44
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes
Thanks
Unfortunately, BSCAN is not supported on distributed files in UniVerse.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat
Sent: Wednesday, March 22, 2006 5:08 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes on distributed files
Hi,
I
. Mark Baldridge wrote something
that does this very thing and you probably can get it from them.
Hope this helps some.
Perry
-Original Message-
From: Mac Bhyat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006 7:21 AM
To: Perry Taylor
Subject: RE: [U2] Indexes on distributed
I've had some recent e-mails asking where the U2-user and U2-community
indexes can be found. Here are two good answers:
http://news.gmane.org/gmane.comp.db.u2.general/
http://www.indexinfocus.com/
- Charles Barouch, Moderator
[demime 1.01d removed an attachment of type text/x-vcard
29 matches
Mail list logo