RE: [U2] Indexes have disappeared

[JPB-U2UG]

What was your old revision? If this was changed then it was changed for the
worst.

Jerry Banker
Senior Programmer Analyst
IBM Certified Solutions Expert

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Friday, April 25, 2008 4:12 PM
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/
directory.name), which didn't match our other system.

So now we do a SET.INDEX every day after the copy from computer A to
computer B.

Fun.

-- Louie in Seattle


<http://directory.name>
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes have disappeared

[Louie Bergsagel]

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 every day after the copy from computer A to
computer B.

Fun.

-- Louie in Seattle



---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes have disappeared

[John Jenkins]

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/

Re: [U2] Indexes have disappeared

[Richard Nuckolls]

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, and  
recently
noticed that UniVerse is no longer recognizing the indexes even  
though they

are copied along with the files.

We recently upgraded to UniVerse 10.2.7 (Pick syntax)

Has anybody heard of this weirdness?

-- Louie in Seattle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes have disappeared

[JPB-U2UG]

As far as I know it's always worked that way. Question, the copies you made
before, were they on the same system? If so you were using the same indices
for both your live and copied data. Usually this causes some strange results
when using the indices.

Jerry Banker
Senior Programmer Analyst
IBM 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 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 list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes have disappeared

[iggchamp]

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 - Information 
> Management Software 
> U2 Support Architect b IBM U2 
> Client Support Team 
> 4700 S. Syracuse St., Denver, CO 
> 80237 
> Tel: (303) 773-7969 T/L 
> 656-7969 
> Mobile: (303) 807-6222 
> [EMAIL PROTECTED] 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> "Louie Bergsagel" 
> > mail.com> To 
> Sent by: U2 
> [EMAIL PROTECTED] cc 
> stserver.u2ug.org 
> Subject 
> [U2] Indexes have disappeared 
> 04/22/2008 04:12 
> PM 
> 
> 
> Please respond to 
> [EMAIL PROTECTED] 
> er.u2ug.org 
> 
> 
> 
> 
> 
> 
> We use flashcopy to move data from one computer to another, and recently 
> noticed that UniVerse is no longer recognizing the indexes even though they 
> are copied along with the files. 
> 
> We recently upgraded to UniVerse 10.2.7 (Pick syntax) 
> 
> Has anybody heard of this weirdness? 
> 
> -- Louie in Seattle 
> --- 
> u2-users mailing list 
> u2-users@listserver.u2ug.org 
> To unsubscribe please visit http://listserver.u2ug.org/ 
> 
> [demime 1.01d removed an attachment of type image/gif which had a name of 
> 28996336.gif] 
> 
> [demime 1.01d removed an attachment of type image/gif which had a name of 
> graycol.gif] 
> 
> [demime 1.01d removed an attachment of type image/gif which had a name of 
> pic09707.gif] 
> 
> [demime 1.01d removed an attachment of type image/gif which had a name of 
> ecblank.gif] 
> --- 
> u2-users mailing list 
> u2-users@listserver.u2ug.org 
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes have disappeared

[David Murray]

Louie,

Within each file 'header' is a pointer to the index file. It is stored as a
full path name (unless specified otherwise). If the account is moved and the
file paths change, then the link/pointer to the index file will break (no
longer point to the index file).

The SET.INDEX enables you to reset the pointer/link back to the index file.

For more info, see the latest UniVerse User Reference manual, pages 1-488 to
1-490.

Cheers,

David Murray
 


*   
Learn and do 
*   Excel and share 
 
http://u2blog.org

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[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 upgrade?

-- Louie
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes have disappeared

[Hona, David S]

If not an identical pathname now, it would simply mean you had an old
index at the same pathname previously. Now it appears you don't. Index
broken - 'cause index is not there. Very common problem in UV. 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf 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 at 4:32 PM, Wally Terhune <[EMAIL PROTECTED]>
wrote:

> Identical file system path to the files and indexes?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes have disappeared

[Louie Bergsagel]

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 list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes have disappeared

[Louie Bergsagel]

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/

RE: [U2] Indexes have disappeared

[Hona, David S]

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] On Behalf Of Louie Bergsagel
Sent: Wednesday, 23 April 2008 8:13 AM
To: U2
Subject: [U2] Indexes have disappeared

We use flashcopy to move data from one computer to another, and recently
noticed that UniVerse is no longer recognizing the indexes even though
they are copied along with the files.

We recently upgraded to UniVerse 10.2.7 (Pick syntax)

Has anybody heard of this weirdness?

-- Louie in Seattle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes have disappeared

[Wally Terhune]

