Questions tagged [openedge]

Progress OpenEdge is an application development platform from Progress Software Corporation

Progress Openedge

Progress OpenEdge is an application development platform from Progress Software Corporation (NASDAQ: PRGS). It includes but is not limited to:

Progress OpenEdge Database:
A relational database engine

Progress ABL:
Advanced Business Language. A 4GL programming language. Earlier known as Progress 4GL.

Progress AppServer:
An application server for supporting multi tier applications

Progress Pacific AppServer (PAS):
A newer replacement for the Progress AppServer. Based on Tomcat.

Progress Webspeed Transaction Server:
A part of the appserver used for creating web enabled applications.

Progress Developer Studio:
An IDE for developing Progress applications. Based on Eclipse.

Progress Mobile:
A cloud based IDE for developing mobile applications. Based on the Tiggzi IDE. Since the acquisition of Telerik this has been replaced with the Telerik Mobile platform.

Openedge BPM:
An API for providing Business Process Management automation in applications.

Progress Pacific PaaS:
A cloud based application development platform.

Questions around Progress Openedge is better tagged , , , or depending on what product is involved.

Simply tagging might be confusing since the questions are mixed up with progress-bars etc.

Other product lines in the Progress Software portfolio incudes:

Rollbase:
A cloud based rapid application development environment for webapps.

DataDirect:
Provides connectivity between the Progress environment and numerous data sources. For instance IBM DB2, Microsoft SQL Server, Oracle, Sybase and MySQL.

Control Tower:
Business Intelligence/Dashboard solution.

Corticon:
Business Rules Engine

Modulus:
A Node.js hosting platform including support for WebSockets, MongoDB and more.

Telerik
On October 2014 it was announced that Progress Software acquired Telerik Software, a Bulgarian company providing tools for platform development. If or how Teleriks product will be incorporated into OpenEdge has not yet (as of November 2014) been revealed.

Official links
Progress Software

Progress Community (Developers Network)

Progress Documentation Portal

Progress KnowledgeBase

Other useful links
The OpenEdge Hive

Progress E-mailing list (PEG)

ProgressTalk Forums

Wikipedia
http://en.wikipedia.org/wiki/Progress_Software http://en.wikipedia.org/wiki/OpenEdge_Advanced_Business_Language

1417 questions
3
votes
2 answers

Openedge : an If..then condition in Open Query - Performance issue

open query q for each notepad no-lock where notepad.ctrl-code = pCode and (if pE-num = 0 then notepad.k-num = pk-num else notepad.e-num = pe-num) my question is that - will the if condition in where clause causes the query to run slow?
3
votes
2 answers

How to leave out of FOR EACH statement in Progress?

I am struggling with getting only first 2 records from a table via FOR EACH. My goal is to read only first 2 records from a table, and save one field value to the variables. Let's say I have the table MyTable with fields PartNr, CreationDate,…
Smokus
  • 149
  • 1
  • 9
3
votes
2 answers

How to change the default format of DATE variables in OpenEdge Progress?

Default DATE format when displaying dates is DD/MM/YY I want to change that to DD.MM.YYYY This is just a simple program: DEFINE VARIABLE daDate AS DATE NO-UNDO. daDate = TODAY. MESSAGE daDate. Currently the output looks like this: 16/09/20 I…
Smokus
  • 149
  • 1
  • 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
2 answers

Progress 4GL: Regarding OUTPUT TO statement

What happens when I don't give directory path? Where the file is exported? DEFINE VARIABLE cPath AS CHARACTER NO-UNDO. cPath = STRING(MTIME) + "_user.out". OUTPUT TO VALUE (cPath). MESSAGE "In side a file". OUTPUT CLOSE.
Bharat
  • 177
  • 7
3
votes
1 answer

How to send data to Jasper Report using Node js?

I'm new to Jasper Reports and trying to connect jasper reports with my node js (express) application. For that, I have tried node-jasper node module & unfortunately, I'm unable to send data to jasper report because I couldn't understand how that…
RangaKES
  • 31
  • 1
  • 2
3
votes
3 answers

How to calculate age from date of birth in OpenEdge ABL?

I am new to progress and I want to calculate age from the date of birth and I have no idea how to do it. If anyone knows about this please help me. Thanks in advance. What I have tried so far is: define var dob as date. define var age as…
Ajay Jangra
  • 174
  • 1
  • 13
3
votes
1 answer

Calling a procedure from another file

I'm trying to call a procedure which is is another file. What I've got so far results in an error: test.p DEFINE VARIABLE tmp AS CHARACTER. RUN sumWords.p(INPUT "Hello", INPUT "World", OUTPUT tmp). DISPLAY tmp. sumWords.p PROCEDURE…
sander
  • 1,426
  • 4
  • 19
  • 46
3
votes
2 answers

Convert DD-MMM-YYYY HH:MM:SS.SSS to Progress DATETIME-TZ

Is there an easy way to convert a date time value in format DD-MMM-YYYY HH:MM:SS.SSS to Progress DATETIME-TZ. For example, I am trying to store "15-Sep-2017 20:51:14.566" date in to Progress ABL variable whose datatype is datetime-tz with format…
Austin
  • 1,237
  • 1
  • 11
  • 22
3
votes
2 answers

Last Imported Line Is Empty Input Stream Progress

I have made a script that does an import of an CSV file. It work perfect however when I import it into a temp table the last record in my temp table is an empty one. I've tripled checked the CSV and it doesn't contain any empty lines. This is my…
Gaetano Herman
  • 524
  • 6
  • 22
3
votes
2 answers

How to add a date condition to for each loop in Progress 4GL query?

I have difficulties with a query I have to change to limit the data I export from a Progress database. I export "myorderdate" to a text file. However, I have to limit the data to only orders after year 2012. OUTPUT STREAM s1 TO…
DamianS1987
  • 302
  • 1
  • 3
  • 13
3
votes
2 answers

Multithreading in OpenEdge

Is there any concept like multithreading in OpenEdge? If so, please give me a brief about it. I want to create a snake game in OpenEdge. For that, the user has to control the object but once the application has started, no user interaction is…
D_Animus
  • 43
  • 9
3
votes
3 answers

OpenEdge 10.2A - INPUT THROUGH set does not work after Windows Update 1703 on Windows 10

We were using below code to get the name of the computer. def new shared var cHost as char format "x(40)" no-undo. INPUT THROUGH hostname NO-ECHO. SET cHost. INPUT CLOSE. DISPLAY chost. After we have updated our computers (Windows 10 - 1703),…
aza
  • 115
  • 13
3
votes
1 answer

How to deploy Trireme project on Apigee using Apigeetool

I have design a data layer API to establish openedge database connection using trireme-jdbc. The code is working solid when I am running the file by trireme command using cygwin, but when I start the complete project through apigeetool using command…
ANIL VISHVKARMA
  • 363
  • 1
  • 15
3
votes
1 answer

How to trim a string based on specific criteria in progress openedge 4gl?

ABC+123:xy+123++23'EFG+123:xy+123++23'GHI+123:xy+123++23+mki+123'LMV++123:xy' I have above string . Apostrophe(') acts as a terminator which denotes end of segments . Hence ABC+123:xy+123++23 is a segment , its start tag is three chars ABC which is…
mac100
  • 137
  • 2
  • 13