FileMan Advanced User Manual

Table of Contents

• Orientation

• Introduction

• • What is VA FileMan?

• Part I: Tools

• • Chapter 1: Import and Export Tools

• • • What Applications Can You Exchange Data With?

• • • How Data is Moved Between Applications

• • • Dependency on Correct Data Communication

• • • Data Formats

• • • • Delimited Data Format

• • • • Fixed-Length Data Format

• • • How to Export Data

• • • • 1. Make Sure a FOREIGN FORMAT File Entry is Available

• • • • 2. Select Fields for Export Option

• • • • 3. Create Export Template Option

• • • • 4. Choose Entries/Export Data

• • • • Special Considerations: Exporting Numbers

• • • • Special Considerations: Multiples

• • • • About EXPORT Templates

• • • How to Import Data

• • • • 1. Generate ASCII Source File

• • • • 2. Specify Data Format, Source File, and Destination File

• • • • 3. Match Source to Destination Fields

• • • • 4. Run the Import

• • • • Special Considerations: Multiples

• • • • Importing from VMS Files

• • • Foreign Formats

• • • • FOREIGN FORMAT File Attributes Reference

• • • • Print Format Documentation Option

• • • • Define Foreign File Format Option

• • Chapter 2: Relational Navigation

• • • Simple Extended Pointer

• • • • Simple Extended Pointer Syntax (Short form)

• • • • Simple Extended Pointer Syntax (Long Form)

• • • • Examples

• • • • How to Navigate With a Variable Pointer Field

• • • Relational Jumps Across Files

• • • Backward Extended Pointer

• • • Join Extended Pointer

• • • • Limitations

• • • • Example

• • • Multiline Return Values

• • • • WORD-PROCESSING Field

• • • • Multiples

• • • • Backward Pointer

• • Chapter 3: Advanced Edit Techniques

• • • Field Value Stuffing