Identical file system path to the files and indexes?
   
 Wally Terhune 
 SWG Client Support - Information  
 Management Software   
 U2 Support Architect b IBM U2 
 Client Support Team   
 4700 S. Syracuse St., Denver, CO  
 80237 
 Tel: (303) 773-7969   T/L 
 656-7969  
 Mobile: (303) 807-6222
 [EMAIL PROTECTED] 
   
   
   








   
 "Louie Bergsagel" 
 <[EMAIL PROTECTED] 
 mail.com>  To 
 Sent by:  U2
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] Indexes have disappeared   
 04/22/2008 04:12  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




We use flashcopy to move data from one computer to another, and recently
noticed that UniVerse is no longer recognizing the indexes even though they
are copied along with the files.

We recently upgraded to UniVerse 10.2.7 (Pick syntax)

Has anybody heard of this weirdness?

-- Louie in Seattle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type image/gif which had a name of 
28996336.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
pic09707.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
ecblank.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes have disappeared

[iggchamp]

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 though they 
> are copied along with the files. 
> 
> We recently upgraded to UniVerse 10.2.7 (Pick syntax) 
> 
> Has anybody heard of this weirdness? 
> 
> -- Louie in Seattle 
> --- 
> u2-users mailing list 
> u2-users@listserver.u2ug.org 
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Eric Armstrong]

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 for a monthly news Letter about the Merge
List process.  That might help with your situation, take a look.

http://www.ashwoodcomputer.com/TechTip.html

This is not an ad for Ashwood Computer Company

Tom Dodds
[EMAIL PROTECTED]
630.235.2975


-Original 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 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 March 2008 10:04
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes

My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out, 
eg
I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
head read, but the repairs file only has the stock code as a reference in
the record. I have indexed the repair file on stock code, and need to create
a report on the stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/





LOBEL FINANCIAL PRIVACY NOTICE: 
This communication may contain confidential company information that is 
protected by federal law. Federal regulations prohibit the disclosure (or 
re-disclosure) of confidential information without the written consent of the 
person(s) to whom it pertains. Additionally, the views or opinions presented in 
this email are solely those of the author and do not necessarily represent 
those of the company.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Tom Dodds]

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!

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:38:08 -0500
> 
> 
> I recently put together a Tech Tip for a monthly news Letter about 
> the Merge List process.  That might help with your situation, take 
> a look.
> 
> http://www.ashwoodcomputer.com/TechTip.html
> 
> This is not an ad for Ashwood Computer Company
> 
> Tom Dodds
> [EMAIL PROTECTED]
> 630.235.2975
> 
> 

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Ray Wurlod]

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:38:08 -0500
> 
> 
> I recently put together a Tech Tip for a monthly news Letter about 
> the Merge List process.  That might help with your situation, take 
> a look.
> 
> http://www.ashwoodcomputer.com/TechTip.html
> 
> This is not an ad for Ashwood Computer Company
> 
> Tom Dodds
> [EMAIL PROTECTED]
> 630.235.2975
> 
> 

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Anthony Youngman]

Ah...

If that's what you want, then in BASIC

SELECTINDEX "STOCK.ID" FROM F.REPAIR

Should have exactly the same effect (and save the overhead of an EXECUTE). The 
only difference is the resulting select list may not be sorted (although I 
think it is).

If you then want to find what records 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! 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Jerry Banker]

Keep it simple! In a program you can use SELECTINDEX and from a command
line use SELECT with the SAVING UNIQUE keywords.

Jerry Banker

