Count

Roger Kesterson Roger.Kesterson@mtdsw.com
Wed, 8 Sep 2004 08:51:38 -0700


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C495BB.B9B227A0
Content-Type: text/plain;
	charset="ISO-8859-1"

I have never tried this, but can you use PORTABLE and DICTIONARY at the same
time to get it to read its own portable subfile?
-----Original Message-----
From: Kristina Carlton [mailto:Kristina.Carlton@JICompanies.com]
Sent: Wednesday, September 08, 2004 8:24 AM
To: 'powerh-l@lists.sowder.com'
Subject: Count


Hi All,
 
I am extracting data via Quiz into portable subfiles. The data in the
subfiles will then be used to load into a Progress warehouse. I was hoping
to get a count of the records I extract with each quiz and write them to a
file along with the date. The date is not a problem, but the count is. I was
going to access the subfile and simply count the number of records, but got
an error message that portable subfiles cannot be accessed. Anybody have a
workaround for this?
 
We are on OpenVMS V7.3-2 and Quiz V7.10.G4.
 
Thanks,
-Kristina
Ext. 2459
 

------_=_NextPart_001_01C495BB.B9B227A0
Content-Type: text/html;
	charset="ISO-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">


<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK 
href="cid:filelist.xml@01C4958D.F531B760" rel=File-List><!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:DrawingGridHorizontalSpacing>2.85 pt</w:DrawingGridHorizontalSpacing>
  <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
 </w:WordDocument>
</xml><![endif]-->
<STYLE>
<!--
 /* Font Definitions */
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:647 0 0 0 159 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
span.EmailStyle15
	{mso-style-type:personal-compose;
	mso-ansi-font-size:10.0pt;
	mso-ascii-font-family:"Century Gothic";
	mso-hansi-font-family:"Century Gothic";
	mso-bidi-font-family:Arial;
	color:#333399;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US style="tab-interval: .5in">
<DIV><SPAN class=818345015-08092004><FONT face=Courier color=#0000ff size=2>I 
have never tried this, but can you use PORTABLE and DICTIONARY at the same time 
to get it to read its own portable subfile?</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Kristina Carlton 
  [mailto:Kristina.Carlton@JICompanies.com]<BR><B>Sent:</B> Wednesday, September 
  08, 2004 8:24 AM<BR><B>To:</B> 'powerh-l@lists.sowder.com'<BR><B>Subject:</B> 
  Count<BR><BR></FONT></DIV>
  <DIV class=Section1>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
  style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Hi 
  All,<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
  style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">I am extracting data via 
  Quiz into portable subfiles. The data in the subfiles will then be used to 
  load into a Progress warehouse. I was hoping to get a count of the records I 
  extract with each quiz and write them to a file along with the date. The date 
  is not a problem, but the count is. I was going to access the subfile and 
  simply count the number of records, but got an error message that portable 
  subfiles cannot be accessed. Anybody have a workaround for 
  this?<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
  style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">We are on OpenVMS V7.3-2 
  and Quiz V7.10.G4.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
  style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Thanks,<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><!--[if supportFields]><font color="#333399"><span 
style='color:#333399'><span style='mso-element:field-begin'></span><span 
style="mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail 
Signature&quot; <span style='mso-element:field-separator'></span></span></font><![endif]--><SPAN 
  class=EmailStyle15><FONT color=#333399 size=2><SPAN 
  style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">-Kristina<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle15><FONT face="Century Gothic" 
  color=#333399 size=2><SPAN 
  style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ext. 
  2459</SPAN></FONT></SPAN><FONT color=#333399><SPAN 
  style="COLOR: #333399; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><!--[if supportFields]><font color="#333399"><span 
style='color:#333399'><span style='mso-element:field-end'></span></span></font><![endif]--><FONT 
  color=#333399><SPAN style="COLOR: #333399"><![if !supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT 
  color=#333399><SPAN 
  style="COLOR: #333399; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C495BB.B9B227A0--