Jump to content

How to get count of records without holding the data in webFOCUS


Sivakumar Gopi 2

Recommended Posts

You can use &RECORDS or &LINES after you created a report

TABLE FILE CARSUM SALES BY COUNTRY ON TABLE HOLD AS TESTEND-TYPE LINE &LINES RECORDS &RECORDS

or if you do only need the number not the data

-SET &HOW_MANY = 0;TABLE FILE CARSUM COMPUTE HOW_MANY/I11=CNT.SALES ;ON TABLE HOLD AS TEST FORMAT ALPHAEND-RUN-READFILE TEST-TYPE HOWMANY &HOW_MANY
Link to comment
Share on other sites

I didn't want to hold all the data in a hold file and then count the lines. This is because sometimes my query could get over a million rows. That's why I want to check the number of rows first and then put a record limit on the data pull.

The count * was able to print the number of lines but when I try to hold it and read that it's is not recognizing the alias name I have given. That's my issue now.

Thank you

SG

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...