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

Download :