Re: SQL to DDS help

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Do all the files have the same field structure? If so, you can put the
various files all on the PFILE keyword in the DDS

R DH90RCD                  PFILE(DH90CTRD DH90CTYK DH90DTRD DH90DTYK)

There may be a need to use the FORMAT keyword, and your logical's record
name will probably need to match one of the PFILE format.

Check the DDS Reference to be sure. But I think this works if all the field
names are the same.

Someone other fogey must know  <g>

At 02:12 PM 6/5/02 -0500, you wrote:
>I have the following SQL statement that returns what I desire.
>
>
>What I need to figure out is how to create one logical file with the same
>results.
>
>
>SELECT DH90CTRD.LAST AS LastName,
>     DH90CTRD.FIRST AS FirstName, DH90CTRD.NS AS Unit,
>     DH90CTRD.DSCDTE AS TermDate,
>     DH90CTRD.MEDRC AS MedRecNum,
>     DH90CTRD.INST AS Inst
>FROM DH90CTRD
>UNION
>SELECT DH90CTYK.Last AS LastName,
>     DH90CTYK.FIRST AS FirstName, DH90CTYK.NS AS Unit,
>     DH90CTYK.DSCDTE AS TermDate,
>     DH90CTYK.MEDRC AS MedRecNum,
>     DH90CTYK.INST AS Inst
>FROM DH90CTYK
>UNION
>SELECT DH90DTRD.Last AS LastName,
>     DH90DTRD.FIRST AS FirstName, DH90DTRD.NS AS Unit,
>     DH90DTRD.DSCDTE AS TermDate,
>     DH90DTRD.MEDRC AS MedRecNum,
>     DH90DTRD.INST AS Inst
>FROM DH90DTRD
>UNION
>SELECT DH90DTYK.Last AS LastName,
>     DH90DTYK.FIRST AS FirstName, DH90DTYK.NS AS Unit,
>     DH90DTYK.DSCDTE AS TermDate,
>     DH90DTYK.MEDRC AS MedRecNum,
>     DH90DTYK.INST AS Inst
>FROM DH90DTYK
>
>
>Thanks in advance.
>Michael J. Clinch
>Programmer Analyst
>Bureau of Information and Telecommunications
>Pierre, South Dakota
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.