Creating data with SQL and ODBC in OpenEdge INSERT statement is used for creating data in OpenEdge using SQL and ODBC. SELECT INTO can also be used to create data. This article does a deeper dive on the INSERT statement. We’ll cover the use of sequences, populating default values and inserting with JOINs. We’ll cover inserting […]

DBeaver SQL Client for OpenEdge Progress does not have a SQL Client like Microsoft has SQL Server Management Studio or MySQL has Workbench. DBeaver is an excellent SQL Client for OpenEdge using JDBC. This article discusses how to configure DBeaver to connect to OpenEdge using JDBC and execute SQL statements. Install DBeaver This article will […]

Delete data with SQL from OpenEdge We will attempt to delete data from OpenEdge database table similar to how we updated data into OpenEdge. Let’s assume that you have a client such as DBeaver set up. Connect to your OpenEdge database using ODBC. In my examples, I am using Sports2000 database. Let’s update the last department […]

Update data with SQL in OpenEdge We will attempt to update data into OpenEdge database table similar to how we inserted data into OpenEdge. Let’s assume that you have a client such as DBeaver set up. Connect to your OpenEdge database using ODBC. In my examples, I am using Sports2000 database. Let’s update the last department […]

Select data with SQL from OpenEdge We will attempt to select data from OpenEdge database table. Let’s assume that you have a client such as DBeaver set up. Connect to your OpenEdge database using ODBC. In my examples, I am using Sports2000 database. Let’s select departments from DEPARTMENT table. The fields of DEPARTMENT table are: DeptCode […]

Create/Insert data with SQL in OpenEdge We will attempt to insert data into OpenEdge database table. Let’s assume that you have a client such as DBeaver set up. Connect to your OpenEdge database using ODBC. In my examples, I am using Sports2000 database. Let’s create a new department into DEPARTMENT table. The fields of DEPARTMENT table […]