Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [progress-database]

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

Progress Software makes a software suite called OpenEdge that includes OpenEdge Database Products as well as tools for creating applications connected to the same database. The OpenEdge Database is supported on multiple Windows, Linux, and Unix platforms. It provides an interface for the OpenEdge ABL language as well as SQL support with ODBC and JDBC APIs.

26 questions
4
votes
2 answers

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 similar to the following: CREATE VIEW accounts…
CodeHulk
  • 61
  • 2
  • 5
3
votes
1 answer

Create incremental/differential backups in ProgressDB

Is there a way to create incremental/differential backups in ProgressDB?
Anthony Miller
  • 155
  • 1
  • 1
  • 5
2
votes
6 answers

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. There are two ODBC DSNs listed on the machine…
leeand00
  • 1,722
  • 6
  • 20
  • 36
2
votes
2 answers

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 at the sqldump command it seems it only supports…
Jeremy Holovacs
  • 1,271
  • 4
  • 20
  • 27
2
votes
1 answer

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 are working well enough, though I find that…
SQLFox
  • 1,564
  • 12
  • 23
1
vote
1 answer

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 need to exclude certain tables from the restore…
AquaAlex
  • 131
  • 1
  • 6
1
vote
1 answer

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?
Filip
  • 111
  • 2
1
vote
1 answer

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 ,'2021-01-12'::date …
Daniel L. VanDenBosch
  • 408
  • 1
  • 7
  • 17
1
vote
3 answers

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 the update times out. The select query is pretty…
ChrisLively
  • 887
  • 3
  • 10
  • 19
1
vote
1 answer

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 nothing for that lock. Is there any way to access…
Oscar
  • 11
  • 1
1
vote
1 answer

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 database to SQL Server 2016 via an ODBC driver.…
Hologram
  • 11
  • 2
0
votes
2 answers

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 test it more than once because of lock and lock…
korda
  • 635
  • 2
  • 7
  • 11
0
votes
3 answers

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 full & incremental backups. In this case we use a…
Jensd
  • 194
  • 2
  • 13
0
votes
1 answer

Progress SQL no lock

I need to be able to run a query without table locking. How would I accomplish this. SELECT * FROM pub.my_table with no lock WHERE my_table.description LIKE 'white bunnies' ORDER BY created_at
Daniel L. VanDenBosch
  • 408
  • 1
  • 7
  • 17
0
votes
2 answers

Left Outer Join possible?

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 attribute table (Table B) Attribute Article …
Andre
  • 3
  • 1
1
2