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


  1.  Home
  2. SYSTEM21
  3. December 2005

RE: SYSTEM21 Digest, Vol 3, Issue 159

You need to specify fields after the JFLD lines, (cono28, prnt28, comp28)
and before the Key fields.  Go to the IBM web site and look in the DDS
manual.  They have simple examples.

Mindaugas Bielskus


-----Original Message-----
From: system21-request@xxxxxxxxxxxx [mailto:system21-request@xxxxxxxxxxxx] 
Sent: Thursday, December 22, 2005 12:02 PM
To: system21@xxxxxxxxxxxx
Subject: SYSTEM21 Digest, Vol 3, Issue 159


Send SYSTEM21 mailing list submissions to
        system21@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
        system21-request@xxxxxxxxxxxx

You can reach the person managing the list at
        system21-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than
"Re: Contents of SYSTEM21 digest..."


Today's Topics:

   1. Creating a join logical (Chris Payne)
   2. Re: [SYSTEM21] Creating a join logical (Jason Tovey)
   3. RE: [SYSTEM21] Creating a join logical (Chris Payne)


----------------------------------------------------------------------

message: 1
date: Wed, 21 Dec 2005 17:16:30 -0500
from: "Chris Payne" <CPayne@xxxxxxxxxxxxxxx>
subject: [SYSTEM21]   Creating a join logical

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

 

 

 



------------------------------

message: 2
date: Wed, 21 Dec 2005 17:57:21 -0500
from: Jason Tovey <jason.tovey@xxxxxxxxx>
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.
>
>



------------------------------

message: 3
date: Thu, 22 Dec 2005 09:58:04 -0500
from: "Chris Payne" <CPayne@xxxxxxxxxxxxxxx>
subject: RE: [SYSTEM21] 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.




------------------------------

_______________________________________________
This is the System 21 Users (SYSTEM21) digest 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.



End of SYSTEM21 Digest, Vol 3, Issue 159
****************************************

As an Amazon Associate we earn from qualifying purchases.

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

This mailing list archive is Copyright 1997-2024 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.