(MPE) Alpha Lookup Screen Using Image B-Tree

[Blair Combs]

I tried the new access statement below with not luck:

> access viaindex MIG-CMD-NAME via MIG-CMD-NAME request MIG-CMD-NAME

I tried using a specific value in a USING option ... no good. 
Still only shows one record in the cluster.

I tried an access statement with/without a temp item request.

I tried throwing in a generic/nogeneric option with no luck. 

I double checked DBUTIL to make sure b-tree indexing was setup properly.

I ran adager to double check the DB layout. No problems.

As I wrote earlier, the following command in Quiz works great:

> choose viaindex MIG-CMD-NAME MIG-CMD-NAME parm

A "build detail list" shows a good for loop in the find procedure:

> PROCEDURE FIND
>   BEGIN
>     FOR MISSING MIG-CMD-CODE-A
>       BEGIN
>         GET MIG-CMD-CODE-A VIAINDEX MIG-CMD-NAME VIA MIG-CMD-NAME &
>               USING TRUNC(TEMP-NAME) + "@"
>         END
>     END

I have done this type of thing for 20 years with a KSAM file, 
but can't get it to work with an image b-tree.

Again, the problem is with filling the cluster not the return to screen.

The dictionary is structured as follows:

RECORD MIG-CMD-CODE-A   ORGANIZATION AUTOMATIC MASTER INDEXED
  ITEM MIG-CMD-NAME     DATATYPE CHARACTER SIZE 8

INDEX MIG-CMD-NAME
  SEGMENT MIG-CMD-NAME

I've tried several tweeks to the GET statement. No luck.

Any further ideas?

Do I punt and log a support call?

Thanks in advance.

***
Date: Wed, 26 Oct 2005 17:09:13 -0400
From: "Deskin, Bob" <Bob.Deskin at Cognos.COM>
Subject: RE: (MPE) Alpha Lookup Screen Using Image B-Tree

The equivalent in QUICK should be something like:

file MIG-CMD-CODE-A
access viaindex MIG-CMD-NAME via MIG-CMD-NAME request MIG-CMD-NAME

I don't think you should need using MIG-CMD-NAME.

If you enter M@ in the prompt, you should see all the M's.

Also try a specific value as in

access viaindex MIG-CMD-NAME via MIG-CMD-NAME using "M@"

If that works, you should be able to use a define or temp but remember
to truncate. Certainly you want to truncate the name but depending on
where you put things, you may have to truncate the whole expression.

If none of these work, log a support call to get someone here to check
it.

And to your original question, if/when it works in IMAGE, the same code
should work on UNIX with Eloquence.

Bob


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051027/4f42ee52/attachment.html