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 fileQPFRDATA.DWTRCJOIN SELECT COUNT(*), "IOP NAME", TCIOTYPE FROM QPFRDATA.DWTRCJOIN
Good Luck,
Kenneth