Generating a report by object checkins to Repository

[lansa]

How would I generate a report on an object checkin history?

Internal iseries file
or VL IDE File?

Mark Mason

[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.

[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%')