> -Original Message-
> From: Scott Ballinger [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 14, 2008 9:22 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [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 to records in file FV
> than
> "match" ID in FIELDNAME.
> BVAL  is the value of the indexed attribute that matches ID. If there
> was no
> match, then BVAL will be the next indexed value past ID, so I always
> test if
> BVAL = ID.
> FV is the open file variable to the indexed file.
> ID is the value you are searching for in the indexed FIELDNAME.
> FIELDNAME is the name of the indexed fields in FV (e.g. CREATE.INDEX
> MYFILE
> FIELDNAME).
> 
> A "BY SEQ" clause is optional, SEQ is either "A" or "D" for ascending
> or
> descending, (ascending is the default).
> 
> See HELP BASIC BSCAN
> 
> I usually loop on BSCAN until BVAL NE ID. I am not sure if that is
> always
> necessary.
> 
> I use I-types that incorporate BSCAN to return values from indexed
> files all
> the time. It works great.
> 
> /Scott Ballinger
> Pareto Corporation
> Edmonds WA USA
> 206 713 6006
> 
> 
> On Fri, Mar 14, 2008 at 3:03 AM, Dennis Bartlett
> <[EMAIL PROTECTED]>
> wrote:
> 
> > My dumb question for the day (just cant remember how to... and the
> > manual's
> > example is too simplistic...)
> >
> > How do I programmatically get an index value out,
> > eg
> > I have a STOCK file, and a REPAIRS file. Whoever designed this needs
> their
> > head read, but the repairs file only has the stock code as a
> reference in
> > the record. I have indexed the repair file on stock code, and need
to
> > create
> > a report on the stock file of how many items are under repair.
> >
> > 1. UniverseBASIC code?
> >
> > 2. is this possible from an Itype?
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[David Murray]

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 STOCK key/code.

It would be a good idea to cache the file open using one of the methods
which was discussed some months ago in this mail list.

Cheers,

David Murray


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Friday, March 14, 2008 6:04 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes

My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out, eg I have a STOCK file,
and a REPAIRS file. Whoever designed this needs their head read, but the
repairs file only has the stock code as a reference in the record. I have
indexed the repair file on stock code, and need to create a report on the
stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Brutzman, Bill]

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"

 done = false  
  loop
readnext Invoice.ID else done = true
  until done do

read R.Repairs from F.Repairs, Repair.ID  else  R.Repairs = ''
  Bin.Location.ID = R.Repairs<7>

read R.Stock from F.Stock, Bin.Location.ID  else  R.Stock = ''
  Part.Nbr = R.Stock<12>

read R.Item from F.Item.Master, Part.Nbr  else  R.Item = ''
  Part.Desc = R.Item<17>

Print.Str  = Repair.ID'L#11' 
Print.Str := Part.Nbr 'L#6'  : '  '
Print.Str := Part.Desc'L#22' : '  '
Print.Str := Bin.Location 'L#6'
  print Print.Str

  R.This  = Repair.ID : VM
  R.This := Part.Nbr

locate R.This in Repair.Array<1>   by 'AL'  setting pos else null
insR.This before Repair.Array

repeat


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dennis Bartlett
Sent: Friday, March 14, 2008 6:04 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes


My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out, 
eg
I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
head read, but the repairs file only has the stock code as a reference in
the record. I have indexed the repair file on stock code, and need to create
a report on the stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes

[Scott Ballinger]

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 than
"match" ID in FIELDNAME.
BVAL  is the value of the indexed attribute that matches ID. If there was no
match, then BVAL will be the next indexed value past ID, so I always test if
BVAL = ID.
FV is the open file variable to the indexed file.
ID is the value you are searching for in the indexed FIELDNAME.
FIELDNAME is the name of the indexed fields in FV (e.g. CREATE.INDEX MYFILE
FIELDNAME).

A "BY SEQ" clause is optional, SEQ is either "A" or "D" for ascending or
descending, (ascending is the default).

See HELP BASIC BSCAN

I usually loop on BSCAN until BVAL NE ID. I am not sure if that is always
necessary.

I use I-types that incorporate BSCAN to return values from indexed files all
the time. It works great.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006


On Fri, Mar 14, 2008 at 3:03 AM, Dennis Bartlett <[EMAIL PROTECTED]>
wrote:

> My dumb question for the day (just cant remember how to... and the
> manual's
> example is too simplistic...)
>
> How do I programmatically get an index value out,
> eg
> I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
> head read, but the repairs file only has the stock code as a reference in
> the record. I have indexed the repair file on stock code, and need to
> create
> a report on the stock file of how many items are under repair.
>
> 1. UniverseBASIC code?
>
> 2. is this possible from an Itype?
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Dennis Bartlett]

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/

RE: [U2] Indexes

[Tom Dodds]

I recently put together a Tech Tip for a monthly news Letter about the Merge 
List process.  That might help with your situation, take a look.

http://www.ashwoodcomputer.com/TechTip.html

This is not an ad for Ashwood Computer Company

Tom Dodds
[EMAIL PROTECTED]
630.235.2975


-Original 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 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 March 2008 10:04
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes

My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out, 
eg
I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
head read, but the repairs file only has the stock code as a reference in
the record. I have indexed the repair file on stock code, and need to create
a report on the stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Brian Leach]

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 recommending but that happens to work rather well
:)
The index is actually just a type 25 file with simple inverted records (key
= indexed values, fields = key of records under the index). If you can find
which of the index.nnn files in the I_filename directory is that index
(should match the order they appear in the LIST.INDEX statement), you can
just create a file pointer to it. Or, if you want to be safer, use an
OpenPath in BASIC and hold the pointer in named common...

