Q
Get started Bring yourself up to speed with our introductory content.

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
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

This was last published in August 2007

Dig Deeper on iSeries SQL commands and statements

Have a question for an expert?

Please add a title for your question

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

You will be able to add details on the next page.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close