An example of using COUNT() in a STRSQL statement

iSeries expert Kenneth Graap gives an example of using COUNT() in a STRSQL statement.

Ken Graap

Published: 09 Aug 2007

Could you give me an example of using COUNT() in a STRSQL statement?

This example will:


DISPLAY I/O COUNT BY IOP AND IO TYPE from file QPFRDATA.DWTRCJOIN

 

 

SELECT COUNT(*), "IOP NAME", TCIOTYPE

       FROM QPFRDATA.DWTRCJOIN

Good Luck,

Kenneth

Dig Deeper on iSeries SQL commands and statements

Flash storage in the cloud from the big cloud providers We survey the big three cloud providers – AWS, Azure and Google – and find a range of mostly block storage flash storage options with performance choices available

Demystifying flash pricing What do math problems and determining the true cost of flash have in common? You need all the facts to get the right answer, and they're both really hard.

Find alternatives to rip-and-replace with a server upgrade checklist As storage and network technology advances, a server upgrade can be a more effective approach than a complete replacement.

Flash storage performance gives your SAN a boost All-flash arrays have quickly become an IT success story thanks to their ability to extend the life and flash storage performance of a storage area network with minimal cost impact.

Flash storage performance changing the rules The ability to measure flash performance requires different metrics, along with a better understanding of applications, which can make it more complicated to purchase than HDDs.

IT benchmarking incorporates more than server performance While a server performance test is a key IT benchmarking metric, it coexists with prices and the target workloads to yield a true IT performance benchmark.

Related Q&A from Ken Graap

Consolidation across multiple LPARs using BRMS

The BRMS Network feature allows a BRMS system to connect to other BRMS systems via a network, and enables a user to consolidate media such as backup ... Continue Reading

Options other than RCLSTG to enable file journaling?

The only option to correct damage preventing file journaling is to use the RCLSTG command. Continue Reading

Good strategies for iSeries backup

IBM's iSeries Backup and Recovery manual answers many questions related to system backup and disaster recovery. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

An example of using COUNT() in a STRSQL statement

iSeries expert Kenneth Graap gives an example of using COUNT() in a STRSQL statement.

Dig Deeper on iSeries SQL commands and statements

Related Q&A from Ken Graap

Consolidation across multiple LPARs using BRMS

Options other than RCLSTG to enable file journaling?

Good strategies for iSeries backup

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

Dig Deeper on iSeries SQL commands and statements

Related Q&A from Ken Graap

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.