Quiz Extract

Wed, 18 Aug 2004 11:27:42 -0500

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

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_01C48540.4ED0A75D
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C48516.6095C7E0">
<!--[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 class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Hi,<o:p></o:p></spa=
n></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

I
am new to this list. I just started using Quiz and have some =
questions.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

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:<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>SET
REPORT DEVICE DISC NAME =
DKF1:[DW]DWDTL<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

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.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

Ultimately
we would like to extract data on a nightly basis and dump it into a =
Progress
data warehouse. Any advice is greatly =
appreciated.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;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
class=3DEmailStyle15><font size=3D2 color=3D"#333399"><span =
style=3D'font-size:10.0pt;
mso-bidi-font-size:12.0pt'>-Kristina<o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Ext.
2459</span></font></span><font color=3D"#333399"><span =
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
color=3D"#333399"><span style=3D'color:#333399'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

</div>

</body>

</html>

------_=_NextPart_001_01C48540.4ED0A75D--