Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
HP.com home

HP OpenVMS Systems

Ask the Wizard
» 

HP OpenVMS Systems

OpenVMS information

» What's new on our site
» Upcoming events
» Configuration and buying assistance
» Send us your comments

HP OpenVMS systems

» OpenVMS software
» Supported Servers
» OpenVMS virtualization
» OpenVMS solutions and partners
» OpenVMS success stories
» OpenVMS service and support
» OpenVMS resources and information
» OpenVMS documentation
» Education and training

Evolving business value

» Business Systems Evolution
» AlphaServer systems transition planning
» Alpha RetainTrust program

Related links

» HP Integrity servers
» HP Alpha systems
» HP storage
» HP software
» HP products and services
» HP solutions
» HP support
disaster proof
HP Integrity server animation
Content starts here

Ask the Wizard Questions

How to find number of records in a file

The Question is:

What utility can I use to find how many records in a file?


The Answer is:

There is no specific utility in OpenVMS to do this, but many people use:

$ SEARCH/STATISTICS/OUT=NL: file.xxx XXXXXX
or
$ SORT /STAT file.ext NLA0:

It doesn't matter what string you search for, though it is marginally faster if the string is not found. You'll get an output which looks like this:

Files searched:                 1       Buffered I/O count:         4
Records searched:              94       Direct I/O count:           1
Characters searched:         3024       Page faults:               17
Records matched:                0       Elapsed CPU time:  0 00:00:00.02
Lines printed:                  0       Elapsed time:      0 00:00:00.02
The "records searched" tells you the number of records.


 

** About PDF files: The PDF files on this Web site can be read online or printed using Adobe® Acrobat® Reader. If you do not have this software installed on your system, you may download it from the Adobe Web site.
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2008 Hewlett-Packard Development Company, L.P.