Introduction › Displaying the Dataview Definition › Dataview Field Display

Dataview Field Display

The remaining components of the formatted dataview definition display are as follows:

• Command An area where you can specify line commands. Line commands can copy, move, or delete lines. For more information about description of all line commands, see the Command Reference Guide.
• Seq A sequence number assigned to each name on the dataview display for reference.
• Level The level number that ranks columns in hierarchical order, from 2 through 16. The dataview name is always assigned as level 1.
• Field name The name of an elementary (simple) or group (compound) field. If this is a dataview for SQL access, this is the name of a column. A semicolon (;) as the last character indicates that the name is continued on the next line.
• T (type) The field or column type. Possible field types are:
  • X Alphanumeric (character). Valid for all dataview types.
  • N Numeric (signed). For unmodeled files (VSAM and sequential) and CA Datacom/DB native access dataviews, numeric fields can be zoned, packed, or binary. For SQL access, numeric fields can be integer, small integer, and decimal.
• U Unsigned numeric. For unmodeled files (VSAM and sequential) and CA Datacom/DB native access dataviews, unsigned numeric fields can be zoned or packed. For SQL access, unsigned numeric fields can be integer, small integer, and decimal.
• D Date. For unmodeled files (VSAM and sequential) and CA Datacom/DB native access dataviews, date fields can be zoned, packed, or binary. For SQL access, this form of date field not valid, see the SQL DATE, TIME and TIMESTAMP columns.
• C A condition name assigned to a specific value. This is not valid for SQL access dataviews.
• V Variable length (variable string and long variable string). This is valid only for SQL access and CA Datacom/DB native access dataviews. For CA Datacom/DB native access to SQL‑defined objects, variable length fields are supported, but they display as an X type field and the length shown is the maximum length.

  For each variable length item in an SQL dataview, a two‑byte long field for the length is generated in front of the data. This field is not shown in the display. The programmer needs to account for this field only in non‑CA Ideal subprograms. Refer to the CALL statement in the Command Reference Guide.

• I (Internal Type) The internal representation of numeric (signed and unsigned) and date type fields:
  • P Packed
  • Z Zoned
  • B Binary

  Numeric fields can be internally represented in packed decimal, zoned decimal, or binary formats. CA Ideal can operate on most of these directly, performing internal conversions when necessary (floating point formats are not supported). Numeric fields are viewed in terms of decimal (base 10) digits and are fully defined by the total number of integer and decimal places, regardless of internal storage formats. CA Ideal performs all necessary internal conversions on both input and output.

  The CA Ideal format for DB2 numeric columns is shown under the CH/DG entry.

• Ch/Dg (Characters/Digits) The length of the field:
  • Characters-The number of alphanumeric characters in the field.
  • Digits-The number of integer and decimal places (base 10 equivalent) in a numeric field, separated by a period.

  The following example shows the type, internal type, and ChDg values for 5 fields.

In the above example, 42 in the Ch/Dg column for the first alphanumeric field (Type X) indicates a length of 42 characters; and 16 for the next alphanumeric field indicates a length of 16 characters. A numeric field (Type N) with 7 specified in the Ch/Dg column indicates a seven‑digit field able to hold seven integer places. Since the internal type is P (packed), the actual size of the field is four bytes ((7 1)/2 = 4). The next numeric field, with 10.3 specified in the Ch/Dg column, indicates a 13‑digit field able to hold ten integer places and three decimal places. Since the internal type is Z (zoned), the actual size of the field is 13 bytes. A date field (Type D) with 5 specified in the Ch/Dg column can hold an internal 5‑integer date value of up to 273 years from the base year.

SQL numeric fields display as follows:

SQL date and time fields display with a comment and the following attributes:

A field with an unsupported data type displays as type X and a warning message is issued.

• Occur (Number of occurrences)-Not present for SQL access dataviews. The number of times a group or field repeats.

  If a number displays in this column (and there is no DEP ON clause in the Value/Redef/Dep on column), it represents the number of times an item (group or elementary field) that repeats a fixed number of times, occurs.

  An item (group or elementary field) can also occur a variable number of times. In this case, the Occur column value represents the maximum number of occurrences, and a DEP ON clause appears in the Value/Redef/Dep on column. The DEP ON (Depending on) field name is specified in the Value/Redef/Dep on column with the clause DEP ON field‑name.

  The Depending on field is a non‑repeating elementary numeric field with no decimal positions that is located in this dataview preceding the DEP ON clause. At runtime, the Depending on field specifies the actual number of occurrences at any point during the run.

