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
3
votes
2 answers

Fixing sql length error in progress 4gl 10.2B

I'm trying to use the openedge jdbc connector to pull data from an existing progress db but im running into column width issues. Here is the error that is holding me up. [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column TabDisplayName in table…
Mike M
  • 212
  • 3
  • 11
3
votes
3 answers

SSIS Package Runs in BIDS but fails with an Architecture Mismatch in SQL Agent

I have an SSIS package that uses an ODBC connection to a Progress database as a source using a 32-bit ODBC driver. This package runs perfectly within the confines of BIDS. However, when I run it using the SQL Agent, it fails with the error: The…
Mitchell Bagley
  • 61
  • 6
3
votes
2 answers

ODBC lib Specified driver could not be loaded

I am trying to install ODBC drivers and I am running into brick walls. [root@Crux pkg]# isql -v [IM002][DataDirect][ODBC lib] Data source name not found and no default driver specified [ISQL]ERROR: Could not SQLConnect [root@Crux pkg]# isql -3…
TheFrack
  • 2,823
  • 7
  • 28
  • 47
3
votes
3 answers

How in the world can you Get a CSV dump of a 10.1b Progress database?

I am trying to get a CSV dump from a Progress / OpenEdge 10.1b database. This was a database for Intergy EHR so the version of openEdge that shipped with the application is run-time only. I can't compile dump scripts or use Data Adminstration tool…
funkenstein
  • 293
  • 6
  • 17
2
votes
1 answer

ODBC Connection with OpenEdge and Power BI

I'm having some issues while connecting from OpenEdge ODBC and Power BI. The issue isn't in the connection, but on SQL parameters. What I have tried so far: Connecting without SQL Parameters, but I'm having the 'COLUMN at TABLE has value exceeding…
Raphael Frei
  • 361
  • 1
  • 10
2
votes
1 answer

Select on field Date in OpenEdge

I am trying to make a select on the field 'Date' in the table UVT_DatesOfVersionsBOPos using the Microsoft SQL Server Management Studio (select * from openquery ([PROALPHA], 'select Date from PAVAR.PUB.UVT_DatesOfVersionsBOPos') Unfortunately I get…
mschneider
  • 21
  • 1
2
votes
1 answer

Select Column Names for OpenEdge-SQL

I'm using DBeaver to connect to Open-Edge 11 database which supports SQL functions. The functions used HERE don't work. Here is a single example and the result: Function: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME =…
Cornelis
  • 1,065
  • 8
  • 23
2
votes
1 answer

Convert datetime (YYYY-MM-DD HH:MM:SS) to decimal for openquery to progress database

I am trying to convert the current date to a decimal number. The reason I want to get a decimal number is to convert that decimal number to a Julian date. Because of performance reasons I need to do this with an OPENQUERY. The linked database is a…
Chris America
  • 33
  • 5
2
votes
1 answer

SQL list all apartments with actual owner

I'm trying to use a query to list all apartments with actual owner. My apartment table look like this: building | apartmentNbr | owner | start | end b1 | a1 | o1 | 2009-08-13 | 2010-08-13 b1 | a1 | …
b.delbrouck
  • 25
  • 3
2
votes
2 answers

Time taken to run a loop (Progress 4GL)

I wrote a query which contains multiple for each statements. The query is taking more than 20 minutes to fetch the data. Is there a way to check what time each loop started and ended. (How much time does each loop takes to execute and also the total…
Varun Sulabha
  • 67
  • 7
2
votes
2 answers

What is the purpose of the -char parameter in SQL Explorer?

I recently started using Progress OpenEdge and am confused about the purpose of the -char parameter to the sqlexp (SQL Explorer) command from Progress's command line utility, Proenv. I have looked at the documentation here, but apparently Progress…
Jeff Moorhead
  • 181
  • 1
  • 15
2
votes
3 answers

How to Count Distinct on Case When?

I have been building up a query today and I have got stuck. I have two unique Ids that identify if and order is Internal or Web. I have been able to split this out so it does the count of how many times they appear but unfortunately it is not…
Jack Williams
  • 141
  • 1
  • 1
  • 15
2
votes
1 answer

How to query table size, max size and row count in Progress OpenEdge Database

I am connected to an OpenEdge Database using JDBC and I want to query information like table size, max size, and row count. Any help would be highly appreciated.
mor222
  • 400
  • 7
  • 16
2
votes
1 answer

Migrating from PROGRESS to SQL Server 2008 - how?

I'm faced with a task I don't know how to proceed with: migrate a 120 GB database from PROGRESS to SQL Server 2008. I've quite frankly never even heard of PROGRESS and can't really make much sense of their web site either.... what I have is a folder…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
2
votes
1 answer

Progress Database 4GL - Math calculate for export file

The statements below will execute. However, I want the wShipment.Volume divided by 1728 and export that result. For example, if wShipment.Volume is 3456, then it should export the result 2 to the report. OUTPUT TO…
Joe
  • 31
  • 4
1
2
3
…
22 23