ACTDLTRCD ACTIVATE DELETED RECORD TAADBNZ |
The Activate Deleted Record command writes an initialized record to a
physical file relative record number. The record must be in a
deleted status. This makes an active record in the file that can
then be updated by other functions. The companion command is
DLTACTRCD which deletes an active record.
You must have *ALLOBJ special authority to use either command.
If you have a unique keyed file, activating a deleted record will
attempt to add a key which is probably blanks/zeros. This may cause
a duplicate key error.
The TAA command PRTDLTRCD may be used to describe the deleted
relative record numbers that exist in the file.
A typical ACTDLTRCD command would be:
ACTDLTRCD FILE(ABC) RR(97)
File ABC must be a physical file. Record 97 must be in a deleted
status. The command would update the record with the initialized
values for the file. For example, packed fields would have a valid
zero value, date field types would be initialized, etc.
A typical DLTACTRCD command would be:
DLTACTRCD FILE(ABC) RR(97)
The record must be active.
ACTDLTRCD escape messages you can monitor for
---------------------------------------------
TAA9891 The record is already active
Escape messages from based on functions will be re-sent.
DLTACTRCD escape messages you can monitor for
---------------------------------------------
TAA9891 The record is already deleted
Escape messages from based on functions will be re-sent.
ACTDLTRCD Command parameters *CMD
----------------------------
FILE The qualified name of the physical file containing
the deleted record.
The library value defaults to *LIBL. A specific
library or *CURLIB may also be used.
RR The relative record number to be made active.
The record must be in a deleted status.
The value must be in a range of the existing records
in the file (the sum of the active and deleted
records).
MBR The member containing the deleted record. *FIRST is
the default. A specific member or *LAST may be
specified.
DLTACTRCD Command parameters *CMD
----------------------------
FILE The qualified name of the physical file containing
the active record.
The library value defaults to *LIBL. A specific
library or *CURLIB may also be used.
RR The relative record number to be deleted.
It must be an active record.
The value must be in a range of the existing records
in the file (the sum of the active and deleted
records).
MBR The member containing the active record. *FIRST is
the default. A specific member or *LAST may be
specified.
Restrictions
------------
You must have *ALLOBJ special authority to use either ACTDLTRCD or
DLTACTRCD.
The maximum record length supported is 9999.
Only physical files are supported.
If you have a unique keyed file, activating a deleted record will
attempt to add a key which is probably blanks/zeros. This may cause
a duplicate key error.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKALLOBJ Check *ALLOBJ special authority
CHKOBJ3 Check object 3
CRTINZRCD Create initialized record
EDTVAR Edit variable
HLRMVMSG HLL Remove message
RSNLSTMSG Resend last message
RTVDBFA Retrieve data base file attributes
SNDCOMPMSG Send completion message
SNDESCINF Send escape information
SNDESCMSG Send escape message
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
ACTDLTRCD *CMD TAADBNZ QATTCMD
DLTACTRCD *CMD TAADBNZ2 QATTCMD
TAADBNZC *PGM CLP TAADBNZC QATTCL
TAADBNZC2 *PGM CLP TAADBNZC2 QATTCL
TAADBNZR *PGM RPG TAADBNZR QATTRPG
TAADBNZR2 *PGM RPG TAADBNZR2 QATTRPG
Structure
---------
DLTACTRCD Cmd
TAADBNZC CL pgm
TAADBNZR RPG Pgm
ACTDLTRCD Cmd
TAADBNZC2 CL pgm
TAADBNZR2 RPG Pgm
|
Added to TAA Productivity tools January 15, 2013