• Docs »
• Flex2SQL v17.2 »
• Classic Edition »
• Programmer’s Guide

Programmer’s Guide¶

• Introduction
  • All Drivers are not Created EQUAL!
  • Key Features of the Mertech Drivers
• Driver Basics
  • Running your Program
  • Integration with DataFlex
• Installation
  • Installing for Linux
  • ciText for PostgreSQL
  • Important Oracle Information
    • Oracle License Count View
• The Flex2SQL Classic Migration Utility
  • Database Migration
    • Table Creation and Restructuring
    • Index Maintenance
    • Index Name Mapping
    • Inverse Key Maintenance
    • Relationship Synchronization
    • Scripting Options
• Deploying Database Updates
  • Macro Commands to Create Restructuring Code
• Migrating from non-Mertech Drivers
  • Performing a Complete Migration
  • Setup
    • Migration Steps
  • Switching MS SQL Drivers without Migration
    • Migration Steps
• CL2SQL - Command Line Tool for Unattended Migration
• Database Design
  • Overlaps
  • Relationships
• Understanding Mertech Files
  • INT Files
    • Location of Login Details
  • MERTECH.INI Configuration File
• Working Without an INT File
  • Setting Table Attributes Dynamically
    • Example: Opening a System File
    • Example: Opening a Table containing Index Definitions
    • Example: Opening a Table with Overlap Fields and Relationships
• Table Restructuring
  • Database Server as the Source of Truth
• Accessing Updated Tables in DataFlex
  • DataFlex as the Source of Truth
• Transactions and Locking
  • Locking Overview
    • DataFlex Locking
    • Locking with Mertech Drivers
• NULL Handling
  • DataFlex Applications
    • Datetime
    • Migration Options
    • Commands related to Nulls
• Tracing & Logging
  • Migration Report
    • Clearing the Migration Report
  • Driver Trace
    • Enabling Driver Trace for Migration Logging
    • Enabling Driver Trace for Application Logging
    • Selecting the Trace Level
    • Tracing to the Windows Debug Channel
  • Service Mode
• Error Handling
• Performance Tips
  • Optimize Transactions and Locking
    • Use REREAD
    • Use Data Dictionaries with Smart File Locking
    • Move Filtering to the SQL Server
    • Support for SQL filters at the DDO level
    • Identify Missing Indexes
    • Defragment the Database
    • Recompute Index Statistics
    • Move Business Logic to the SQL Server
    • Consider Cache Performance
    • Use Lazy Open Mode
• Custom OEM to ANSI Translation
  • Custom OEM to ANSI Translation in MERTECH.INI
• LocalDB
  • Installing LocalDB
  • Creating a Database
  • Commands related to LocalDB
• UUIDs as Dynamic Primary Keys
  • Advantages of Using UUIDs
  • Disadvantages of Using UUIDs
  • Clustered Indexes
    • Sequential Key
    • Random Key
    • Sequential UUIDs
  • Alternate Primary Keys
• Binary Large Objects (BLOBs)
  • MS SQL Server
  • MySQL & MariaDB
  • PostgreSQL
    • PostgreSQL Example
• Connection Management
• Compatibility Issues with DataFlex 19.1+
  • Description
  • Senario #1: Use only DataFlex commands, hardcoded server login
  • Senario #2: Use both Dataflex and Flex2SQL commands
• Multi-Company Setups
  • Create the Table and Copy the Data
  • Update your Application