Select Job_Name, Count(*) As Rows_Updating From QSYS2.RECORD_LOCK_INFO Where System_Table_Name = 'TABLENAME' And System_Table_Schema = 'TABLELIB' And Lock_State = 'UPDATE' Group By Job_Name Order By Rows_Updating Desc
A great place to learn RPG Free, SQL, CL programming tips and techniques
Select Job_Name, Count(*) As Rows_Updating From QSYS2.RECORD_LOCK_INFO Where System_Table_Name = 'TABLENAME' And System_Table_Schema = 'TABLELIB' And Lock_State = 'UPDATE' Group By Job_Name Order By Rows_Updating Desc