Question { 10830 }

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE
THROUGH CL?

Answer

USING THE COMMAND 'RGZPFM'
The Reorganize Physical File Member (RGZPFM) command
compresses (removes deleted records from) one member of a
physical file in the database, and it optionally
reorganizes that member.

Question { 6116 }

There are six records in a file and we are going to update
that records and used commit operation when it complete the
update but suppose when it updating the third record,a
error occured and operation failed.Is previously two
records will be update or whole operation will be rollback?
Please confirm it.

Answer

Whole operation will be rolled back.
A commit operation guarantees that the group of operations
is completed. A rollback operation guarantees that the
group of operations is backed out.