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

Getting restoration size from a Progress-4gl database

How can I determine how much storage space on disk a restored database will consume once it has been fully restored? The purpose of this is to ensure that there is enough storage space before attempting to restore the database.
Preston Martin
  • 2,789
  • 3
  • 26
  • 42
2
votes
2 answers

adding a constant value to the results of an progress query

Is there anyway to add a constant value in the results of a progress query? In sql server you can do it by going select *, 1 As DateID from dbo.customers 1 being the static field inserted Not sure how or if you can do this in a progress db?
Shiniece
  • 37
  • 1
  • 4
2
votes
2 answers

How to overcome "Failure getting record lock on a record from table"?

I am running a query using OpenQuery and getting a peculiar error. This is my query: select * from OpenQuery("CAPITAOC",'SELECT per.* FROM pub."re-tenancy" AS t INNER JOIN pub."re-tncy-person" AS per ON t."tncy-sys-ref" =…
Steve Staple
  • 2,983
  • 9
  • 38
  • 73
2
votes
1 answer

query to find primary index for a progress table (openegde V11.6)

In the previous versions of Progress database (9.X, 10.X) the below query works fine to find the primary index of the table. select "_index-name" from PUB."_index" in, PUB."_file" fi where fi."_file-name"='tableName' and in."rowid" = …
Vel
  • 67
  • 11
2
votes
0 answers

Connection failure node js to progress db without odbc connection (Using trireme)

I am able to connect progress db using node js with odbc connection. But, I am unable to connect without odbc connection. I found a node js module which helps to make this connection but it shows some errors like. C:\Program …
Anvesh Reddy
  • 171
  • 1
  • 5
2
votes
2 answers

ODBC Error "Column x in table y has value exceeding its max length or precision"

I get this error from Progress database when running the following query using ODBC: SELECT distinct Table.column, { fn CONVERT(SUBSTRING(Table.ProblematicColumn, 1, 60), SQL_VARCHAR)} as test FROM PUB.Table WHERE ( Table.id IN ( …
David
  • 2,528
  • 1
  • 23
  • 29
2
votes
1 answer

How to secure data transferred over ODBC connection using Progress DB

We have an application (written in PHP) that fetches data from several remote Progress databases. The way it is working now, we ask our clients to open a port in their firewall to our IP, then we're able to run queries using ODBC connection from the…
David
  • 2,528
  • 1
  • 23
  • 29
2
votes
2 answers

OpenEdge progress database insert row - Beginner

i need to insert new rows into my database. OUTPUT TO c:\temp\SMLeiste_bearbeiten.csv. DEFINE VARIABLE size AS CHARACTER NO-UNDO FORMAT "x(3)" LABEL "Size". for each S_Artikel where S_Artikel.Selektion matches "KSE*" or S_Artikel.Selektion…
Guardian
  • 23
  • 5
2
votes
1 answer

Openedge syntax for TIME minus 4 hours

I am trying to figure out how to write a Openedge query where i can look back 4 hours. i have struggled with the TIME syntax before. If i understand correctly, the TIME representation in Openedge is in seconds starting from midnight. The query i am…
user3818093
  • 21
  • 3
2
votes
0 answers

Linked Server to Progress - inconsistent metadata

I'm working on a systems integration with Progress (10.2B SP6). I'm using SQL 2012 and the Progress ODBC 64-bit driver. I created a linked server and the majority of my queries work, but queries against 3 tables fail with this message Msg 7353,…
mark1234
  • 1,110
  • 2
  • 24
  • 41
2
votes
2 answers

SQL SSIS import error: PROGRESS openedge wire protocol column in table has value exeeding its max length or precision

I'm importing data from a progress database. I am getting the following error: Progress openedge wire protocol column in table has value exeeding its max length or precision Is there a way to specify a specific length of the select column's…
Dawie van Niekerk
  • 23
  • 6
2
votes
3 answers

How to know the number of records accessed by a program in Progress-4GL?

I'm trying to know how many records a running program is accessing. I found the VST _TableStat, but it doesn't group the number of records by program. FOR EACH _TableStat NO-LOCK WHERE _TableStat._TableStat-Create > 0 OR…
rubinhos
  • 77
  • 7
2
votes
1 answer

Which Progress datatypes correspond to which SQL Server datatypes?

I need to import data from a Progress server to a SQL Server. As an intermediate step, I need to figure out the corresponding datatypes of the fields in the Progress server. I'm not having much luck finding this online. Does anyone have a table of…
SaintWacko
  • 854
  • 3
  • 14
  • 35
2
votes
1 answer

Progress database administrator password recovery or reset

A client of mine have a progress 7.3 database. The company that made the system is out of business, and he wants to export the data to text files. However, the company did not give him the admin password. The question is: how can we reset/recover…
Zein
1
vote
1 answer

Console Command Utility for progress?

A customer has a progress database and I need to be able to connect using a command line client. Does such a thing exist? Ive seen on the server you can launch proenv and run sqlexp, and I'd like to be able to do similar from a dev machine to the…
Andrew Bucknell
  • 1,880
  • 3
  • 21
  • 32
1 2
3
…
22 23