Generating a report by object checkins to Repository

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
lansa
Posts: 17
Joined: Tue Dec 01, 2015 3:14 am
Location: Flagler Beach, FL
Contact:

Generating a report by object checkins to Repository

Post by lansa » Fri May 21, 2021 6:17 am

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

Internal iseries file
or VL IDE File?

Mark Mason
Cheers,

Mark Mason

User avatar
Dino
Posts: 133
Joined: Fri Jul 19, 2019 7:49 am
Location: Robbinsville, NC
Contact:

Re: Generating a report by object checkins to Repository

Post by Dino » Fri May 21, 2021 8:11 am

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,
Image

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.
Image
other tasks? well, if you didnt FIN those tasks, you can repeat the process in other tasks.

lansa
Posts: 17
Joined: Tue Dec 01, 2015 3:14 am
Location: Flagler Beach, FL
Contact:

Re: Generating a report by object checkins to Repository

Post by lansa » Mon May 24, 2021 3:17 pm

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%')
Cheers,

Mark Mason

Post Reply