Inspecting OpenEdge metadata with SQL OpenEdge’s virtual system tables (VSTs) provide excellent statistics that help in database development and maintenance. This article shows a few SQL statements that help reveal information about the database. SQL to query metadata Show all VST tables that contain metadata. SELECT * FROM sysprogress.systables WHERE tbl like ‘sys%’; Find columns […]
Create table with SQL in OpenEdge One of the most basic and important database objects is tables. We can create tables with either ABL or SQL. This article discusses how to create table with SQL and the various datatypes and constraints that can be used to create them. Documentation of create table is covered quite […]
Advanced delete with SQL from OpenEdge We saw how to Delete data from OpenEdge using SQL and ODBC in a previous article. We can delete data using ROW ID and subqueries. This article covers these two simple, yet very useful, means of deleting data from OpenEdge using SQL. Let’s assume that you have a client such as […]
Advanced ways to select data with SQL from OpenEdge We covered Select data with SQL from OpenEdge in a previous post. In this post we will review how JOINs, EXISTSs etc. are available to us when extracting data from OpenEdge with SQL. Let’s assume that you have a client such as DBeaver set up. Connect to your OpenEdge […]
Files to set up Setting up of ODBC connection to OpenEdge requires /etc/odbcinst.ini to be update with the right drivers. Once that is done, OpenEdge can be accessed by either using a DSN or DSN-less connection string. It is assumed that you have set up and tested your SQL ODBC connection drivers. If not, Installing OpenEdge […]
Progress OpenEdge SQL ODBC drivers You can obtain and install OpenEdge SQL Client Access drivers ODBC drivers (aka SQL ODBC drivers) from Progress’s Electronic Software Delivery (ESD) website. Contact Progress support or your account manager for details. SQL ODBC drivers for OpenEdge are available for Windows and Linux. This article focuses on installing SQL driver […]
Progress OpenEdge Applications SQL engine in OpenEdge is a modern tool to expose OpenEdge data via ODBC and JDBC directly to API and web applications. SQL engine is fast, mature and requires minimal setup. To me, it seems like SQL is a very viable alternative to ABL in building web applications. Character (CHUI) or desktop-based […]