TAA Tools
CVTFD           CONVERT FILE DESCRIPTION               TAADBKH/DBKI

The Convert  File Description command  is similar  to the system  DSPFD
command, but  only creates an outfile (does not  print or display).  In
addition  to the base functions of  DSPFD, CVTFD also provides for IASP
support.  Selection can be made  by type of library and a omit  list of
libraries may be specified.

The DSPFD  command is run internally  within CVTFD for  each library to
be processed.

*ALLOBJ  special authority  is required to  specify a  library value of
*ALL or *ALLUSR.

CVTFD is helpful when  running over the  entire system with or  without
IASPs.

A typical command would be:

             CVTFD         FILE(*ALLUSR/*ALL) TYPE(*MBR) FILEATR(*PF)
                             OUTFILE(xxx/yyy) OMITLIB(AAA BBB)

The  outfile  would  contain  a  record for  each  member  found  in  a
physical  file  in  all  user  libraries  with  libraries AAA  and  BBB
omitted.

The outfile  definitions  differ  from  that  used  by  DSPFD  in  that
additional fields are added  to account for the IASP  information.  The
non-IASP field names  used in the TAA model files  are the same as that
used  in the system model files  (see later 'Differences' section.  The
format names  used in the  TAA model files  are the  same as that  used
DSPFD  although the  formats  differ.   This  allows  existing uses  of
DSPFD  to be  converted  with minimal  changes.   To  use the  new IASP
field data will require changes in your application.

CVTFD escape messages you can monitor for
-----------------------------------------

      TAA9891    No files were found to output information for
      TAA9892    Errors found.  See previous messages
      TAA9893    The library was not found using an ASPDEV value

Escape messages from based on functions will be re-sent.

Command parameters                                    *CMD
------------------

   FILE          The qualified  name  of  the file  to  output  records
                 for.    A  specific  name,  a  generic  name,  or  the
                 special value *ALL may be entered.

                 The   library   qualifier  may   be   *LIBL,  *CURLIB,
                 *USRLIBL, *ALL, or *ALLUSR.

   TYPE          The type of  information to  be output.   If the  file
                 to  be written  to  already  exists,  it must  have  a
                 level ID  that matches the  model file to  be used for
                 output.  The following types are valid.

                 *BASATR.   The basic attributes  may be output for any
                 file.   *BASATR  is valid  for any  FILEATR  including
                 *ALL.  The  model file is TAADBKHP with  a format name
                 of QWHFDBAS.

                 *ATR.    The attributes  may  be output  for  a single
                 file.  *ALL  may be specified if  the TYPE is  *BASATR
                 or *RCDFMT.   Other FILEATR values are  also dependent
                 on the  TYPE parameter.  There is  a unique model file
                 for each type of file.

                 The following model files  and formats are used  based
                 on the FILEATR value:

                    FILEATR      Model File     Format

                    *BSCF       TAADBKIP       QWHFDBSC
                    *CMNF       TAADBKIQ       QWHFDCMN
                    *DSPF       TAADBKIR       QWHFDDSP
                    *PRTF       TAADBKIS       QWHFDPRT
                    *DKTF       TAADBKIT       QWHFDDKT
                    *TAPF       TAADBKIU       QWHFDTAP
                    *PF         TAADBKIV       QWHFDPHY
                    *LF         TAADBKIW       QWHFDLGL
                    *ICFF       TAADBKIX       QWHFDICF
                    *SAVF       TAADBKIY       QWHFDSAV
                    *DDM        TAADBKIZ       QWHFDDDM

                 *ACCPATH.  The access  path may be output for  any *PF
                 or  *LF  file.   The  model file  is  TAADBKHQ with  a
                 format name of QWHFDACP.

                 *MBRLIST.   A  list of members  may be  output for any
                 *PF or *LF  file.  The model  file is TAADBKHX with  a
                 format name of QWHFDML.

                 *SELECT.   A list of selection criteria  may be output
                 for  any *LF file.  The model  file is TAADBKHS with a
                 format name of QWHFDSO.

                 *SEQ.  A  list of  collating sequence information  may
                 be output  for any *PF  or *LF file.   The  model file
                 is TAADBKHT with a format name of QWHFDSEQ.

                 *RCDFMT.   A list of record formats  may be output for
                 any file.  The  model file is  TAADBKHW with a  format
                 name of QWHFDFMT.

                 *MBR.   Member information may  be output for  any *PF
                 or  *LF  file.   The  model file  is  TAADBKHU with  a
                 format name of QWHFDMBR.

                 *SPOOL.    Spool  information may  be  output  for any
                 *PRTF or  *DKTF  file.   The  model file  is  TAADBKHV
                 with a format name of QWHFDSPL.

                 *JOIN.   Join information  may be  output for  any *LF
                 file.   The model file is  TAADBKHY with a format name
                 of QWHFDJN.

                 *TRG.  Trigger information may  be output for any  *PF
                 file.  The  model file is TAADBKHZ with  a format name
                 of QWHFDTRG.

                 *CST.   Constraint information  may be  output for any
                 *PF file.  The  model file is  TAADBKHA with a  format
                 name of QWHFDCST.

                 *NODGRP.   For distributed physical  files only.   The
                 model  file   is  TAADBKHB  with  a   format  name  of
                 QWHFDNGP.

   FILEATR       A  list of up to 12  file attributes may be specified.
                 The valid values are:

                    *DSPF   Display file
                    *PRTF   Printer file
                    *DKTF   Diskette file
                    *TAPF   Tape file
                    *CMNF   Communications file
                    *BSCF   Bisynch communications file
                    *PF     Physical file
                    *LF     Logical file
                    *SAVF   Save file
                    *DDMF   Distributed Data Management file
                    *ICFF   Interactive communications file

                 The valid  values  are restricted  based  on the  TYPE
                 parameter.

   OUTFILE       The  qualified name  of the  outfile  to be  used.   A
                 name  must be  specified.   *LIBL  is the  default for
                 the library name.   If  *LIBL is used,  the file  must
                 exist.  If  the file already exists, it  must have the
                 proper format (see the TYPE parameter).

   OUTMBR        The  output  member to  be used.    This is  a  2 part
                 parameter.

                 The first part names  the member to  be used.   *FIRST
                 is the default.

                 The  second part  determines  if  the member  will  be
                 cleared first.   The default is *REPLACE  to clear the
                 member  before  writing  any  records.    *ADD  may be
                 specified to add to existing records.

   ASPDEV        Specifies  the auxiliary  storage  pool  (ASP)  device
                 name  where storage  for  the  library containing  the
                 object  is allocated.   If  the library resides  in an
                 ASP that  is not  part of  the  thread's library  name
                 space,  this parameter  must  be  specified to  ensure
                 the  correct library is  searched.   If this parameter
                 is used when the  library qualifier specified for  the
                 Object prompt  (OBJ parameter)  is *CURLIB, *LIBL,  or
                 *USRLIBL, ASPDEV(*) is the only valid value.

                 This  parameter can  be  specified  as a  list  of two
                 values   (elements)  or  as  a   single  value.    The
                 possible single values are:

                 * = The ASPs  that are currently part of  the thread's
                 library  name space  will  be searched  to locate  the
                 library.   This includes  the system ASP  (ASP 1), all
                 defined basic  user  ASPs  (ASPs 2-32),  and,  if  the
                 thread has  an ASP  group, the  primary and  secondary
                 ASPs in the thread's ASP group.

                 *ALLAVL =  All available ASPs will  be searched.  This
                 includes the  system ASP  (ASP 1),  all defined  basic
                 user ASPs (ASPs  2-32), and all available  primary and
                 secondary  ASPs,  (ASPs   33-255)  with  a  status  of
                 'Available'.

                 *CURASPGRP  =  If the  thread  has an  ASP  group, the
                 primary and secondary ASPs  in the thread's ASP  group
                 will be  searched to locate  the library.   The system
                 ASP  (ASP 1) and  defined basic user  ASPs (ASPs 2-32)
                 will not be searched.   If no ASP group is  associated
                 with the thread, an error will be issued.

                 *SYSBAS  = The  system  ASP (ASP  1)  and all  defined
                 basic  user  ASPs  (ASPs  2-32)  will  be searched  to
                 locate the  library.   No  primary or  secondary  ASPs
                 will  be  searched  even if  the  thread  has  an  ASP
                 group.

                 Element 1: Device

                 The  device name of  the primary  or secondary  ASP to
                 be  searched.  The primary  or secondary ASP must have
                 been activated  (by  varying on  the  ASP device)  and
                 have  a status of  'Available'.   The system  ASP (ASP
                 1)  and defined user  basic ASPs (ASPs  2-32) will not
                 be searched.

                 Element 2: Search type

                 *ASP  =  Specifies  that  only  the  single  auxiliary
                 storage pool  (ASP) device  named in  element 1 is  to
                 be searched.

                 *ASPGRP  =  Specifies that  the  entire  group of  the
                 primary auxiliary storage pool  (ASP) device named  in
                 element 1 is to be searched.

   LIBTYPE       Whether to  select all  or a  specified library  type.
                 *ALL is the default to select all types.

                 *PROD  may be  used to  select only  production (PROD)
                 libraries.

                 *TEST   may  be  used  to   select  only  test  (TEST)
                 libraries.

   OMITLIB       A list  of  up to  300  libraries or  generic  library
                 names that  should be omitted.  *NONE  is the default.

                 An omit list may not be entered for LIB(*CURLIB).

                 No  check occurs to see if the  library exists.  If an
                 omitted library appears  in QSYS  and also appears  in
                 multiple IASPs, all are omitted.

Differences with DSPFD
----------------------

  **   CVTFD  does  not provide  for  a  display or  print  capability.
       Only the outfile function is supported.

  **   Different  model files  are used  to allow  the addition  of new
       fields for IASP information.   One or  more reserved fields  are
       added to the model  files before the new IASP  fields to provide
       for the  same physical locations if new fields  are added to the
       system files.

  **   CVTFD  allows  selection  by  library type  (PROD  or  TEST) and
       allows for an omit list of libraries.

  **   DSPFD will  create an  outfile if  none exists  and the  library
       qualifier  for the  OUTFILE parameter  is  *LIBL.   The file  is
       created  in  the 'current  library'.   CVTFD  requires  the file
       exist if *LIBL is used.

  **   When a specific  object name exists for  the FILE parameter  and
       *LIBL  is used  as  the qualifier,  only  the  first file  found
       appears  in the  output file when  using DSPFD.   When  CVTFD is
       used, all  files of  the same  name are  output.   If a  generic
       file  name or  *ALL  is  used, there  is  no difference  in  the
       number of records output.

  **   If  no records  are  output, DSPFD  ends normally.    CVTFD will
       send  an  escape message  (TAA9891).   An  empty output  file is
       created.

  **   DSPFD supports  the SYSTEM  parameter.   CVTFD does  not.   Only
       files from the local system (*LCL) are returned.

  **   The  QWHFDPRT  file has  one  field  name  (PRREDUC) that  is  7
       characters  in  length.   This  field  is assigned  the  name of
       PRREDU in the corresponding TAADBKIS  file.  The data is  filled
       from the PRREDUC field.

Restrictions
------------

*ALLOBJ special  authority is  required to specify  a library  value of
*ALL or *ALLUSR.

Prerequisites
-------------

The following TAA Tools must be on your system:

     CHKALLOBJ       Check *ALLOBJ special authority
     CHKDUPLST       Check duplicates in a list
     CHKGENERC       Check generic
     CHKOBJ3         Check object 3
     DUPTAADBF       Duplicate TAA data base file
     EDTVAR          Edit variable
     EXTLST          Extract list
     EXTLST2         Extract list 2
     RSNLSTMSG       Resend last message
     RTNLIBL         Return library list
     RTVFMT          Retrieve format
     RTVLIBL         Retrieve library list
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     SNDESCMSG       Send escape message
     SNDJLGMSG       Send job log message
     SNDSTSMSG       Send status message

Implementation
--------------

None, the tool is ready to use.

Model files
-----------

     File        Format      Used when                       Syst file

     TAADBKHP    QAFDBAS     TYPE(*BASATR)                   QAFDBASI
     TAADBKIP    QWHFDBSC    TYPE(*ATR)    FILEATR(*BSCF)    QAFDBSC
     TAADBKIQ    QWHFDCMN    TYPE(*ATR)    FILEATR(*CMNF)    QAFDCMN
     TAADBKIR    QWHFDDSP    TYPE(*ATR)    FILEATR(*DSPF)    QAFDDSP
     TAADBKIS    QWHFDPRT    TYPE(*ATR)    FILEATR(*PRTF)    QAFDPRT
     TAADBKIT    QWHFDDKT    TYPE(*ATR)    FILEATR(*DKTF)    QAFDDKT
     TAADBKIU    QWHFDTAP    TYPE(*ATR)    FILEATR(*TAPF)    QAFDTAP
     TAADBKIV    QWHFDPHY    TYPE(*ATR)    FILEATR(*PF)      QAFDPHY
     TAADBKIW    QWHFDLGL    TYPE(*ATR)    FILEATR(*LF)      QAFDLGL
     TAADBKIX    QWHFDICF    TYPE(*ATR)    FILEATR(*ICF)     QAFDICF
     TAADBKIY    QWHFDSAV    TYPE(*ATR)    FILEATR(*SAVF)    QAFDSAV
     TAADBKIZ    QWHFDDDM    TYPE(*ATR)    FILEATR(*DDMF)    QAFDDDM
     TAADBKHQ    QWHFDACP    FILEATR(*ACCPTH)                QAFDACCP
     TAADBKHS    QWHFDSO     FILEATR(*SELECT)                QAFDSELO
     TAADBKHT    QWHFDSEQ    FILEATR(*SEQ)                   QAFDCSEQ
     TAADBKHU    QWHFMBR     FILEATR(*MBR)                   QAFDMBR
     TAADBKHV    QWHFDSPL    FILEATR(*SPOOL)                 QAFDSPOL
     TAADBKHW    QWHFRFMT    FILEATR(*RCDFMT)                QAFDRFMT
     TAADBKHX    QWHFDML     FILEATR(*MBRLIST)               QAFDMBRL
     TAADBKHY    QWHFDJN     FILEATR(*JOIN)                  QAFDJOIN
     TAADBKHZ    QWHFDTRG    FILEATR(*TRG)                   QAFDTRG
     TAADBKHA    QWHFDCST    FILEATR(*CST)                   QAFDCST
     TAADBKHB    QWHFDNDG    FILEATR(*NODGRP)                QAFDNGP

Objects used by the tool
------------------------

   Object        Type    Attribute      Src member    Src file
   ------        ----    ---------      ----------    ----------

   CVTFD         *CMD                   TAADBKH       QATTCMD
   TAADBKHC      *PGM       CLP         TAADBKHC      QATTCL
   TAADBKHR      *PGM       RPG         TAADBKHR      QATTRPG

The  model files provided  use the same  name for the  source member in
the QATTDDS file.  See the previous section on 'Model files'.
					

Added to TAA Productivity tools October 15, 2003


Home Page Up to Top