× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.
>
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.