Re: Qryout file problem -- MIDRANGE-L

No problem, write an RPG program to 'denormalize' your database.




John.Taylor@britax-pmg.com on 04/27/99 05:59:20 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      

Subject:        Qryout file problem

If anyone can find a way to resolve this problem it would make my week.

I need to generate a file containing part numbers and locations with one
record per part number with multiple locations, from a file containing
multiple records per part number.

eg from this    Part Number     Location
                1234            A001A
                1234            A003C
                1234            C010D
                4567            A009B
                4321            B001A
                4321            B012D

to this         1234            A001A   A003C   C010D
                4567            A009B
                4321            B001A   B012D

I believe I can do this using multiple queries utilising result fields and
summaries but as of now I have not fathomed it out.


Thanks

John

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>Qryout file problem</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2 FACE="Arial">If anyone can find a way to resolve this problem 
it would make my week.</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">I need to generate a file containing part numbers 
and locations with one record per part number with multiple locations, from a 
file containing multiple records per part number.</FONT></P>

<P><FONT SIZE=2 FACE="Arial">eg from this&nbsp;&nbsp;&nbsp; Part 
Number&nbsp;&nbsp;&nbsp;&nbsp; Location</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">1234&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
A001A</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">1234&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
A003C</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">1234&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
C010D</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">4567&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
A009B</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">4321&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
B001A</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">4321&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
B012D</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">to this &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
1234&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
A001A&nbsp;&nbsp; A003C&nbsp;&nbsp; C010D</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">4567&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
A009B</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2 
FACE="Arial">4321&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
B001A&nbsp;&nbsp; B012D</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">I believe I can do this using multiple queries 
utilising result fields and summaries but as of now I have not fathomed it 
out.</FONT></P>
<BR>

<P><FONT SIZE=2 FACE="Arial">Thanks</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">John </FONT>
</P>

</BODY>
</HTML>