Re: SQL function to return list of members in physical file

[Bdietz400 <bdietz400@xxxxxxxxx>]

Just to add. 

https://www.rpgpgm.com/2021/12/searching-for-member-information-with.html

--
Bryan Dietz

> On Dec 29, 2021, at 5:30 PM, Don Brown via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> Thanks for the replies.
>
> I guess my problem was not searching for "partition" information 
>
> Both SYSPARTITIONSTAT and SYSTABLESTAT are exactly what I wanted and will 
> allow me to do what I wanted.
>
>
> Thanks all
>
> Don
>
>
>
>
> From:   "Eduardo Marcó" <eduardomarco@xxxxxxxxx>
> To:     "Midrange Systems Technical Discussion" 
> <midrange-l@xxxxxxxxxxxxxxxxxx>
> Date:   30/12/2021 03:37 AM
> Subject:        Re: SQL function to return list of members in physical 
> file
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
>
>
>
> SELECT
> substr(TABLE_NAME, 1, 10) ,
> count(table_partition) qty_members
> FROM QSYS2.SYSPARTITIONSTAT
> WHERE
> TABLE_SCHEMA = 'LIBRARY'
> AND
> TABLE_NAME='FILE'
> GROUP BY TABLE_NAME
>
> for me works fine
>
> > Em qua., 29 de dez. de 2021 às 14:06, Rob Berendt <rob@xxxxxxxxx> 
> > escreveu:
> >
> > Definitely.  And it was covered earlier.  I just missed that he also 
> asked
> > for a count of members (partitions).
> >
> > Rob Berendt
> > --
> > IBM Certified System Administrator - IBM i 6.1
> > Group Dekko
> > Dept 1600
> > Mail to:  7310 Innovation Blvd, Suite 104
> >          Ft. Wayne, IN 46818
> > Ship to:  7310 Innovation Blvd, Dock 9C
> >          Ft. Wayne, IN 46818
> > http://www.dekko.com
> >
> >
> > -----Original Message-----
> > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of 
> Bob
> > Elliott
> > Sent: Wednesday, December 29, 2021 12:00 PM
> > To: Midrange Systems Technical Discussion 
> <midrange-l@xxxxxxxxxxxxxxxxxx>
> > Subject: RE: SQL function to return list of members in physical file
> >
> > [You don't often get email from bob.elliott@xxxxxxxxxxxxxxxx. Learn why
> > this is important at http://aka.ms/LearnAboutSenderIdentification.]
> >
> > CAUTION: This email originated from outside of the organization. Do not
> > click links or open attachments unless you recognize the sender and know
> > the content is safe.
> >
> >
> > Wouldn't SYSPARTITIONSTAT give the member list?
> >
> > Thank you,
> > Bob
> >
> > -----Original Message-----
> > From: Rob Berendt <rob@xxxxxxxxx>
> > Sent: Wednesday, December 29, 2021 10:38 AM
> > To: Midrange Systems Technical Discussion 
> <midrange-l@xxxxxxxxxxxxxxxxxx>
> > Subject: RE: SQL function to return list of members in physical file
> >
> > Subject line says "return list of members in physical file" not how many
> > members.
> > I don't think SYSTABLESTAT will do this.
> >
> > Rob Berendt
> > --
> > IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 
> Mail
> > to:  7310 Innovation Blvd, Suite 104
> >          Ft. Wayne, IN 46818
> > Ship to:  7310 Innovation Blvd, Dock 9C
> >          Ft. Wayne, IN 46818
> > http://www.dekko.com
> >
> >
> > -----Original Message-----
> > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> > Stephen Landess
> > Sent: Wednesday, December 29, 2021 10:32 AM
> > To: Midrange Systems Technical Discussion 
> <midrange-l@xxxxxxxxxxxxxxxxxx>
> > Subject: Re: SQL function to return list of members in physical file
> >
> > CAUTION: This email originated from outside of the organization. Do not
> > click links or open attachments unless you recognize the sender and know
> > the content is safe.
> >
> >
> > SYSTABLESTAT:
> >
> > SELECT
> > CAST(TABNAME AS CHAR(20)) AS FILE
> > , CAST(TABSCHEMA AS CHAR(20))   AS LIB
> > , NBRPARTS   AS NBR_MBRS
> > , CARD  AS NBR_ROWS
> >
> > FROM SYSTABLESTAT
> > WHERE TABSCHEMA = 'JDFSRC'
> >
> > Position to line  . . . . .
> ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+.
> > FILE                  LIB                        NBR_MBRS
> >    NBR_ROWS
> > JDEEXT                JDFSRC                           10
> >         153
> > JDESRC                JDFSRC                       27,253
> >  20,259,740
> > F98CRTCMD             JDFSRC                          919
> >       3,056
> > JDECPY                JDFSRC                        1,899
> >     248,816
> > ********  End of data  ********
> >
> >
> > Regards,
> > Steve Landess
> > (512) 289-0387
> >
> > ________________________________
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related 
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate 
> link: https://amazon.midrange.com
>
>
>
>
> --
>
> This email has been scanned for computer viruses. Although MSD has taken reasonable precautions to ensure no viruses are present in this email, MSD cannot accept responsibility for any loss or damage arising from the use of this email or attachments..
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com