• K (Key)-(CA Datacom/DB native access and SQL access) The key column that indicates whether a field is defined as a key or part of a key in the dataview.
  • The field is a full key
  • The field is a partial key (high order portion of a key)

  If the field is not a full or partial key, there is no entry in this column.

  For example, in a dataview where KEY1 consists of FIELD1 and KEY2 consists of FIELD2,FIELD3, the corresponding dataview display identifies the three fields as follows:

  FIELD1  K  (full key)
  FIELD2  P  (partial key)
  FIELD3   (no entry)
  

  Since only the high order portion of a multi‑field key can be a partial key, FIELD3 is not a partial key.

  If a key has 65 or more FIELDs defined in the dictionary, CA Ideal only recognizes the first 64 FIELDs, and lists only the first as a partial key.

• K (Key) (VSAM only)-Indicates whether the field is a primary or alternate key. If the field is not a primary or alternate key, there is no value in this column:
  • K The field defined as a primary or alternate key.
  • P The first field in a group that is defined as a key.

  All of the keys, primary and alternate, are listed at the end of the field layout.

• Value/Redef/Dep on (Value, Redefinition, or Depending on column‑name)-An initial value for a condition name or for an elementary field, a field redefinition clause, a DEP ON clause, or a comment.
  • Value-An initial default value assigned to this field each time a new record is created. The DVW Administrator specifies it during dataview definition. If no initial value is specified, CA Ideal uses spaces for alphanumeric, 0 for numeric. The default value is a numeric or alphanumeric literal, depending on the type of elementary field. Alphanumeric literals are enclosed in delimiters (“or”).

  Note: For read-only (R) dataviews (UPDATE‑INTENT=N), only condition name (Type C) values display since initial value has no meaning for a read‑only dataview.

  • Redefinition-A Redefinition clause in this field indicates that the field or group is another view of a previously defined field. The field‑name is a previously defined field or group that is redefined by this item. This does not apply to SQL dataviews.
  • Depending on field‑name-A Depending on clause in this column indicates that the field or group repeats a variable number of times. The field named in the Depending on clause:
    • Specifies the number of times the field named in the Field Name column occurs in the current record, and
    • Must be a non‑repeating, elementary, numeric field that appears previously in the dataview and contains an integer value.
• WITH IND (For SQL and CA Datacom/DB Native
  Access)-The clause WITH IND in this column indicates that this column is nullable; that is, it can receive null values.

  Note: For each nullable item, CA Ideal generates a two‑byte indicator variable. This variable is not shown in the display. The programmer needs to account for this field only in non‑CA Ideal subprograms.

• :DATE or :TIME or :TIMESTAMP-For SQL and CA Datacom/DB native access. An indicator of an SQL date, time, or timestamp column that has been converted to an alphanumeric item by CA Ideal.
• Comments-For unmodeled sequential and VSAM files, comments provide useful information about the field. A comment is indicated in this column by a preceding colon (:).
• KEY SECTION-For VSAM files only, lists the key definitions entered on the Key Definition fill‑in:
  • File/Path-The file name of the base cluster for the primary key or of the path for any alternate keys.
  • Field Name-The name of the key field.
  • Unique-For the primary key, the word PRIMARY displays. For alternate keys, a Y indicates that the key is a unique key; N indicates that it is not unique.
  • Upgrade Set-For the primary key, this column is blank. For alternate keys, a Y indicates that this path is part of the upgrade set; N indicates that it is not.
• Row IDs (SQL access only)-The names of any unique indexes (composed of up to 64 non‑nullable columns) defined for the underlying table or view for the dataview, and the names of the columns comprising each index.
• Text (SQL access only)-The text of the SQL CREATE VIEW statement, used if the dataview is associated with a view. If the dataview is for an CA Datacom SQL access synonym, the Text area indicates the object for which this is a synonym.

Printing a Dataview Definition