• • • • Set Field Default (2 //)

• • • • Stuff/Delete Field Value (3///)

• • • • Unvalidated Stuffs: (4////)

• • • • Variable Stuffs

• • • • WORD-PROCESSING Field Stuffing

• • • • Looping (^LOOP)

• • • INPUT Templates

• • • • Overview

• • • • Branching Within INPUT Templates

• • • Edit Qualifiers

• • • • Forcing Special Prompts

• • • • Duplicating Input Values

• • • • Forcing Required Input

• • • Text Formatting in Word Processing Fields

• • • • Word Wrapping

• • • • Tabs

• • • • Formatting Text with Word Processing Windows (Frames) | |

• • • • Text Formatting Expressions in Word Processing Windows

• • Chapter 4: Computed Expressions

• • • Syntax

• • • • Elements of Computed Expressions

• • • • Operators in Computed Expressions

• • • • DATA TYPEs in Computed Expressions

• • • • Using Functions as Elements in Computed Expressions

• • • Where to Use

• • • • Using Computed Expressions in COMPUTED Fields

• • • • Where to Use Computed Expressions "On the Fly"

• • Chapter 5: VA FileMan Functions

• • • How to Use VA FileMan Functions

• • • Documentation Conventions for VA FileMan Functions

• • • VA FileMan Functions

• • • Date/Time Functions

• • • Environmental Functions

• • • File and File Data Functions

• • • Mathematical Functions

• • • Printing Related Functions

• • • String Functions

• • • Temporary Data Storage Functions

• • • M-Related Functions

• • Chapter 6: Statistics

• • • How to Generate Statistics from Reports

• • • Descriptive Statistics

• • • Scattergram

• • • Histogram

• • Chapter 7: System Management

• • • Setup

• • • • ^DINIT

• • • • Security

• • • Standalone VA FileMan

• • • • Device Handling for Stand-alone VA FileMan

• • • • NEW PERSON File for Stand-alone VA FileMan

• • • ^%ZOSF Nodes

• • • • Manually Setting ^%ZOSF Nodes

• • • Alternate Editors

• • • • Setting Up Alternate Editors

• • • COMPILED ROUTINE File

• • • • COMPILED ROUTINE File Cleanup: ENRLS^DIOZ( )

• Part II: File ManagementII-IV

• • Chapter 8: List File Attributes

• • • List File Attributes Option

• • • • Brief Data Dictionary

• • • • Condensed Data Dictionary

• • • • Standard and Modified Standard Data Dictionaries

• • • • Custom-Tailored Data Dictionary

• • • • Templates Only Format

• • • • Global Map

• • • • Indexes and Cross-References Only

• • • • Keys Only

• • • • Map Pointer Relations Option

• • • • Check/Fix DD Structure Option

• • Chapter 9: Creating Files and Fields

• • • Creating a File

• • • Creating Fields

• • • • Field DATA TYPEs

• • • • Screen Mode Field Editing

• • • • DATE/TIME DATA TYPE

• • • • NUMERIC DATA TYPE

• • • • SET OF CODES DATA TYPE

• • • • FREE TEXT DATA TYPE

• • • • WORD-PROCESSING DATA TYPE

• • • • COMPUTED DATA TYPE

• • • • POINTER TO A FILE DATA TYPE

• • • • VARIABLE-POINTER DATA TYPE

• • • • MUMPS DATA TYPE

• • • Multiple-Valued Field (Multiples)

• • • Making a Field Mandatory

• • • Field Number Sequences

• • • NUMBER (.001) Field

• • • Changing and Deleting Fields

• • • • Changing Field Attributes

• • • • Changing a Field's DATA TYPE

• • • • Deleting an Existing Field

• • • Examples of File and Field Creation

• • • • File Creation

• • • • DATE/TIME Field

• • • • SET OF CODES Field

• • • • FREE TEXT Field

• • • • WORD-PROCESSING Field

• • • • COMPUTED Field

• • • • POINTER TO A FILE Field

• • • • VARIABLE-POINTER Field

• • • • Creating a Multiple

• • Chapter 10: File Utilities

• • • Verify Fields

• • • Cross-Reference a Field or File

• • • • Types of Traditional Cross-references

• • • • Edit a Traditional Cross-reference

• • • • Create a Traditional Cross-reference

• • • • Delete a Traditional Cross-reference

• • • • New-Style Cross-references

• • • • Edit a New-Style Cross-reference

• • • • Create a New-Style Cross-reference

• • • • Delete a New-Style Cross-reference

• • • Identifier

• • • Re-Index File

• • • INPUT Transform (Syntax)

• • • Edit File

• • • OUTPUT Transform

• • • Template Edit

• • • Uneditable Data

• • • Mandatory/Required Field Check

• • • Key Definition

• • • • Create a Key

• • • • Edit a Key

• • • • Delete a Key

• • • • Verify a Key

• Part III: Security

• • Chapter 11: Auditing

• • • Auditing a Data Field

• • • • Setting a Data Field Audit

• • • • Turning Data Field Audit On/Off

• • • • Reviewing the Data Field Audit Trail

• • • • Tracking Data Field Audits

• • • • Purging a Data Field Audit Trail

• • • Auditing a Data Dictionary

• • • • Setting Up a Data Dictionary Audit

• • • • Reviewing the Data Dictionary Audit Trail

• • • • Tracking Audited Data Dictionaries

• • • • Purging a Data Dictionary Audit Trail

• • Chapter 12: Data Security

• • • Security at the File Level

• • • • Access Code Security on Files

• • • • File Access Security (Formerly Part 3 of Kernel)

• • • Protection for Fields in a File

• • • Protection for Templates

• Part IV: Archiving

• • Chapter 13: Transferring File Entries

• • • Transfer File Entries Option

• • • Transferring Data Within the Same File

• • • • Transferring Entries Between Files

• • • • Transferring Entries into a New File

• • • Compare/Merge File Entries Option

• • • • Comparing Entries

• • • • Merging Entries

• • Chapter 14: Extract Tool

• • • Extract Overview

• • • Important Items to Note

• • • • Source File

• • • • Destination File

• • • Mapping Information

• • • ARCHIVAL ACTIVITY File

• • • Extract Steps

• • • • Select Entries to Extract Option (1 of 9)

• • • • Add/Delete Selected Entries Option (2 of 9)

• • • • Print Selected Entries Option (3 of 9)

• • • • Modify Destination File Option (4 of 9)

• • • • Create Extract Template Option (5 of 9)

• • • • Update Destination File Option (6 of 9)

• • • • Purge Extracted Entries Option (7 of 9)

• • • • Cancel Extract Selection Option (8 of 9)

• • • • Validate Extract Template Option (9 of 9)

• • Chapter 15: Filegrams

• • • FILEGRAM-type Templates

• • • Filegram and Archiving Relationship

• • • Using Filegrams

• • • Filegram Steps

• • • • Create/Edit Filegram Template Option

• • • • Display Filegram Template Option

• • • • Specifiers Option

• • • • Generate Filegram Option

• • • • Receiving Filegrams with MailMan

• • • • View Filegram Option

• • • • Install/Verify Filegram Option

• • • • Deleting a Filegram

• • Chapter 16: Archiving

• • • Considerations Before Archiving

• • • Archiving Process, including Archiving Options (1-9)

• • • • Select Entries to Archive

• • • • Add/Delete Selected Entries

• • • • Print Selected Entries

• • • • Create Filegram Archiving Template

• • • • Write Entries to Temporary Storage

• • • • Move Archived Data to Permanent Storage

• • • • Purge Stored Entries

• • • • Cancel Archival Selection

• • • • Find Archived Entries

• • • • ARCHIVAL ACTIVITY File

• Glossary

• Index