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
2answers
51 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 ...
0
votes
1answer
58 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 ...
0
votes
1answer
36 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 ...
0
votes
1answer
20 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 ...
1
vote
1answer
25 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 ...
-2
votes
1answer
198 views

Add a day to a date in progress open edge [closed]

I am looking for a similar way to add a day to a date value in progress DB the same way you would in SQL server? --first attempt SELECT DateAdd("d",1,EffDate) FROM pub....
0
votes
2answers
43 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 ...
0
votes
1answer
83 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 ...
0
votes
2answers
34 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?
0
votes
2answers
732 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 ...
1
vote
1answer
29 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 ...
0
votes
1answer
676 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 ...
1
vote
1answer
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 ...
0
votes
1answer
204 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)) ...
0
votes
1answer
48 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 ...
2
votes
1answer
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 ...
2
votes
6answers
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. ...
1
vote
1answer
286 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 ...
1
vote
1answer
864 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?
0
votes
3answers
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 ...
1
vote
3answers
3k 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 ...
4
votes
2answers
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 ...
2
votes
2answers
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 ...
3
votes
1answer
247 views

Create incremental/differential backups in ProgressDB

Is there a way to create incremental/differential backups in ProgressDB?
0
votes
2answers
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 ...