<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoPlainText>Afraid I have not use PowerHouse on an HP3000 in almost 20 years.<o:p></o:p></p><p class=MsoPlainText><span style='color:black'><o:p> </o:p></span></p><p class=MsoPlainText><span style='color:black'>However I remember creating an SQL interface to query a Turbo Image DB from both ISQL and by adding the SQL access via the PowerHouse Dictionary, all without making any changes to the Image DB itself. This might give you the SQL interface you are looking for.<o:p></o:p></span></p><p class=MsoPlainText><span style='color:black'><o:p> </o:p></span></p><p class=MsoPlainText><span style='color:black'>Accessing TurboIMAGE/XL Data with ISQL<o:p></o:p></span></p><p class=MsoPlainText><span style='color:black'><a href="http://www.hpmmsupport.com/MPE%20Manual/5000/B3638590011.13587/45.htm">http://www.hpmmsupport.com/MPE%20Manual/5000/B3638590011.13587/45.htm</a><o:p></o:p></span></p><p class=MsoPlainText><span style='color:black'><o:p> </o:p></span></p><p class=MsoPlainText><span style='color:black'>Greig Morrison<o:p></o:p></span></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoNormal><span style='color:black'><img border=0 width=380 height=215 id="Picture_x0020_1" src="cid:image001.jpg@01D19EE2.CFDFE750" alt="cid:image001.jpg@01CE083F.81499C90"><o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:8.0pt'>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute or copy this email. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.<o:p></o:p></span></p><p class=MsoPlainText><span style='color:black'><o:p> </o:p></span></p><p class=MsoPlainText>------------------------------<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Message: 2<o:p></o:p></p><p class=MsoPlainText>Date: Mon, 25 Apr 2016 09:20:44 -0400<o:p></o:p></p><p class=MsoPlainText>From: "Ken Langendock" <<a href="mailto:Ken@Langendock.com"><span style='color:windowtext;text-decoration:none'>Ken@Langendock.com</span></a>><o:p></o:p></p><p class=MsoPlainText>Subject: HP3000 using Turbo Image<o:p></o:p></p><p class=MsoPlainText>To: "'Powerhouse List Server'" <<a href="mailto:powerh-l@lists.sowder.com"><span style='color:windowtext;text-decoration:none'>powerh-l@lists.sowder.com</span></a>><o:p></o:p></p><p class=MsoPlainText>Message-ID: <<a href="mailto:02d401d19ef5$47f88320$d7e98960$@Langendock.com"><span style='color:windowtext;text-decoration:none'>02d401d19ef5$47f88320$d7e98960$@Langendock.com</span></a>><o:p></o:p></p><p class=MsoPlainText>Content-Type: text/plain; charset="us-ascii"<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Sorry guys, I forgot to explain what my problem is exactly.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>1) This database is all detail data sets with NO unique keys.<o:p></o:p></p><p class=MsoPlainText>Everything is repeating.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I am constantly finding bad data (repeating).<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>2) Another thing that would help a lot is Views.not sure if that is<o:p></o:p></p><p class=MsoPlainText>even possible with these third party products.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>3) An SQL interface would help also.to be able to use Cursor's would be<o:p></o:p></p><p class=MsoPlainText>amazing.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>4) Dependencies would be really useful, to many times I have orphaned<o:p></o:p></p><p class=MsoPlainText>records.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I have all of the source, but not a mass compile script.yet.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>The app is 2800 programs and not all the source code is on the HP, I have it all on my PC but I am never 100% sure the programs I have is what is already installed.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Over the last 10 years I have been working with the code and crossing my fingers every time I release a program that did not have the source code on the machine already. I've been caught many times with an old program that was updated from a programmers group and never put into the source group.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I have been coding in PH for 30 years now and it never ceases to amaze me how these HP installations even work. Code is never where it is supposed to be and never have I seen a mass compile program on one. Let alone running the compile script on a regular basis to make 100% sure the code is all there.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Ken<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>-------------- next part --------------<o:p></o:p></p><p class=MsoPlainText>An HTML attachment was scrubbed...<o:p></o:p></p><p class=MsoPlainText>URL: <<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20160425/f6883c83/attachment.htm"><span style='color:windowtext;text-decoration:none'>http://lists.sowder.com/pipermail/powerh-l/attachments/20160425/f6883c83/attachment.htm</span></a>><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>------------------------------<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>--<o:p></o:p></p><p class=MsoPlainText>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: <a href="mailto:powerh-l@lists.sowder.com"><span style='color:windowtext;text-decoration:none'>powerh-l@lists.sowder.com</span></a><o:p></o:p></p><p class=MsoPlainText>Subscribe: &quot;subscribe&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com"><span style='color:windowtext;text-decoration:none'>powerh-l-request@lists.sowder.com</span></a><o:p></o:p></p><p class=MsoPlainText>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com"><span style='color:windowtext;text-decoration:none'>powerh-l-request@lists.sowder.com</span></a> <a href="http://lists.sowder.com/mailman/listinfo/powerh-l"><span style='color:windowtext;text-decoration:none'>http://lists.sowder.com/mailman/listinfo/powerh-l</span></a><o:p></o:p></p><p class=MsoPlainText>This list is closed, thus to post to the list you must be a subscriber.<o:p></o:p></p><p class=MsoPlainText>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>End of powerh-l Digest, Vol 125, Issue 3<o:p></o:p></p><p class=MsoPlainText>****************************************<o:p></o:p></p></div></body></html>