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

SearchDataCenter

Close