Count

Peter Bateman ppfb@hotmail.com
Thu, 09 Sep 2004 21:48:22 -0300


<html><div style='background-color:'><DIV class=RTE>
<P>You can have a "FINAL FOOTING" as well as a "REPORT SUMMARY"</P>
<P>ACCESS ...</P>
<P>REPORT SUMMARY ...</P>
<P>FINAL FOOTING "DATE " SYSDATE "RECORD COUNT" COUNT NORESET</P>
<P>SET REPORT DEVICE DISC NAME WHATEVER </P>
<P>SET NOHEAD</P>
<P>GO <BR><BR></P></DIV>
<DIV></DIV>&gt;From: Roger Kesterson &lt;Roger.Kesterson@mtdsw.com&gt; 
<DIV></DIV>&gt;To: "'powerh-l@lists.sowder.com'" &lt;powerh-l@lists.sowder.com&gt; 
<DIV></DIV>&gt;Subject: RE: Count 
<DIV></DIV>&gt;Date: Wed, 8 Sep 2004 08:51:38 -0700 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;I have never tried this, but can you use PORTABLE and DICTIONARY at the same 
<DIV></DIV>&gt;time to get it to read its own portable subfile? 
<DIV></DIV>&gt;-----Original Message----- 
<DIV></DIV>&gt;From: Kristina Carlton [mailto:Kristina.Carlton@JICompanies.com] 
<DIV></DIV>&gt;Sent: Wednesday, September 08, 2004 8:24 AM 
<DIV></DIV>&gt;To: 'powerh-l@lists.sowder.com' 
<DIV></DIV>&gt;Subject: Count 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Hi All, 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;I am extracting data via Quiz into portable subfiles. The data in the 
<DIV></DIV>&gt;subfiles will then be used to load into a Progress warehouse. I was hoping 
<DIV></DIV>&gt;to get a count of the records I extract with each quiz and write them to a 
<DIV></DIV>&gt;file along with the date. The date is not a problem, but the count is. I was 
<DIV></DIV>&gt;going to access the subfile and simply count the number of records, but got 
<DIV></DIV>&gt;an error message that portable subfiles cannot be accessed. Anybody have a 
<DIV></DIV>&gt;workaround for this? 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;We are on OpenVMS V7.3-2 and Quiz V7.10.G4. 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Thanks, 
<DIV></DIV>&gt;-Kristina 
<DIV></DIV>&gt;Ext. 2459 
<DIV></DIV>&gt; 
<DIV></DIV></div><br clear=all><hr>Take the effort out of being organized with MSNŽ Calendar. <a href="http://g.msn.com/8HMBENCA/2740??PS=47575">MSN Premium:</a> Join now and get the first two months FREE*</html>