Re: Join Logicals

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

At 10:23 PM 8/13/97 -0400, you wrote:
>When defining a join logical file, does anyone know of a way to include
>all the data fields from all the joined physical files without having to
>list each field separately in DDS?
>-- 
>Nelson Smith

Not in DDS, that I know of. But, for an off-the-wall alternative, try using
SQL to create a view:

create view <viewname> as select * from <file1> join <file2> on
<file1.key1=file2.key2,etc.>

The above is v3r2/7 syntax--earlier uses a 'where' clause for the join.
Duplicate column names will get modified somewhat. Also, no index allowed.

If you don't have the licensed product, you can still do this with Query
Management queries (CRTQMQRY, STRQMQRY, etc.). Query Management is native,
and there's a manual in the Softcopy library. Also, GO CMDQMQRY or GO
CMDQRY should help.

Cheers


Vernon Hamberg
System Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *