Quiz Extract

Wed, 18 Aug 2004 21:41:50 +0100

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C4856C.2B506DF0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

What platform are you on? I assumed VMS?

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.

  _____  

From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
Sent: 18 August 2004 17:28
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_000_0000_01C4856C.2B506DF0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
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=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:9.0pt;
	font-family:"Century Gothic";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:9.0pt;
	font-family:"Century Gothic";}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle16
	{mso-style-type:personal;
	font-family:"Century Gothic";
	color:#333399;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

What platform are you on? I assumed =
VMS?<o:p></o:p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'><o:p></o:p></span></font></p>

This e-mail and all information contained in it is =
confidential
and may be legally privileged. If you are not the =
intended recipient,
your access to this e-mail is unauthorized. Any use, dissemination,
distribution, publication or copying by you of this e-mail or any of the
information contained within it is prohibited and may be unlawful. Do =
not open
any attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. The content of this e-mail and =
any
attachments sent with it may have been altered without the consent or =
knowledge
of the author.<o:p></o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New Roman"'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> =
powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Kristina Carlton<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 18 August 2004 =
17:28<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
'powerh-l@lists.sowder.com'<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Quiz =
Extract</span></font><font
size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D1 face=3D"Century =
Gothic"><o:p>&nbsp;</o:p></font></p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'>Hi,<o:p></o:p></span></font></span></p>

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

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

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

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'>Thanks,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span
class=3DEmailStyle16><font size=3D2 color=3D"#333399" face=3D"Century =
Gothic"><span
style=3D'font-size:10.0pt'>-Kristina<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:10.0pt'>Ext. =
2459</span></font></span><o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>

------=_NextPart_000_0000_01C4856C.2B506DF0--