Quiz Extract

Wed, 18 Aug 2004 13:06:14 -0400

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_01C48545.AAF001F0
Content-Type: text/plain;
	charset="iso-8859-1"

I would have thought that just your time alone to dink around trying to
force some hokey solution would be a lot more valuable that simply buying
more disc space!

-----Original Message-----
From: Kristina Carlton [mailto:Kristina.Carlton@JICompanies.com]
Sent: Wednesday, August 18, 2004 12:28 PM
To: 'powerh-l@lists.sowder.com'
Subject: Quiz Extract

Hi,

I am new to this list. I just started using Quiz and have some questions.

We have our files located on Disk 0 which has limited space. I am working on
extracts that retrieve quite a bit of data and ideally we want to redirect
the output to disk 1. I have been able to do so with the subfile but not
with the textfile. I tried the following:

SET REPORT DEVICE DISC NAME DKF1:[DW]DWDTL

However, I then noticed in the Cognos book I have that you cannot specify a
disk name with the SET REPORT statement. So we started suppressing the text
file and decided to use the subfile. That has its own set of problems such
as not being able to use a PICTURE format, not being able to use the count
function and more.

Ultimately we would like to extract data on a nightly basis and dump it into
a Progress data warehouse. Any advice is greatly appreciated.

Thanks,
-Kristina
Ext. 2459

------_=_NextPart_001_01C48545.AAF001F0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C48516.6095C7E0" rel=3DFile-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=3DEN-US style=3D"tab-interval: .5in">
<DIV>
<DIV><SPAN class=3D890451117-18082004><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2>I would&nbsp;<SPAN class=3D906591217-18082004>have thought =
</SPAN>that just=20
your time alone to dink around trying to force some hokey solution =
would be a=20
lot more valuable that simply buying more disc space<SPAN=20
class=3D906591217-18082004>!</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D890451117-18082004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV></DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Kristina Carlton=20
[mailto:Kristina.Carlton@JICompanies.com]<BR><B>Sent:</B> Wednesday, =
August 18,=20
2004 12:28 PM<BR><B>To:</B> =
'powerh-l@lists.sowder.com'<BR><B>Subject:</B> Quiz=20
Extract<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Hi,<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>=

<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt">I=20
am new to this list. I just started using Quiz and have some=20
questions.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>=

<SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">We have our files =
located on=20
Disk 0 which has limited space. I am working on extracts that retrieve =
quite a=20
bit of data and ideally we want to redirect the output to disk 1. I =
have been=20
able to do so with the subfile but not with the textfile. I tried the=20
following:<o:p></o:p>
<![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p>=

<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">SET REPORT DEVICE =
DISC NAME=20
DKF1:[DW]DWDTL<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>=

<SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">However, I then =
noticed in=20
the Cognos book I have that you cannot specify a disk name with the SET =
REPORT=20
statement. So we started suppressing the text file and decided to use =
the=20
subfile. That has its own set of problems such as not being able to use =
a=20
PICTURE format, not being able to use the count function and=20
more.<o:p></o:p>
<![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p>=

<SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ultimately we =
would like to=20
extract data on a nightly basis and dump it into a Progress data =
warehouse. Any=20
advice is greatly appreciated.<o:p></o:p>
<![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p>=

<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Thanks,<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20
Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><=
SPAN=20
class=3DEmailStyle15><FONT color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">-Kristina<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ext.=20
2459</SPAN></FONT></SPAN><FONT color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><FONT=20
color=3D#333399><SPAN=20
style=3D"COLOR: #333399"><![if =
!supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT=20
color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: windowtext"><o:p></o:p></SPAN></=
FONT></P></DIV></BODY></HTML>

------_=_NextPart_001_01C48545.AAF001F0--