Back to Bookshelf

• Creating Dataviews Guide
• Legal Notices
• CA Technologies Product References
• Contact CA Technologies
• Introduction
  • Your View of Data
    • For SQL Access
    • General Description
  • Dataview Menu
    • Cataloging a Dataview
    • For SQL Access
    • Readonly Classification
    • For a Sequential File
    • For VSAM Files
  • Displaying the Dataview Definition
    • Dataview Display
    • For SQL Dataviews
    • For Native Access Dataviews
    • For VSAM Dataviews
    • DATAVIEW Message Line
    • For SQL Dataviews
    • For Native Command Access
    • For Sequential Files
    • For VSAM Files
    • Dataview Field Display
  • Printing a Dataview Definition
  • Displaying or Printing an Index of Dataview Definitions
  • Editing an Unmodeled Dataview Definition
  • Deleting a Dataview Definition
  • Duplicating a Dataview Definition
    • Duplicating to a New Version
    • Duplicating to a New Name
  • Changing the Status of a Dataview Definition
    • Status for Unmodeled Dataviews
  • PF Key Assignments
    • Dataview Access Security
• Creating Dataviews for SQL Access
  • Rules for SQL Dataviews
    • Identifying Columns
    • Data Types of Columns
    • Unique Index Requirement
    • Reserved Words
    • NonSQL Field Information
  • SQL Plans
  • Recatalog and Recompile
  • Specifying Which Database to Access in a Mixed SQL Site
• Creating Dataviews for CA Datacom/DB Native Command Access
  • Defining CA Datacom/DB Native Dataviews
    • Data Structures
      • File Model
    • Defining Elements
    • Defining Dataviews
  • Rules for CA Datacom/DB Native Command Access
    • Dataview Status and Related Occurrences
    • DATAVIEW Information
    • Setting a DBID
    • Dataview Key Relationship
    • Cataloging the Dataview
      • TABLE Attributes
      • Variable Length Records
      • Elements of a Dataview
      • Data Types of Columns
      • Other Field Attributes
      • VariablyRepeating Occurrences
      • Number of Levels of Occurrences
      • Levels of Data Structure Nesting
      • Compound Fields
      • Edit Patterns
      • Field Column Headings
      • PDL Reserved Words
      • Use of Field Entity Names
      • MultiValue Condition Names
      • Figurative Constants
      • Optional FIELD Attributes
      • INCLUDENILKEY
  • Defining Dataviews with Datadictionary
    • Recatalog and Recompile
• Creating Dataviews for Sequential Files
  • Defining Modeled Sequential Files
    • Data Structures
    • File Model
    • Defining Elements
    • Rules for Sequential File Dataviews
      • Dataview Status and Related Occurrences
        • Dataview Attributes
        • FILE Attributes
        • Sequential File MONITORNAME
        • Under z/OS or VSE
        • Variable Length Records
        • Element Consisting of Contiguous Fields
        • Levels of Data Structure Nesting
        • Number of Levels of Occurrences
        • Compound Fields
        • Data Types of Fields
        • Other Field Attributes
        • Edit Patterns
        • Field Column Headings
        • PDL Reserved Words
        • Use of Field Entity Names
        • MultiValue Condition Names
        • Figurative Constants
        • Optional FIELD Attributes
    • Modeled Sequential File Structures and Dataviews
    • Defining Modeled Dataviews for Sequential Files
      • In CA Ideal
    • Recatalog and Recompile
  • Defining Unmodeled Sequential File Dataviews
    • Components of a Sequential File Dataview Definition
    • Creating a Dataview Definition
    • Identifying the Dataview
    • Defining Fields
    • Defining the File Parameters
      • For VSE Only
  • Runtime Considerations for Sequential File Dataviews
    • Online Versus Batch Processing
    • CICS
    • z/OS Batch
    • VSE Batch
      • Device Type
      • Record Size
      • Block Size
      • Filename
      • Logical Unit Assignment
    • Modifying Dataview Characteristics Under VSE
• Creating Dataviews for VSAM Files
  • Defining VSAM Dataviews
    • Components of a VSAM Dataview Definition
    • How to Create a VSAM Dataview Definition
    • Dataview Identification Fillin
    • Dataview Parameter Definition
    • Dataview Field Definition
    • Dataview Key Definition
  • Runtime Considerations for VSAM Dataviews
    • Validating the Dataview at Runtime
    • Updating: Use of the Primary Index
    • Restrictions on NonUnique Keys
    • CHECKPOINT and BACKOUT With VSAM Files
    • Opening and Closing VSAM Files
    • Preparing for Execution
      • In CICS
        • In Batch