Stack Overflow
Stack Overflow

Questions tagged [progress-db]

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

More information about the Progress DB and related technologies, including the Progress ABL (formerly Progress 4GL) can be found under the tag.

Progress Software corporate site: http://www.progress.com/

Progress OpenEdge product family: http://www.progress.com/products/openedge

343 questions
8
votes
2 answers

unixodbc driver manager cannot open specified library on install

I'm using ArchLinux and I am trying to install OpenEdge progress drivers so I can access it via PHP. I've installed the unixodbc package and the drivers, but when I test the connection via isql or PHP, I get the same error... # isql -3…
TheFrack
  • 2,823
  • 7
  • 28
  • 47
7
votes
1 answer

What is the Progress equivalent to SQL Management Studio?

I have a progress database that I need to connect to. What is their equivalent to the SQL Server Management Studio? The server appears to be Progress OpenEdge 10.1
NotMe
  • 87,343
  • 27
  • 171
  • 245
6
votes
2 answers

CASE expression with NULL value

I'm struggling to understand how to check for a null value in a progress case expression. I want to see if a column exists and use that, if not use the fallback column. For example, William in first name would be over written by Bill in…
Zonus
  • 2,313
  • 2
  • 26
  • 48
5
votes
4 answers

Exclude rows based on other rows (SQL)

Say I have a query like this: SELECT * FROM TABLE And it returns this: TABLE ID | DATA | VAL =============== 01 | ABCD | 1 01 | DEFG | 2 02 | FGHI | 3 02 | HIJK | 2 03 | JKLM | 3 03 | LMNO | 4 04 | NOPQ | 0 04 | PQRS | 1 Currently I have a query…
corsiKa
  • 81,495
  • 25
  • 153
  • 204
4
votes
4 answers

How to get the ROWID from a Progress database

I have a Progress database that I'm performing an ETL from. One of the tables that I'm reading from does not have a unique key on it, so I need to access the ROWID to be able to uniquely identify the row. What is the syntax for accessing the ROWID…
Stefan Moser
  • 6,663
  • 9
  • 35
  • 48
4
votes
1 answer

Better way to write Case When Multiple conditions

I have have written the below query to help me segment my data into different cells. This has over 200 conditions so i have only provided a small sample. Is there a better way for me to write this statement because from research Progress will not…
Jack Williams
  • 141
  • 1
  • 1
  • 15
4
votes
1 answer

Docker & OpenEdge 11.7.2

I have successfully managed to install Progress OpenEdge 11.6 32bit, 11.7 32bit and 11.7.1 32bit inside a Docker container, using the response.ini file. However, I cannot find a way to make 11.7.2 32bit working, and it's getting quite frustrating.…
SimpleFuzz
  • 69
  • 9
4
votes
1 answer

How can you connect to a ProgressDB data provider with Dapper?

Please read the comments of the answer for a more complete understanding of what the problem is/was First, I read through a lot of the other SO questions related to this and still can't get this to work with a basic setup. Here is the related…
akousmata
  • 1,005
  • 14
  • 34
4
votes
2 answers

SQL Server Import and Export Wizard Error: "Index was outside the bounds of the array" via 32bit ODBC data source?

I get an "Index was outside the bounds of the array." error when I do the following. 1) I launch the Import and Export Data Wizard (32 bit). 2) Data source: .Net Framework Data Provider for Odbc. 3) I provide a connection string and DSN for a 32 bit…
M. Travis Volker
  • 2,310
  • 3
  • 20
  • 21
4
votes
3 answers

Restoring an OpenEdge v10 database into v11

I am brand new to the OpenEdge database platform and so far am really struggling. I have a client who has given me a backup of his database (a single .bak file) which was taken from OpenEdge v10. I only have a OpenEdge v11 database server. We do not…
Mark Henderson
  • 2,586
  • 1
  • 33
  • 44
4
votes
2 answers

OpenEdge + Odbc + Linq

I found out there is no OLEDB or native ADO.NET driver for OpenEdge. Has anyone had success in using the OpenEdge driver with Linq or Entity Framework?
Tom Sawyer
  • 835
  • 2
  • 10
  • 32
4
votes
1 answer

Static vs dynamic queries in OpenEdge

Question is very common, let's see pros and cons of each in OpenEdge in terms of code readability, flexibility and performance off course. Static queries: + readability: convenient `buffer.field` notation + performance: higher (supposedly, need…
Progressive
  • 61
  • 3
  • 9
3
votes
2 answers

Limiting SQL query to 10,000 results by where clause only, by string field

I have an interesting issue that I'm struggling to solve. I am retrieving data from a DB via a web API. I have direct DB access for testing, but my application will need to read the data via the API. In the API I can essentially provide the where…
Nik Weiss
  • 422
  • 7
  • 18
3
votes
3 answers

Using Break By for Multiple Fields

I would like to ask how to use multiple break by in a for each statement. Sample: Car Code Color Code 0001 002 0001 002 0001 001 0005 003 0005 002 0007 001 0008 001 0008 005 0008 001 My code…
noob
  • 165
  • 3
  • 18
3
votes
4 answers

LIKE operator for Progress DB SQL

I'm trying to do something like this in Progress SQL (THIS IS NOT POSTGRES!) SELECT CASE WHEN code LIKE '%foo%' THEN 'Y' ELSE 'N' END as foo FROM bar However Progress does not support a LIKE operator. INSTR looks like it might do the job,…
Tarski
  • 5,360
  • 4
  • 38
  • 47
1
2 3
…
22 23