Flex2SQL Indexes in the Backend

Picture of Mertech Mertech : Feb 25, 2008 5:57:00 PM

DataFlex

When you add a segment to table with our drivers there is a representation of those in the backend (MS SQL, Oracle, MySQL and PostgreSQL).


These are the column suffixes of these segments:

INVC - Case sensitive
INVD - Descending
INVB - Both options


These will only be created when the column is a segment with these options.

 
Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Picture of Riaz Merchant Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...

Btrieve btr2sql PostgreSQL Modernization ISAM
Read More
Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Picture of Riaz Merchant Riaz Merchant: Oct 18, 2024 9:21:56 AM

COBOL applications are the foundation of numerous essential business functions, especially within the banking, insurance, and government sectors....

Btrieve MS SQL Server Oracle PostgreSQL COBOL
Read More
Application Modernization 101: Ultimate Guide to Digital Transformation

Application Modernization 101: Ultimate Guide to Digital Transformation

Picture of Mertech Mertech: Jul 6, 2024 12:30:00 PM

Imagine breaking free from the constraints of old, monolithic systems and embracing the agility and innovation of cloud-based solutions.

Cloud and hybrid cloud Modernization
Read More