RE: Creating a join logical

That's perfect, thank you Jason

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Jason Tovey
Sent: Wednesday, December 21, 2005 5:57 PM
To: System 21 Users
Subject: Re: [SYSTEM21] Creating a join logical

View the iSeries DDS Concepts Redbook -- specifically, the example on
page 27.

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/dds/rbafpmst
.pdf


On 12/21/05, Chris Payne <CPayne@xxxxxxxxxxxxxxx> wrote:
> I am trying to create a join logical to mimic this SQL statement:
>
>
>
> select
>
> cono28 as company,
>
> prnt28 as item,
>
> comp28 as container
>
> FROM
>
>   oslpdf3.msp28 g join
>
>   osld1f3.inp35 h on
>
>    g.cono28 = h.cono35 and
>
>    g.comp28 = h.pnum35 and
>
>    h.pcls35 = 'RC'
>
>
>
>
>
> In addition to keying the company and item fields, and thus far I have
>
>
>
>         *************** Beginning of data
> *************************************
>
> 0001.00      A          R JREC                      JFILE(MSP28 INP35)
>
>
> 0002.00      A          J                           JOIN(MSP28 INP35)
>
>
> 0003.00      A                                      JFLD(CONO28
CONO35)
>
>
> 0004.00      A                                      JFLD(COMP28
PNUM35)
>
>
> 0005.00      A          K CONO28
>
>
> 0006.00      A          K PRNT28
>
>
> 0007.00      A          S PCLS35                    CMP(EQ 'RC')
>
>
>         ****************** End of data
> ****************************************
>
>
>
> It seems to me like there must be a way to specify what columns I want
> to appear in this logical, but I do not know the keyword. Additionally
> the compiler is complaining about:
>
>
>
>
>
> * CPD7948      30        3      Message . . . . :   Key, select, or
omit
> field name not found in logical file.
>
> * CPD7980      30        1      Message . . . . :   Field with usage
of
> input only required.
>
>
>
> Which I assume is because I have not brought in any columns yet. If
> someone could help me out, and maybe point the way to some file DDS
> documentation I would very much appreciate it.
>
>
>
> ___________________________________
> Christopher Payne
> CPayne@xxxxxxxxxxxxxxx
> System Administrator/Programmer
>
>
>
> The Crown Group
> Corporate Offices
> 2111 Walter Reuther Drive
> Warren, MI 48091-6199
>
>
>
> Phone: (586) 575-9800
> Direct: (586) 558-5317
> Fax:  (586) 575-9856
>
>
>
>
>
>
>
> _______________________________________________
> This is the System 21 Users (SYSTEM21) mailing list
> To post a message email: SYSTEM21@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/system21
> or email: SYSTEM21-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/system21.
>
>

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.