Re: Files left open

Jose -- tried it, same thing -
SELECT SYS_DNAME,SYS_TNAME,SYS_MNAME,RRN,LOCK_STATE,
LOCK_STATUS,LOCK_SCOPE,JOB_NAME
FROM QSYS.RECORD_LOCK_INFO
WHERE SYS_DNAME = 'MRPRODF'
AND SYS_TNAME = 'LOG'
RECORD_LOCK_INFO in QSYS type *FILE not found.

Buck -- wrkptfgp reveals this -
SF99717 2 Installed
SF99702 7 Installed

So, i guess we may be a little bit behind.... i guess. I'll ask our admin
when he's gonna update us.

Thanks,
(sorry didn't see this sooner, been on vacation)

John

Try changing the library instead of QSYS2 try just QSYS

On Mon, Aug 29, 2016 at 9:50 AM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 8/29/2016 8:50 AM, JRusling@xxxxxxxxxxx
wrote:

On our 7.2 box i get this ?

RECORD_LOCK_INFO in QSYS2 type *FILE not found.

I am using STRSQL on a green screen, something i'm missing?
(like a 'gather information' step)

I tried this on my 7.2 machine in STRSQL and it worked fine. What TR
are you on?

WRKPTFGRP here says
SF99717 4 (TR)
SF99702 9 (DB2)

SELECT SYS_DNAME,SYS_TNAME,SYS_MNAME,RRN,LOCK_STATE,
LOCK_STATUS,LOCK_SCOPE,JOB_NAME
FROM QSYS2.RECORD_LOCK_INFO
WHERE SYS_DNAME = 'FILE LIBRARY'
AND SYS_TNAME = 'FILE NAME'

--
--buck

<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.