Rebuild Table on Check In Files on IBM i

[jyoung]

If I create a file via "Load Other File".
When I check in that File what do the options "Rebuild table" and "Rebuild indexes and views" do?

The documentation states

to force the generation and compilation of the table, indexes and OAM.

I understand the OAM is going to be recreated but is it going to do something to the actual file and indexes?

[KevinW]

If you loaded the other file from the IBM i then these two options do nothing.

If you loaded the other file from elsewhere then these two options will do as they state.

Think about it. If the file exists in the IBM i data base and LANSA says it is maintained by "OTHER" then LANSA won't maintain it, apart from LANSA's access to it - the definitions held in LANSA and the generated OAM. If it is changed outside of LANSA then it will probably need to be reloaded and the OAM regenerated.

[jyoung]

That is what I had assumed, but the last thing I wanted to do was to wipe out a File on the IBM i.

Thanks,
Joe