Brian

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Dennis Bartlett
> Sent: 14 March 2008 10:04
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Indexes
> 
> My dumb question for the day (just cant remember how to... 
> and the manual's example is too simplistic...)
> 
> How do I programmatically get an index value out, eg I have a 
> STOCK file, and a REPAIRS file. Whoever designed this needs 
> their head read, but the repairs file only has the stock code 
> as a reference in the record. I have indexed the repair file 
> on stock code, and need to create a report on the stock file 
> of how many items are under repair.
> 
> 1. UniverseBASIC code?
> 
> 2. is this possible from an Itype?
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Indexes

[Raul_Dominguez]

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: 
Subject: [U2] Indexes



My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out, 
eg
I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
head read, but the repairs file only has the stock code as a reference in
the record. I have indexed the repair file on stock code, and need to create
a report on the stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Anthony Youngman]

I'd use basic.

When I used it (yonks ago) I thought the manual was reasonably clear. The basic 
command takes two arguments. The first is the index name, and if that's all you 
supply it returns a list of the index values. The second is the index value, 
and if you supply that as well it returns a list of all the record keys for 
that value.

HTH

Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen
Sent: 14 March 2008 10:38
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 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 March 2008 10:04
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes

My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out,
eg
I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
head read, but the repairs file only has the stock code as a reference in
the record. I have indexed the repair file on stock code, and need to create
a report on the stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes

[Symeon Breen]

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 March 2008 10:04
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes

My dumb question for the day (just cant remember how to... and the manual's
example is too simplistic...)

How do I programmatically get an index value out, 
eg
I have a STOCK file, and a REPAIRS file. Whoever designed this needs their
head read, but the repairs file only has the stock code as a reference in
the record. I have indexed the repair file on stock code, and need to create
a report on the stock file of how many items are under repair.

1. UniverseBASIC code?

2. is this possible from an Itype?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes on distributed files

[Perry Taylor]

Mac,

If the index value you are wanting to lookup is the exact value in the
record you can use SELECTINDEX.  However, you cannot do partial matches
this way.  For example, let's say you have an index on LAST.NAME in the
CUST file, and you are looking for any records with the last name of
TAYLOR...

OPEN 'CUST' TO F.CUST ELSE STOP 201,'CUST'

SELECTINDEX 'LAST.NAME', 'TAYLOR' FROM F.CUST

LOOP WHILE READNEXT CUST.ID DO
...
REPEAT

But if you wanted to get any cust record with LAST.NAME starting with
"T".  You cannot use SELECTINDEX and will have to query instead...

OPEN 'CUST' TO F.CUST ELSE STOP 201,'CUST'

EXECUTE 'SELECT CUST WITH LAST.NAME "T]"' CAPTURING OUTPUT

LOOP WHILE READNEXT CUST.ID DO
...
REPEAT

Your only other option is to write logic that will query each individual
part file and collate the results... Not a trivial routine.  You might
contact IBM/U2 Professional Services.  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 files

Hi,

Thanks for the reply - do you know how I can use indexes on distributed
files ?

Thanks

Mac 

-Original Message-
From: Perry Taylor [mailto:[EMAIL PROTECTED]
Sent: 22 March 2006 04:06 PM
To: Mac Bhyat; u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes on distributed files

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 having the following problem with indexes on a distributed file 
 
Scenario - I have a distributed file split by years - 1997 (1) 1998 = 2
1999 = 3
 
I create an index on the main file, and build the index (this creates
index files for each part file on the filesystem)
 
Now i'm trying to do a bscan on the main file, using the USING clause
(with the index I just created) and I'm getting a status error 3 - (file
is not a type 25, or no secondary indices defined)
 
The platform is Universe 9.6.2 - UNIX
 
Can BSCAN's be done on a main controlling file for a distributed file,
if so how ?
 
Thanks
 
Mac
--
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/




--
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/




--
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Indexes on distributed files

[Perry Taylor]

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 having the following problem with indexes on a distributed file 
 
Scenario - I have a distributed file split by years - 1997 (1) 1998 = 2
1999 = 3
 
I create an index on the main file, and build the index (this creates
index files for each part file on the filesystem)
 
Now i'm trying to do a bscan on the main file, using the USING clause
(with the index I just created) and I'm getting a status error 3 - (file
is not a type 25, or no secondary indices defined)
 
The platform is Universe 9.6.2 - UNIX
 
Can BSCAN's be done on a main controlling file for a distributed file,
if so how ?
 
Thanks
 
Mac
--
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Re: U2 Indexes

[Moderator]

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 which had a name of 
u2ug.vcf]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/