Page 1 of 1
Generating a report by object checkins to Repository
Posted: Fri May 21, 2021 6:17 am
by lansa
How would I generate a report on an object checkin history?
Internal iseries file
or VL IDE File?
Mark Mason
Re: Generating a report by object checkins to Repository
Posted: Fri May 21, 2021 8:11 am
by Dino
You can get that information from the IBM IDE.
Go to housekeeping, work with tasks, select the task, then enter the partition, name of the object (uppercase) and object type,
option 5 and you will see all the history of checkin's (and more) of that object in that task. Option 6 is the report.
other tasks? well, if you didnt FIN those tasks, you can repeat the process in other tasks.
Re: Generating a report by object checkins to Repository
Posted: Mon May 24, 2021 3:17 pm
by lansa
Thank you very much, this is what I needed. The approach I found on local lx_FLG file had last 10 days only (I might have cleared it)
SELECT [XLGP_I]
,[XLGWID]
,[XLGSRV]
,[XLGSTY]
,[XLGMNO]
,[XLGJOB]
,[XLGMSG]
,[XLGDAT]
,[XLGTIM]
,[XLGMID]
,[XLGPGM]
,[XLGSTS]
,[XLGPRC]
,[XLGSP1]
,[XLGJBN]
,[XLGUSR]
,[XLGJNM]
,[XLGCAT]
,[XLGSRC]
,[XLGTYP]
,[XLGOBJ]
,[XLGOBE]
FROM [LANSA].[LX_DTA].[LX_FLG]
WHERE [XLGMSG] LIKE ('%check in to IBM%')