Re: Need some SQL DB Help

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

A place to find "pre-defined JOINs" might be in logical files. Either 
traditional join logicals or SQL views. Take a look at the various file 
descriptions for logical files. Also, have you displayed the file 
descriptions of the pertinent physical files (tables) to see the constraints?

DSPFD will get all the above information - constraints, however, are not 
displayed by default. For views, the SQL statement is in the file 
description output. You'll be stuck with some manual inspection, so get 
ready for an extensive sit-down with printouts.   ;-)

HTH
Vern

At 11:06 AM 5/4/2005, you wrote:

> I am hoping someone can help me out here. We have an SQL collection from a
> vendor that has different constraints(? joins that are predefined). I am
> trying to figure out how one of these joins works can for the life of me
> can't figure it out. The documentation doesn't show any join, but yet when I
> run this:
>
> select * from dbpopcr, dbposcm
>
> it works. Is there a way I can figure out this join using IBM delivered
> tools?
>
> --
> Mike Wills
> Midrange Programmer/Lawson Software Administrator
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.