(MPE) Alpha Lookup Screen Using Image B-Tree

[Peter Bateman]

Blair:

  As a workaround you could try creating  a NOCREATE alias of your automatic 
master
in the PDL. In the the alias definition call it a MANUAL master.

HP has something interesting on B-trees in:-.
TurboIMAGE B-Tree Behavior Clarification

by Tien You Chen -- MPE/iX Lab
http://docs.hp.com/en/30216-90348/ch03s02.html

Good luck,
Peter Bateman


>We duplicated your problem with clusters in 8.49D1. With an automatic
>master we only got one record. With a manual master, we got all the
>appropriate records. We will check with development on Monday to see if
>there is anything specific about automatic masters that would preclude
>this from working. We'll be in touch.
>
>Bob
>
>	-----Original Message-----
>	From: Blair Combs [mailto:combblai at isu.edu]
>	Sent: October 27, 2005 6:57 PM
>	To: Powerhouse Listserv
>	Cc: Deskin, Bob
>	Subject: RE: (MPE) Alpha Lookup Screen Using Image B-Tree
>
>
>	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>
><mailto: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
>
>        This message may contain privileged and/or confidential 
>information.  If you have received this e-mail in error or are not the 
>intended recipient, you may not use, copy, disseminate or distribute it; do 
>not open any attachments, delete it immediately from your system and notify 
>the sender promptly by e-mail that you have done so.  Thank you.
>
>


>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.