352 questions
0
votes
1
answer
65
views
OpenEdge Replication - Time to Replicate? [closed]
For the last couple days, I've been monting a structure to apply replication across 3 databases (Will be more than 20 in the next couple months).
The replication process is OK, both databases (Source ...
- 440
0
votes
1
answer
68
views
How to convert date to datetime using JpaRepository in an OpenEdge/Progress database
I have 2 fields that make up a date with time in a Progress database. One is a date type, "inv-date", and the other is an integer, "inv-time". I want to get the max date with time ...
- 180
0
votes
2
answers
59
views
OpenEdge ODBC UPDATE for multi-tenant database
When using ODBC to OpenEdge multitenant database I can make query and get expected result.
SELECT "LogiVal" FROM PUB."SysCtrl" AS mtc WHERE tenantName_tbl (mtc) = ('tenantID') AND &...
- 11
0
votes
1
answer
243
views
how to use odbc-pool on Node.js project
Im trying to access a DSN on windows with a simple Node.js program that returns either a positive or a negative message. However, I keep getting the following message.
Error connecting to database: ...
0
votes
0
answers
103
views
Progress - How to concatenate many rows with same id in sql?
My table contains those values :
NODOS PROCEDURE PHASE
1 CXP PRB
1 CXP PEX
And I want this :
NODOS PROCEDURE PHASE
1 CXP PRB, PEX
I use the progress database. ...
- 29
0
votes
1
answer
132
views
Is it possible to set an OpenEdge 11.6.4 database in an Apache TomCat?
we use a client-server Openedge 11.6.4 database hosted in Windows Server, and Windows clients.
We need some devices (like barcode scanners) to send and receive data from the database.
So, I need to ...
- 75
0
votes
1
answer
504
views
How to run Openedge explorer?
I am new to Progress and have the Progress OE 12.2 developer Kit classroom version. Try to create an OpenEdge explorer connection using the studio and get the following error message.
"The ...
- 1
0
votes
2
answers
448
views
Read PostgreSQL tables from an Openedge program
I need to write an Openedge 11.6.4 ABL procedure that automatically:
Connects to a PostgreSQL database.
Read some info and write it in my OpenEdge DB.
Disconnect from PostgreSQL.
My problem is in ...
- 75
0
votes
2
answers
165
views
Progress 12.2 - Concat rows with same ID
I use the database Progress 12.2 and I want to group rows with same id
For example I have
ID Code
1 PB
1 RO
And I want :
ID Code
1 PB, RO
This is my request :
SELECT id, code FROM table WHERE ...
- 29
0
votes
1
answer
171
views
How do I make triggers fire without error when connecting to an OpenEdge 12.2 database using JDBC?
I am connecting to an OpenEdge 12.2.0 database using the latest OpenEdge JDBC driver. The OpenEdge database is using Eclipse Temurin JDK version 11.0.14.101 and the application that connects via JDBC ...
- 372
1
vote
1
answer
357
views
Data Factory does not reuse nor disconnects from ODBC connection (Progress DB)
I have a ODBC connection to Progress DB, via licensed Progress ODBC connector, version 11.7 (PROGRESS_OE_11.7_WIN_64_SQLCLIENTACCESS). ADF uses this ODBC connection to do various tasks, like copy data ...
0
votes
2
answers
649
views
Incorrect Syntax Open Query
I an doing update using open query on progress database which is connected to sql server using lined server . below is the query when I print :
UPDATE OPENQUERY(PROGRESSDB,'SELECT * FROM PUB....
- 179
0
votes
1
answer
250
views
I need to connect to a Progress database with laravel 9 framework, Somebody know how to do it?
I need to connect to a Progress 10.1B database with laravel 9 framework, Somebody know how to do it ?
0
votes
1
answer
125
views
How to validate against item master table
I am creating a custom report screen in which I have a fields item number, item type, prod line and status and there is a condition for item number that is I have to validate it against pt_mstr which ...
user19007432
0
votes
2
answers
95
views
How to SELECT a single record in table X with the largest value for X.a WHERE values for fields X.b & X.c are specified
I am using the following query to obtain the current component serial number (tr_sim_sn) installed on the host device (tr_host_sn) from the most recent record in a transaction history table (PUB....
- 23.2k
0
votes
1
answer
215
views
how to add and display specific records from code_mstr to temp-table in progress 4gl?
I want to create a temp-table for generalized code maintenance(code_mstr) this is what I have written for the temp-table creation
define temp-table tt_gcm no-undo
field tt_fldname like code_fldname
...
user19007432
0
votes
1
answer
101
views
How to be sure that only one record is taken into account at a given stage of the query?
I wonder how exactly the "queries" for each and first work.
lets say I have some tables A, B, C and D.
How many records will I find if I use sth like:
first B,
each C,
first D:
<block>
...
user10504208
0
votes
1
answer
409
views
How to call a mvsc dll (C++ or Rust) from Progress Open Edge
I have a dll that i want to call from Progress code but I can't complete.
I have tried with Visual Studio 2022, Windows C++ Dll and Rust Dll.
Windows C++, Visual Studio 2022 with Progress
Cpp
#...
- 143
0
votes
1
answer
2k
views
Is there anyway to create a Linked Server in an Azure Managed Instance to a Progress Database?
I'm in the process of testing/playing about with Azure. We have moved an on-premise SQL Server database to an Azure Managed Instance, however, this contained a linked server to a Progress database ...
- 2,707
0
votes
3
answers
2k
views
How to convert an integer (time) to HH:MM:SS::00 in Progress SQL
I need to create a SQL script to convert a integer field to varchar. My database is a Progress DB.
This integer field (nrHoraRegistro) has a timestamp converted in integer.
Is there a way to write a ...
- 100
0
votes
0
answers
329
views
How to get distinct count for larger column size in Progress-OpenEdge 12.2 query?
I'm getting ERROR [OpenEdge JDBC Driver][OpenEdge] Insufficient Memory. Memory allocation failed at 751 in Z:/vobs_sql/sql/src/rds/psr_bld1.cxx. Contact Progress Technical Support.
If I execute query ...
- 13
0
votes
3
answers
2k
views
What is the query for getting database name in Progress-OpenEdge?
How can we get database name in progress openedge like in SQL we can get database name by using show databases; or SELECT schema_name FROM information_schema.schemata; using SQL query to openedge DB.
- 13
1
vote
1
answer
1k
views
Progress-OpenEdge query to show Column Relations of the table
I want a query to get the column relation or reference of column for the table or for all the databases.
Like in MySQL, we have a query
SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE
...
- 13
0
votes
1
answer
712
views
Restore a Progress DB including the sequences
I am using backup and after imaging to save a server db.
Now i want to restore this db to my local pc.
prorest db %network_drive%:%backupPath%\db.bk
rfutil %db_destination%\db -C roll forward -ailist %...
- 53
0
votes
1
answer
830
views
Progress - Monitor Database Read & Writes
I'm new to all this and would like some guidance and I'm not sure if this is the correct place, any help would be appreciated and really aimed at someone who doesn't know what they're doing, not my ...
- 1