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
-1
votes
1 answer

How to check the availablility of a Progress database record with the values stored in a .csv file as input?

I am uploading a CSV file of records to check if these records are available in a specific Progress database table. How do I proceed?
Raja
  • 1
  • 2
-1
votes
1 answer

How to get range of records from TEMP TABLE with alphanumeric column?

I have a TEMP TABLE with an alphanumeric column and I want to get the range of records on basis of 2 filters. **Filters:** Begin filter and End filter. **For Example: Column data:** A123 A145 B002 B234 C095 C456 D001 D345 Begin filter -> A14 and…
user3797063
  • 13
  • 7
-1
votes
2 answers

Automatically move a log file from unix based server to pc

I'm trying to fetch few data from a Unix based server to my PC automatically ie I want the data to be transfered to my PC say every 30mins. I have the Unix code for fetching data but its through putty and it is getting stored in server only. I would…
San_man
  • 120
  • 1
  • 8
-1
votes
3 answers

Progress Database Performance issue?

We have recently upgraded to OE 11.3 version.The application and database appears to be slow in one particular location.But we didn't face any performance issues in the application or in the databases.i have checked few parameters in promon like…
user3715001
  • 131
  • 3
  • 18
-1
votes
1 answer

Why do we get time-stamp issue in progress database?

we have upgrade from 9.1 to 11.3 version.it was working fine for two days and later database went down.In the log file its mentioned .lk fie is deleted.we are getting the below error When we do proutil qhn -C truncate BI OpenEdge Release 11.3 as…
user3715001
  • 131
  • 3
  • 18
-1
votes
2 answers

Creating a linked server in SQL Server 2008 to Progress Open Edge 10.1C via ODBC?

I have a working ODBC connection to a Progress Open Edge 10.1C server (when I click "test connection" it passes) How can I create a linked server in SQL Server that uses the ODBC connection? I have tried but get this error message: I'm using SQL…
JK.
  • 21,477
  • 35
  • 135
  • 214
-2
votes
1 answer

How can I Get the most recent "Effective-date" that is less than or equal to the current date

Using Crystal Reports 2016, Progress Openedge 11.7 ODBC driver for DB connector I have been working with the "Add Command" function in crystal reports 2016, and the SQL Query I have created so far has gotten me the closest to my desired results, but…
Ken Goist
  • 1
  • 2
-2
votes
2 answers

PROGRESS SYNTAX USING OPENQUERY FOR DATEADD EQUIVALENT

I have an open query I am using to connect to a PROGRESS ODBC, I cannot get the syntax equivalent from SQL of SELECT DATEADD(DAY, -1, GETDATE())
Katherine Pacheco
  • 339
  • 3
  • 7
  • 24
-2
votes
1 answer

synchronizing progress database with sql Server database

Please I need to synchronize two databases one in Progress OpenEdge and the other is in SQL Server so that I have the same data in both databases. Do you have any idea if it is possible? If so: how can we do this?
user3928031
  • 21
  • 5
-2
votes
1 answer

Progress database one time password

I am using progress 4gl and progress database. I need a one time password procedure for security purposes. Do you have any idea. I need two options. how can I generate random password and how is the process method ? My progress version is 10.2b on…
Hikmet alemdaroğlu
  • 1
-2
votes
1 answer

how to get first 15 records with customer name,number from the table if there are 200 records in Progress OpenEdge database

I am trying to retrieve a records from database ,how can i get in order to fetch records from customer table. in table level without scoping can any one help
ravi nandhan
  • 11
  • 1
-3
votes
2 answers

Is there a way I can fast load data with SSIS?

I'm moving data from ODBC to OLE Destination, records get inserted everyday on the ODBC in different tables. The packages gets slower and slower it take about a day for million records sometimes more. The tables can have new data inserted or new…
sinesipho motloung
  • 1
-3
votes
1 answer

Error When load Table Progress Openedge in Power BI

Im very newbie in Power BI. I try to connect Progress Opendedge to Power BI using ODBC. ODBC success connect, I try Via excel success to show record. But in Power BI, when i try to load table i've got error. ERROR [HY000] [DataDirect][ODBC Progress…
Prabu Karana
  • 302
  • 1
  • 4
  • 15
1 2 3
…
22
23