(MPE) Alpha Lookup Screen Using Image B-Tree

[Deskin, Bob]

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. 
        
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051028/2ff3e4b9/attachment.htm