Using Multiple MySQL Ports in the Same Application

This is a code example of this command:

SET_DATABASE_PORT OF MYSQL TO PORT

Login <server1> <user> <passwd> "mdsmysql"


SET_DATABASE_PORT OF MYSQL TO 5576

Login <server2> <user> <passwd> "mdsmysql"
Open Test1
Showln "Test1 - Server1"
Clear Test1
Repeat
Find Gt Test1 By Index.1
[ Found ] Begin
Showln Test1.Customer_Number " - " Test1.Name
Indicate Found True
End

Until [ Not Found ]
Open Test2
Showln
Showln "Test2 - Server2"
Clear Test2
Repeat
Find Gt Test2 By Index.1
[ Found ] Begin
Showln Test2.Customer_Number " - " Test2.Name
Indicate Found True
End

Until [ Not Found ]
Showln
Showln "ok ..."
Inkey Pageend

 

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

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

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

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

Read More
Application Modernization 101: Ultimate Guide to Digital Transformation

Application Modernization 101: Ultimate Guide to Digital Transformation

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

Read More