Questions tagged [progress-database]

Progress OpenEdge Relational Database Management System (RDBMS) is a database server created by Progress Software Corporation.

Filter by
Sorted by
Tagged with
0 votes
2 answers
53 views

Left Outer Join possible? [closed]

i have a problem which needs to get resolved and i hope some of you can help. i have an article table (Table A) Article Description A43234 desk A42323 paper A43235 chair and a ...
user avatar
0 votes
1 answer
206 views

How to delete the primary index of a table in Progress, release 11.6?

I have made a table, containing an integer field, this field being used in the primary index of that table. Now I would like to replace this integer field by a character one. Therefore I need to ...
user avatar
  • 463
0 votes
1 answer
82 views

Progress Open Edge Union

I am attempting to union together 2 queries in progress DB Unfortunately, this is returning me a syntax error. Are union queries unsupported in progress DB? SELECT 0, 'All' UNION ALL ...
user avatar
0 votes
1 answer
49 views

Heavy performance drop on Progress query, looks like based on string character inside table

I'm launching following query on a Rel 11.6 Progress database: FIND FIRST Table1 WHERE Table1.Field1 = 1 AND Table1.Field2 >= 2 AND TRUE ...
user avatar
  • 463
1 vote
1 answer
38 views

generate a series of dates in progress-db

I am looking for a way in progress-db to generate a series of dates in the same way I would in PostgreSQL. select date::date from generate_series( '2021-01-07'::date ...
user avatar
-2 votes
1 answer
561 views

Add a day to a date in Progress OpenEdge db query

I am looking for a way to increment a date value by one day in Progress OpenEdge DB query. I am using the OpenEdge SQL-92 query engine rather than the ABL (4gl) engine. Something similar to how one ...
user avatar
0 votes
2 answers
49 views

How can I copy the definition of a field from one table to another at design-time?

I have a table with ten fields, f1 (being an integer field) to f10 (being a character field). In between there are other integer, character and date fields. I would like to copy those field ...
user avatar
  • 463
0 votes
1 answer
130 views

What is an ODBK file and how to restore that?

I have recently come across a situation where I am required to restore an ODBK file. Basically this is a database file of Intergy Server (An EHR platform). I don't know how to restore that file into a ...
user avatar
0 votes
2 answers
41 views

how to open a corrupted progress v9.1e database

How can I open a corrupted PostgreSQL v9.1e database which has data that was added after it was last backed up?
user avatar
0 votes
2 answers
900 views

How can I stop a single Progress OpenEdge server process and not the whole database?

Is there a way to stop a single _mprosrv process started by the database broker? All I can find from documentation and google searches are ways to disconnect a single user connection or shut down the ...
user avatar
  • 111
1 vote
1 answer
31 views

locked records progress4gl

I have a query that runs from the sql engine in a progress DB. My problem is when a table or a record is locked from the progress4gl engine, I can't access it from sql engine and the query returns ...
user avatar
  • 11
0 votes
1 answer
749 views

OpenEdge Progress Replication

There's data sitting in OpenEdge Progress databases. We'd like to replicate that data to a PostgreSQL "datalake" using a software called HVR (high volume replication I think). What the software does ...
user avatar
1 vote
1 answer
1k views

SSIS creates too many connections to a database

I wonder if anyone had experienced anything similar to the following problem? I have a SSIS package containing 10+ data flow tasks which I'm using to extract data from an OpenEdge 11.3.002/Progress ...
user avatar
0 votes
1 answer
225 views

SSIS for/each loop to ETL tables across databases [duplicate]

I have 100 pre-written SQL Server table insert statements, to pull data from a Progress database via openquery into 100 SQL Server tables e.g. insert into table1 (col1 varchar(50), col2 varchar(10)) ...
user avatar
0 votes
1 answer
49 views

Prostrct create causes windows batch file to exit

I have a daily job to restore a database from last night's back up before doing other things to it and moving on. I'm trying to automate this with a script, but when I get to the following command the ...
user avatar
  • 173
2 votes
1 answer
1k views

Issuing Inserts/Updates to Progress OpenEdge via ODBC

I'm attempting to build some ETL to integrate our SQL Server environment with a remotely hosted 3rd party app running Progress OpenEdge. I have a linked server to it set up in SQL Server 2014. Selects ...
user avatar
  • 1,544
2 votes
6 answers
3k views

Export data from a CCURE 800/8000 System using a pair of ODBC data sources?

I'm working on a security system called CCURE 800/8000 and trying to export some entrance / exit data from the Activity Monitor that logs when people use their badges to enter and exit the building. ...
user avatar
  • 1,672
1 vote
1 answer
290 views

Partial restore of Progress DB

I have progress .bup files for my databases The environment I am restoring too has less space and because I have no control over this environment I wish to make the databases smaller. To do this I ...
user avatar
  • 131
1 vote
1 answer
885 views

How do I open a Progress .bup file?

I have a .bup file which is supposed to be a Progress database file. My question is, how can I open/restore it and look at the data?
user avatar
  • 11
0 votes
3 answers
1k views

Reasons for incremental backup on Progress OpenEdge

In the case that storage is not a problem: are there actually any good reasons for doing incremental backups instead of just doing full backups? Edit This could actually refer to any database with ...
user avatar
  • 194
1 vote
3 answers
4k views

Select statement is locking a record

We have a process which selects a record from a progress table, then issues an update against that record. If we do not do the select, then the update works all day long. If we do the select, then ...
user avatar
  • 867
4 votes
2 answers
6k views

SQL Server Linked Server to Progress is slow with an openquery view

We have a SQL Server database setup with a Linked Server setup connecting to a Progress OpenEdge database. We created a SQL Server view (for using with SSRS) of some of the OpenEdge tables using code ...
user avatar
2 votes
2 answers
3k views

Export pipe-delimited data with progress db

I've been handed a task where we need to dump specific tables in a progress database (10.2B) to pipe-delimited flat files (50+ tables) and send them to a third party for analysis every week. Looking ...
user avatar
3 votes
1 answer
250 views

Create incremental/differential backups in ProgressDB

Is there a way to create incremental/differential backups in ProgressDB?
user avatar
0 votes
2 answers
7k views

Progress OpenEdge - how to remove lock from table?

I have some kind of bug leaving lock on table in application that is connecting to Progress OpenEdge Database. Because of the lock I'm not able to test what app is doing wrong there (since I can't ...
user avatar
  • 625