We use the number of records to know if we have to do a FTP, a Reflection Transfer or if a subfile which has to be exported to excel has more tan 65645 records (excel limit)... not only for display the information...<br><br>
Daniel<br><br><br><br><div><span class="gmail_quote">2007/9/20, Guy Werry <<a href="mailto:guy.werry@hbms.ca">guy.werry@hbms.ca</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>Ok, we have a subfile, a portable one, on HP-Ux and we
need to know how many records, then display that in a Quick
screen.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>We do something similar with many of our
reports.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>1) Write a Quiz report that will report the number of
records, with REPORT DEVICE DISC NAME (name to be chosen, use "FRED" as an
example).</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>2) In your Quick screen, RUN COMMAND "more FRED.txt"
CLEAR SCREEN RESPONSE</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>So, the disc file FRED.txt will have Quiz's report of
how many records it read (yes, a bit slower than wc -l, but life's not
perfect). The Quck screen will use the more utility to report the contents
of FRED.txt on your screen. Life is wonderful!</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>
<p><font size="2">Guy L. Werry<br>Senior Systems Analyst<br>Hudson Bay Mining
& Smelting Co., Limited. </font></p></span></font></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
powerh-l-bounces+guy.werry=<a href="mailto:hbms.ca@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">hbms.ca@lists.sowder.com</a>
[mailto:<a href="mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com</a>] <b>On Behalf Of
</b>Daniel Rodríguez<br><b>Sent:</b> Thursday, September 20, 2007 10:10
AM<br><b>To:</b> Franck LERAY<span class="q"><br><b>Cc:</b>
<a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br></span><b>Subject:</b> Re: Number of records of a subfile
in Qdesgin/UNIX?<br></font><br></div><div><span class="e" id="q_1152386b7e2f1589_3">
<div></div>Hi,<br><br>I think we don't have a C compiler installed in the news
HP9000... I will see... <br><br>If not, maybe I can write the result of the 'wc
-l' into a file, convert it to a fixed length and read it as a subfile... it's
just an idea... <br><br>Thank you,<br><br>Daniel<br><br>
<div><span class="gmail_quote">2007/9/20, Franck LERAY <<a href="mailto:franck.leray@cheops.fr" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">franck.leray@cheops.fr
</a>>:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div vlink="blue" link="blue" lang="FR">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Hi
Daniel,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">You need to make a
script which displays the number of records and a c stub. The c program return
the number of records to the quick program. We use this feature in differents
cases and use popen to call the script shell in the c
program.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Franck.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB"></span></font> </p></div>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-weight: bold; font-size: 10pt; font-family: Tahoma;">De :</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> Daniel
Rodríguez [mailto:<a href="mailto:reasegurator@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">reasegurator@gmail.com</a>]
<br><b><span style="font-weight: bold;">Envoyé :</span></b> jeudi 20
septembre 2007 13:45<br><b><span style="font-weight: bold;">À :</span></b>
Franck LERAY<br><b><span style="font-weight: bold;">Cc :</span></b> <a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br><b>
<span style="font-weight: bold;">Objet :</span></b> Re: Number of records of a
subfile in Qdesgin/UNIX?</span></font></p></div>
<div><span>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"></span></font> </p>
<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi Frank,<br><br>We use these portable subfiles to
export it to SAP, Streamserve, excel and other aplicactions and we write the
carriage return in each line of the subfile, so the command 'wc -l' works
properly.<br><br>I will try with the DO EXTERNAL option calling a Unix shell
script. <br><br>Merci beaucoup pour l'aide, Frank! Je suis spagnol et écrire
en anglais est aussi trés compliqué pour moi.<br><br>Daniel
Rodriguez,<br><br><br><br></span></font></p>
<div>
<p><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">2007/9/20, Franck LERAY <<a href="mailto:franck.leray@cheops.fr" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">franck.leray@cheops.fr
</a>>:</span></font></span></p>
<div vlink="purple" link="blue">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">On unix box, you can't use the
same method.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">2 problems</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">First</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">You can't use do command
statement, a variable set by a soon process is not visible from the parent
process.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">You have to do an external
subroutine (callable by the do external command).</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Second </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">The "wc –l" command will not work
like on 3k platform because on unix there's no carriage return in the subfile.
So the wc –l command will not return the number of records.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">You have to do a unix script. This
script will use the qshow command. This command will return the number of
records.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Hope this help (excuse my poor
English….)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Franck.</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB"></span></font> </p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB"></span></font> </p></div></div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>--<br>= = = = = = = = = = = = = = = = = = = = = =
= = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br>Subscribe:
&quot;subscribe&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-request@lists.sowder.com</a><br>Unsubscribe:
&quot;unsubscribe &lt;password&gt;&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-request@lists.sowder.com
</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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
'site:<a href="http://lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> lists.sowder.com</a> powerh-l'
to your search terms to search the list archive at
Google.</span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"></span></font> </p></span></div></div></div></blockquote></div><br></span></div>The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.
</div>
<br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: &quot;subscribe&quot; in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" 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 'site:<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com" target="_blank">
lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.<br></blockquote></div><br>