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.

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close