ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Record count in multimember PF

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Record count in multimember PF

    How to retrieve the record count of a multimember PF directly in a single shot.Is there any API to take the total record count.

    At present i try RTVMBRD in a loop and also reading spool of DSFD.Is there any other way.

  • #2
    Re: Record count in multimember PF

    You could get this from QSYS2/SYSCSTAT.
    Regards

    Kit
    http://www.ecofitonline.com
    DeskfIT - ChangefIT - XrefIT
    ___________________________________
    There are only 3 kinds of people -
    Those that can count and those that can't.

    Comment


    • #3
      Re: Record count in multimember PF

      View SYSTABLESTAT column NUMBER_ROWS has the value you're looking for.

      Comment


      • #4
        Re: Record count in multimember PF

        Thanks a lot for your replies.Tried the suggestions and it worked fine.

        Comment

        Working...
        X