Use the PRINT command or the PRINT prompter to print a specific dataview definition. To display the PRINT prompter (as it applies to dataview definitions), select option 7 on the Dataview Menu. The following screen contains an example of the PRINT prompt screen.

 =>
 IDEAL: PRINT OCCURRENCE      DVW                             SYS: DOC  PROMPTER

 PRINT   DVW  ________________________________    VERSION   PROD
         (1)               (2)                               (3)

   DEST  LIB  _____________________________________________________________
         (4)                           (5)

   COPIES  1  NAME ________  DISP REL   DESC ________________________________
         (6)         (7)          (8)                     (9)
 -----------------------------------------------------------------------------
 (1) DVW = Dataview   PNL = Panel    (2) Name  (3) nnn   (4) Destination:
     MEM = Member     RPT = Report                 PROD      LIB=Output library

     OUT = Ouput      SYS = System                 LAST      SYS=System printer

     PGM = Program    USR = User                             NET=Network printer

     PLA = Plan                                              MAI=Mail

 (5) Destination name      (6) # Copies    (7) Name of output

 (8) Disposition: REL = Release, KEE = Keep, HOL = Hold

 (9) Description (must be in quotes!)

The PRINT DATAVIEW command has the following format:

      {    *                   }
PRINT {DATAVIEW dvw‑identifier }
      {                        }
   
      [            {MAIL 'email‑id'            }]
      [DESTINATION {LIB                        }]
      [            { {SYS }                    }]
      [            { {NET } dest‑id [COPIES nn]}]

      [NAME print‑output]

      [            {KEEP    }]
      [DISPOSITION {RELEASE }]
      [            {HOLD    }]

      [DESCRIPTION 'string']

* Represents the current dataview and can be substituted for the dataview identification phrase.

dvw‑identifier

Identifies the name of the dataview. The dvw‑identifier includes different parts, depending on the type of dataview to identify:

For SQL dataviews Specify the dvw‑identifier as:

authid.dvw‑name

authid (SQL only)-The one‑ to eight‑character authorization ID required for SQL dataviews only.

dvw‑nam-The 1‑ to 18‑character name of the dataview.

For CA Datacom/DB native access, sequential, and VSAM dataviews Specify the dvw‑identifier as:

dvw‑name [VERSION ver]

dvw‑name-The 1‑ to 18‑character name of the dataview.

ver-The version of the dataview. The specified version must be in test or production status. If you specify dvw‑name and you omit the version clause, the default version specified in the SET VERSION command is used. Valid versions are:

Tnnn-The version number of a test dataview modeled in the dictionary (CA Datacom/DB native command access and modeled sequential files only).

T-Represents test status

nnn-The one‑ to three‑digit version number assigned to a production dataview or an unmodeled dataview in test or production status.

PROD-The production status version of the dataview.

Note: Unmodeled dataviews created before CA Ideal r2.2 are recognized as version 1, PROD status.

DESTINATION clause

Specifies the output destination.

MAIL 'email‑id'-A delimited 1 to 60 character name of a CA‑ eMail destination.

LIBRARY-The output library.

SYSTEM dest‑id-A system printer name.

NETWORK dest‑id-A network printer.

COPIES nn

Specifies the number of copies to print on a system or network printer.

Note: This clause is ignored in batch. For a VSE system printer, this clause is ignored both online and in batch.

NAME print‑output

Specifies the name assigned to the output if the destination is to the output library.

DISPOSITION

When the destination of an online print request is a system or network printer, the output is placed in the output library, and the DISPOSITION clause has the following effects:

KEEP-The job prints and a copy of the output is retained in the output library.

RELEASE-The job prints and no copy of the output is retained in the output library.

HOLD-The output is held until released.

When a print request is issued in batch and the destination is a system printer, the output is printed on the system printer and no copy is retained in the output library.

When a print request is issued (online or in batch) and the destination is the output library, output is placed in the output library for browsing at the terminal.

For more information about output disposition, see the Working in the Environment Guide.

DESCRIPTION 'string'

A 1‑ to 32‑character description of the output, enclosed in delimiters. For a description of valid string delimiters, see the Command Reference Guide.

For more information about CA Ideal PRINT command, see the Command Reference Guide.