• Embedded QUEL Companion Guide
  • About This Guide
    • Overview
    • Purpose of This Manual
    • Audience
    • Contents
    • Conventions
      • Statements and Commands
        • Terminology
        • Syntax
    • System-specific Text
    • Related Manuals
  • Embedded QUEL for C
    • EQUEL Statement Syntax for C
      • Margin
      • Terminator
      • Line Continuation
      • Comments
      • String Literals
    • C Variables and Data Types
      • Variable and Type Declarations
        • EQUEL Variable Declaration Procedures
        • Reserved Words in Declarations
        • Data Types
        • C Data Types and Corresponding Ingres Types
        • The Integer Data Type
        • The Floating-point Data Type
        • The Character String Data Type
        • ## Define Declaration
        • Variable Declarations Syntax
        • Type Declarations Syntax
        • Array Declarations Syntax
        • Pointer Declarations Syntax
        • Structure Declarations Syntax
        • A Structure with a Tag and a Body
        • A Structure with a Body and No Tag
        • A Structure with a Tag and No Body
        • Enumerated Integer Types
        • The Varying Length String Type
        • Indicator Variables
        • Assembling and Declaring External Compiled Forms - VMS only
        • Compiling and Declaring External Compiled Forms -UNIX only
        • Concluding Example
      • The Scope of Variables
      • Variable Usage
        • Simple Variables
        • Array Variables
        • Pointer Variables
        • Structure Variables
        • Using a Structure Member
        • Using an Enumerated Variable (Enum)
        • Using a Varying Length String Variable (Varchar)
        • Using Indicator Variables
      • Data Type Conversion
        • Ingres and C Data Type Compatibility
        • Runtime Numeric Conversion
        • Runtime Character Conversion
        • Using Varchar to Receive and Set Character Data
    • Dynamically Built Param Statements
      • Syntax of Param Statements
      • Practical Uses of Param Statements
      • Indicator Variables in Param Statements
      • Using the Sort Clause in Param Retrieves
      • Param Versions of Cursor Statements
    • Runtime Error Processing
      • Programming for Error Message Output
    • Precompiling, Compiling, and Linking an EQUEL Program
      • Generating an Executable Program
        • The EQUEL Preprocessor Command
        • Eqc Command Examples
        • The C Compiler
      • Linking an EQUEL Program--UNIX
        • Programs without Embedded Forms
        • Compiling and Linking Precompiled Forms
      • Linking an EQUEL Program--VMS
        • Assembling and Linking Precompiled Forms
        • Linking an EQUEL Program without Shared Libraries
      • Include File Processing
        • Including Source Code with Labels
      • Coding Requirements for Writing EQUEL Programs
        • Comments Embedded in C Output
        • Embedding Statements Inside C If Blocks
        • An EQUEL Statement that Does Not Generate Code
      • EQUEL/C Preprocessor Errors
    • Preprocessor Error Messages
    • Sample Applications
      • The Department-Employee Master/Detail Application
      • The Employee Query Interactive Forms Application
      • The Table Editor Table Field Application
      • The Professor-Student Mixed Form Application
      • An Interactive Database Browser Using Param Statements
  • Embedded QUEL for COBOL
    • EQUEL Statement Syntax for COBOL
      • Margin
      • Terminator
      • Line Continuation
      • Comments
      • String Literals
      • The Param Function
    • COBOL Variables and Data Types
      • Variable and Type Declarations
        • EQUEL Variable Declaration Procedures
        • The Declare Statement
        • Data Item Declaration Syntax
        • Reserved Words in Declarations
      • Data Types
        • The Numeric Data Category - UNIX
        • Numeric Data Items with Usage COMP-5 - UNIX
        • The Numeric Data Category - VMS
        • The Numeric Edited Data Category
        • The Alphabetic, Alphanumeric, and Alphanumeric Edited Categories
        • Declaring Records
        • Indicator Data Items
        • Compiling and Declaring External Compiled Forms - UNIX
        • Assembling and Declaring External Compiled Forms -VMS
        • Concluding Examples
      • The Scope of Variables
      • Variable Usage
        • Elementary Data Items
        • COBOL Tables
        • Record Data Items
        • Using Indicator Data Items
      • Data Type Conversion
        • Ingres Types and Corresponding COBOL Data Types
        • Decimal Type Conversion
        • Runtime Numeric Type Conversion
        • Numeric DISPLAY Items and Temporary Data Items
        • Runtime Character Conversion
    • Dynamically Built Param Statements
    • Runtime Error Processing
      • Programming for Error Message Output
        • Set_ingres Constant Values
    • Precompiling, Compiling, and Linking an EQUEL Program
      • Generating an Executable Program
        • The EQUEL Preprocessor Command
        • Eqcbl Command Options
      • Source Code Format
        • Format Considerations--UNIX
        • Format Considerations--VMS
      • The COBOL Compiler--VMS
        • Linking an EQUEL Program
        • Assembling and Linking Precompiled Forms
        • Linking an EQUEL Program without Shared Libraries
      • Incorporating Ingres into the Micro Focus RTS--UNIX
        • The COBOL Runtime System
        • Building an Ingres RTS Without the Ingres FRS
        • Building an RTS with the Ingres FRS
        • Including External Compiled Forms in the RTS
        • Procedure 1
        • Procedure 2
      • Include File Processing
      • Including Source Code with Labels
      • Coding Requirements for Writing EQUEL Programs
        • Comments Embedded in COBOL Output
        • Embedding Statements In IF and PERFORM Blocks
        • COBOL Periods and EQUEL Statements
        • An EQUEL Statement that Does Not Generate Code
        • Efficient Code Generation
        • COBOL Strings and EQUEL Strings
        • COBOL IF-THEN-ELSE Blocks
        • COBOL Function Calls
      • EQUEL/COBOL Preprocessor Errors
    • Preprocessor Error Messages
    • Sample Applications
      • UNIX and VMS--The Department-Employee Master/Detail Application
      • UNIX and VMS--The Employee Query Interactive Forms Application
      • UNIX and VMS--The Table Editor Table Field Application
      • UNIX and VMS--The Professor-Student Mixed Form Application
  • Embedded QUEL for Fortran
    • EQUEL Statement Syntax for Fortran
      • Margin
      • Terminator
      • Line Continuation
      • Comments
      • String Literals
    • Fortran Variables and Data Types
      • Variable and Type Declarations
        • EQUEL Variable Declaration Procedures
        • The Declare and Declare Forms Statements
        • Reserved Words in Declarations
        • Typed Data Declarations
        • Constant Declarations
        • Data Types
        • The Integer Data Type
        • The Real Data Type
        • The Character Data Type
        • Structure and Record Declarations
        • Indicator Variables
        • Assembling and Declaring External Compiled Forms - VMS
        • Compiling and Declaring External Compiled Forms - UNIX
        • Compiling and Declaring External Compiled Forms - Windows
        • Concluding Example
      • The Scope of Variables
      • Variable Usage
        • Simple Variables
        • Array Variables
        • Structure Variables - VMS only
        • Using a Structure Member
        • Using Indicator Variables
      • Data Type Conversion
        • Ingres and Fortran Data Type Compatibility
        • Runtime Numeric Type Conversion
        • Runtime Character Conversion
    • Dynamically Built Param Statements
      • Syntax of Param Statements
      • Practical Uses of Param Statements
      • Indicator Variables in Param Statements
      • Using the Sort Clause in Param Retrieves
      • Param Versions of Cursor Statements
    • Runtime Error Processing
      • Programming for Error Message Output
    • Precompiling, Compiling, and Linking an EQUEL Program
      • Generating an Executable Program
        • The EQUEL Preprocessor Command
        • Eqf Command Examples
        • The Fortran Compiler
      • Linking an EQUEL Program - UNIX
        • Programs Without Embedded Forms
        • Programs with Embedded Forms
        • Compiling and Linking Precompiled Forms
      • Linking an EQUEL Program - VMS
        • Assembling and Linking Precompiled Forms
        • Linking an EQUEL Program without Shared Libraries
      • Linking an EQUEL Program - Windows
      • Include File Processing
      • Including Source Code with Labels
      • Coding Requirements for Writing EQUEL Programs
        • Comments Embedded in Fortran Output
        • EQUEL Statements and Fortran If Blocks
        • EQUEL Statements that Generate Labels
        • An EQUEL Statement that Does Not Generate Code
      • EQUEL/Fortran Preprocessor Errors
    • Preprocessor Error Messages
    • Sample Applications
      • UNIX and VMS--The Department-Employee Master/Detail Application
      • UNIX and VMS--The Employee Query Interactive Forms Application
      • UNIX and VMS--The Table Editor Table Field Application
      • UNIX and VMS--The Professor-Student Mixed Form Application
      • UNIX, VMS, Windows--An Interactive Database Browser Using Param Statements
  • Embedded QUEL for Ada
    • EQUEL Statement Syntax for Ada
      • Margin
      • Terminator
      • Line Continuation
      • Comments
      • String Literals
      • Block Delimiters
    • Ada Variables and Data Types
      • Variable and Type Declarations
        • EQUEL Variable Declarations Procedures
        • The With Equel and With Equel_Forms Statements
        • Reserved Words in Declarations and Program Units
        • Data Types and Constants
        • Ada Data Types and Corresponding Ingres Types
        • Ada Constants and Corresponding Ingres Types
        • The Integer Data Type
        • The Float Data Type
        • The Long Float Storage Format
        • The Character and String Data Types
        • Variable and Number Declaration Syntax
        • Simple Variable Declarations
        • Type Constraints
        • The Range Constraint
        • The Discriminant and Index Constraints
        • Formal Parameter Declarations
        • Number Declarations
        • Renaming Variables
        • Type Declaration Syntax
        • Type Definition
        • Subtype Definition
        • Integer Type Definitions
        • Floating-point Type Definitions
        • Enumerated Type Definitions
        • Array Type Definitions
        • Record Type Definitions
        • Incomplete Type Declarations and Access Types
        • Derived Types
        • Private Types
        • Representation Clauses
        • Indicator Variables
        • Assembling and Declaring External Compiled Forms
        • Concluding Example
      • Compilation Units and the Scope of Variables
        • The Package Specification
        • The Package Body
        • The Procedure
        • The Function
        • The Declaration Block
        • Variable and Type Scope
      • Variable Usage
        • Simple Variables
        • Array Variables
        • Record Components
        • Access Variables
        • Using Indicator Variables
      • Data Type Conversion
        • Ingres TYPES and Corresponding Ada Data Types
        • Runtime Numeric Type Conversion
        • Runtime Character Type Conversion
    • Dynamically Built Param Statements
    • Runtime Error Processing
      • Programming for Error Message Output
    • Precompiling, Compiling and Linking an EQUEL Program
      • Generating an Executable Program
        • The EQUEL Preprocessor Command
        • Eqa Command Examples
        • The ACS Environment and the Ada Compiler
        • Entering EQUEL Package Specifications
        • Defining Long Floating-point Storage
        • The Ada Compiler
        • Linking an EQUEL Program
        • Assembling and Linking Precompiled Forms
        • Linking an EQUEL Program without Shared Libraries
      • Include File Processing
        • Including and Processing EQUEL/Ada Package Specifications
        • Including EQUEL/Ada Source Code
      • Coding Requirements for Writing EQUEL Programs
        • Comments Embedded in Ada Output
        • Ada Blocks Generated by EQUEL
        • An EQUEL Statement that Does Not Generate Code
      • EQUEL/Ada Preprocessor Errors
    • Preprocessor Error Messages
    • Sample Applications
      • The Department-Employee Master/Detail Application
      • The Employee Query Interactive Forms Application
      • The Table Editor Table Field Application
      • The Professor-Student Mixed Form Application
  • Embedded QUEL for BASIC
    • EQUEL Statement Syntax for BASIC
      • BASIC Line Numbers and the EQUEL Mark
      • Terminator
      • Line Continuation
      • Comments
      • String Literals
      • Integer Literals
    • BASIC Variables and Data Types
      • Variable and Type Declarations
        • EQUEL Variable Declarations Procedures
        • The Declare Ingres Statement
        • Reserved Words in Declarations
        • Data Types
        • BASIC Data Types and Corresponding Ingres Type
        • The String Data Type
        • The Integer Data Type
        • The Real Data Type
        • The Record Data Type
        • Variable and Constant Declaration Syntax
        • The Declare Statement
        • The Dimension Statement
        • Static Storage Variable Declarations
        • The External Statement
        • Parameter Variables
        • Record Type Definitions
        • The Indicator Variable
        • Assembling and Declaring External Compiled Forms
        • Concluding Example
      • The Scope of Variables
      • Variable Usage
        • Simple Variables
        • Array Variables
        • Record Components
        • Using Indicator Variables
      • Data Type Conversion
        • Ingres Data Types and Corresponding BASIC Types
        • Runtime Numeric Type Conversion
        • Runtime Character Type Conversion
    • Dynamically Built Param Statements
    • Runtime Error Processing
      • Programming for Error Message Output
    • Precompiling, Compiling, and Linking an EQUEL Program
      • Generating an Executable Program
        • The EQUEL Preprocessor Command
        • Eqb Command Examples
        • The BASIC Compiler
        • Linking an EQUEL Program
        • Assembling and Linking Precompiled Forms
        • Linking an EQUEL Program without Shared Libraries
      • Include File Processing
        • Including Source Code with Labels
      • Coding Requirements for Writing EQUEL Programs
        • Comments Embedded in BASIC Output
        • Embedding Statements Inside BASIC If Blocks
        • An EQUEL Statement that Does Not Generate Code
      • EQUEL/BASIC Preprocessor Errors
    • Preprocessor Error Messages
    • Sample Applications
      • The Department-Employee Master/Detail Application
      • The Employee Query Interactive Forms Application
      • The Table Editor Table Field Application
      • The Professor-Student Mixed Form Application
  • Embedded QUEL for Pascal
    • EQUEL Statement Syntax for Pascal
      • Margin
      • Terminator
      • Line Continuation
      • Comments
      • String Literals
      • Block Delimiters
    • Pascal Variables and Data Types
      • Variable and Type Declarations
        • Declaring the EQUEL Runtime Routines
        • The Declare Statement
        • The Inherit Attribute
        • Declaring Types and Variables to EQUEL
        • Reserved Words in Declarations and Program Units
        • Data Types and Constants
        • Pascal Data Types and Corresponding Ingres Types
        • Pascal Constants and Corresponding Ingres Types
        • The Integer Data Types
        • Pascal Integer Types
        • The Indicator Type
        • The Floating-point Data Types
        • The Double Storage Format
        • The Character Data Types
        • Declaration Syntax
        • Attributes
        • Label Declarations
        • The Syntax of Label Declarations
        • Constant Declarations
        • Type Declarations
        • Type Definitions
        • Renaming Type Definition
        • Enumeration Type Definition
        • Subrange Type Definition
        • Pointer Type Definition
        • Varying Length String Type Definition
        • Array Type Definition
        • Record Type Definition
        • File Type Definition
        • Set Type Definition
        • Variable Declarations
        • Formal Parameter Declarations
        • Assembling and Declaring External Compiled Forms
        • Concluding Example
      • Compilation Units and the Scope of Objects
        • Predeclared Identifiers
        • Compilation Unit Syntax
        • The Program Unit
        • The Module Unit
        • The Procedure
        • The Function
        • The Scope of Objects
      • Variable Usage
        • Simple Variables
        • Array Variables
        • Record Components
        • The With Statement
        • Pointer Variables
        • Indicator Variables
      • Data Type Conversion
        • Ingres and Pascal Data Type Compatibility
        • Runtime Numeric Type Conversion
        • Runtime Character Type Conversion
    • Dynamically Built Param Statements
    • Runtime Error Processing
      • Programming for Error Message Output
    • Precompiling, Compiling, and Linking an EQUEL Program
      • Generating an Executable Program
        • The EQUEL Preprocessor Command
        • Eqp Command Examples
        • The Pascal Compiler
        • Installing the EQUEL/Pascal Environment File
        • Linking an EQUEL Program
        • Assembling and Linking Precompiled Forms
        • Linking an EQUEL Program without Shared Libraries
      • Include File Processing
        • Including Source Code with Labels
      • Coding Requirements for Writing EQUEL Programs
        • Comments Embedded in Pascal Output
        • The Pascal Semicolon and EQUEL Statements
        • Pascal Blocks Generated by EQUEL
        • An EQUEL Statement that Does Not Generate Code
      • EQUEL/Pascal Preprocessor Errors
    • Preprocessor Error Messages
    • Sample Applications
      • The Department-Employee Master/Detail Application
      • The Employee Query Interactive Forms Application
      • The Table Editor Table Field Application
      • The Professor-Student Mixed Form Application

Embedded QUEL Companion Guide

The Professor-Student Mixed Form Application