Superdex or omnidex <span></span><br><br>On Sunday, April 24, 2016,  &lt;<a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send powerh-l mailing list submissions to<br>
        <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
        <a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
or, via email, send a message with subject or body &#39;help&#39; to<br>
        <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a><br>
<br>
You can reach the person managing the list at<br>
        <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-owner@lists.sowder.com&#39;)">powerh-l-owner@lists.sowder.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than &quot;Re: Contents of powerh-l digest...&quot;<br>
<br>
<br>
Today&#39;s Topics:<br>
<br>
   1. Re:TURBO Image users, help (Ken Langendock) (Brian Schalme)<br>
   2. Re:TURBO Image users, help (Michael Cousins)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sat, 23 Apr 2016 11:57:37 -0500<br>
From: Brian Schalme &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;bschalme@airspeed.mb.ca&#39;)">bschalme@airspeed.mb.ca</a>&gt;<br>
Subject: Re: TURBO Image users, help (Ken Langendock)<br>
To: <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a><br>
Message-ID: &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;41c78046-f44e-9846-3727-7a215bc49985@airspeed.mb.ca&#39;)">41c78046-f44e-9846-3727-7a215bc49985@airspeed.mb.ca</a>&gt;<br>
Content-Type: text/plain; charset=&quot;windows-1252&quot;<br>
<br>
How about automatic masters?<br>
<br>
Brian Schalme<br>
<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;bschalme@airspeed.ca&#39;)">bschalme@airspeed.ca</a> &lt;mailto:<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;bschalme@airspeed.ca&#39;)">bschalme@airspeed.ca</a>&gt;<br>
<br>
Airspeed Consulting<br>
<a href="https://airspeed.ca/blog" target="_blank">https://airspeed.ca/blog</a><br>
<br>
Linkedin &lt;<a href="https://ca.linkedin.com/pub/brian-schalme/3/73b/851" target="_blank">https://ca.linkedin.com/pub/brian-schalme/3/73b/851</a>&gt; Twitter<br>
&lt;<a href="https://twitter.com/BrianSchalme" target="_blank">https://twitter.com/BrianSchalme</a>&gt;<br>
<br>
My emails are intended to communicate, educate, and transfer information.<br>
Sometimes they are considered Commercial Electronic Messages under<br>
Canada&#39;s Anti-Spam Legislation (CASL).<br>
If you would rather not receive these emails, just send me an email with<br>
the word Unsubscribe<br>
&lt;mailto:<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;bschalme@airspeed.ca&#39;)">bschalme@airspeed.ca</a>?subject=Unsubscribe&amp;body=Please%20unsubscribe%20me%20from%20all%20future%20emails.&gt;<br>
in the subject line.<br>
<br>
On 2016-04-23 12:00 PM, <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a> wrote:<br>
&gt; Send powerh-l mailing list submissions to<br>
&gt;       <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a><br>
&gt;<br>
&gt; To subscribe or unsubscribe via the World Wide Web, visit<br>
&gt;       <a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
&gt; or, via email, send a message with subject or body &#39;help&#39; to<br>
&gt;       <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a><br>
&gt;<br>
&gt; You can reach the person managing the list at<br>
&gt;       <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-owner@lists.sowder.com&#39;)">powerh-l-owner@lists.sowder.com</a><br>
&gt;<br>
&gt; When replying, please edit your Subject line so it is more specific<br>
&gt; than &quot;Re: Contents of powerh-l digest...&quot;<br>
&gt;<br>
&gt;<br>
&gt; Today&#39;s Topics:<br>
&gt;<br>
&gt;    1. TURBO Image users, help (Ken Langendock)<br>
&gt;    2. Re:TURBO Image users, help (Michel Adam)<br>
&gt;<br>
&gt;<br>
&gt; ----------------------------------------------------------------------<br>
&gt;<br>
&gt; Message: 1<br>
&gt; Date: Fri, 22 Apr 2016 16:51:44 -0400<br>
&gt; From: &quot;Ken Langendock&quot; &lt;Ken@Langendock.com&gt;<br>
&gt; Subject: TURBO Image users, help<br>
&gt; To: &quot;&#39;Powerhouse List Server&#39;&quot; &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a>&gt;<br>
&gt; Message-ID: &lt;026c01d19cd8$c84a3330$58de9990$@Langendock.com&gt;<br>
&gt; Content-Type: text/plain; charset=&quot;us-ascii&quot;<br>
&gt;<br>
&gt; Anyone out there still using Turbo Image on the HP3000?<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; Does anyone know how to enhance the indexes on turbo image?<br>
&gt;<br>
&gt; The application I am using is ALL detail datasets.what a PITA.<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; I heard there is something out there that can let me create unique indexes<br>
&gt; on this database. Superdex or Omnidex or something else.<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; If all else fails I can always move the data out to KSAM data files.<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; Ken<br>
&gt;<br>
&gt; -------------- next part --------------<br>
&gt; An HTML attachment was scrubbed...<br>
&gt; URL: &lt;<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160422/3be34b55/attachment-0001.html" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20160422/3be34b55/attachment-0001.html</a>&gt;<br>
&gt;<br>
&gt; ------------------------------<br>
&gt;<br>
&gt;<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: &lt;<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/71a14d2f/attachment.html" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/71a14d2f/attachment.html</a>&gt;<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: linkedin.png<br>
Type: image/png<br>
Size: 1141 bytes<br>
Desc: not available<br>
URL: &lt;<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/71a14d2f/attachment-0002.png" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/71a14d2f/attachment-0002.png</a>&gt;<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: twitter.png<br>
Type: image/png<br>
Size: 1418 bytes<br>
Desc: not available<br>
URL: &lt;<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/71a14d2f/attachment-0003.png" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/71a14d2f/attachment-0003.png</a>&gt;<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sat, 23 Apr 2016 16:03:09 -0400<br>
From: &quot;Michael Cousins&quot; &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;Michael.Cousins@ca.ibm.com&#39;)">Michael.Cousins@ca.ibm.com</a>&gt;<br>
Subject: Re: TURBO Image users, help<br>
To: &quot;Ken Langendock&quot; &lt;Ken@Langendock.com&gt;<br>
Cc: &#39;Powerhouse List Server&#39; &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a>&gt;<br>
Message-ID: &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;201604232003.u3NK3AH6005984@d01av01.pok.ibm.com&#39;)">201604232003.u3NK3AH6005984@d01av01.pok.ibm.com</a>&gt;<br>
Content-Type: text/plain; charset=&quot;utf-8&quot;<br>
<br>
<br>
Both products, Omnidex from DISC and Superdex from Bradmark, can be<br>
integrated into PH using the TPI interface (Third Party Indexing).<br>
<br>
These products catalog their own indexes. I&#39;m foggy if they are stored<br>
external to the db or in the db. Their function is are called from<br>
PowerHouse, usually Quiz or QTP, using a key sequence which invokes a data<br>
selection interface. Specific env vars are needed to enable calling the<br>
TPI, such as HPTYPEAHEAD and I believe at least one var for the specific<br>
vendor, and maybe another to indicate to PH that TPI was enabled. The<br>
vendor&#39;s XL also had to be added to the XL list or PATH or something like<br>
that.  It&#39;s been at least 15 years - all of this is now foggy.<br>
<br>
For the DISC product the calling key sequence invoked the Omnidex command<br>
line where the user specified search criteria.  The command line prompts<br>
and parms were invisible to the Quiz/QTP parser.<br>
Once the selection is entered the TPI package does its thing invisible to<br>
the ACCESS stmt processing by redirecting data reads to the data returned<br>
by the TPI vendor.<br>
<br>
The TPI enhancement was documented in the 7.2x doc set.<br>
<br>
Good luck.<br>
<br>
<br>
<br>
<br>
<br>
From:   &quot;Ken Langendock&quot; &lt;Ken@Langendock.com&gt;<br>
To:     &quot;&#39;Powerhouse List Server&#39;&quot; &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a>&gt;<br>
Date:   04/22/2016 04:53 PM<br>
Subject:        TURBO Image users, help<br>
Sent by:        powerh-l-bounces+michael.cousins=<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;ca.ibm.com@lists.sowder.com&#39;)">ca.ibm.com@lists.sowder.com</a><br>
<br>
<br>
<br>
Anyone out there still using Turbo Image on the HP3000?<br>
<br>
Does anyone know how to enhance the indexes on turbo image?<br>
The application I am using is ALL detail datasets?what a PITA.<br>
<br>
I heard there is something out there that can let me create unique indexes<br>
on this database. Superdex or Omnidex or something else.<br>
<br>
If all else fails I can always move the data out to KSAM data files.<br>
<br>
Ken--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a><br>
Subscribe: &#39;subscribe&#39; in message body to <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: &#39;unsubscribe &amp;lt;password&amp;gt;&#39; in message body to<br>
<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a><br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add &#39;site:<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a> powerh-l&#39; to your search terms to search the<br>
list archive at Google.<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: &lt;<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/acde1a36/attachment-0001.htm" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/acde1a36/attachment-0001.htm</a>&gt;<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: graycol.gif<br>
Type: image/gif<br>
Size: 105 bytes<br>
Desc: not available<br>
URL: &lt;<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/acde1a36/attachment-0001.gif" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20160423/acde1a36/attachment-0001.gif</a>&gt;<br>
<br>
------------------------------<br>
<br>
--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l@lists.sowder.com&#39;)">powerh-l@lists.sowder.com</a><br>
Subscribe: &amp;quot;subscribe&amp;quot; in message body to <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: &amp;quot;unsubscribe &amp;lt;password&amp;gt;&amp;quot; in message body to <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;powerh-l-request@lists.sowder.com&#39;)">powerh-l-request@lists.sowder.com</a><br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add &#39;site:<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a> powerh-l&#39; to your search terms to search the list archive at Google.<br>
<br>
End of powerh-l Digest, Vol 125, Issue 2<br>
****************************************<br>
</blockquote>