TAA Tools
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


Home Page Up to Top