Questions tagged [4gl]

A programming language with a specific domain intended, such as business or science, in which the basic units are of a higher abstraction or power.

Following on the heels of 3GL languages such as C, COBOL and Pascal, the promise of the 4GL was to solve the problem at a higher level of abstraction. A 4GL would be designed with a specific problem domain in mind, such as commerce.

Many 4GLs did not go on to fulfill their initial promise, as 3GLs continued to expand in power and scope, and standardized libraries became more pervasive. The line today between a 3GL and a 4GL is blurry; most modern languages could be considered 4GLs.

Simply tagging your post should be avoided. It's better to tag your post with a tag of your specific 4GL-language. Or at least add the language tag to the 4GL-tag.

Examples:

Informix 4gl can be tagged .

Progress 4GL/ABL -->

Ingres -->

etc.

175 questions
1
vote
4 answers

How to fill missing values in numeric columns by using 0 in one table base on existing these columns in other tables in SAS Enterprise Guide?

I have tables in SAS Enterprise Guide like below: TABLE 1 COL1 | COL2 | ... | COLn -----|------|------|------- 123 | | ... | xxx | AAA | ... | xxx 122 | BCC | ... | xxx ... | ... | ... | xxx And also 2 other tables like…
dingaro
  • 2,156
  • 9
  • 29
1
vote
1 answer

Remove duplicates inside a sequence of records in a group with SAS

Is it possible to remove duplicated records in sequence inside a specific group and output only last of them (based od date) with 4GL (SAS)? I have data like: data example; input obs id dt value WANT_TO_SELECT; cards; 1 10 1 500 0 2 10 2 750 1 3 10…
Dreamer
  • 13
  • 3
1
vote
3 answers

How to group 24-hour data in 30 minutes interval to get the count?

I have a field name timestamp in the sales table in which the data format is: 20210725.1800 which means 2021-year 07-month 25th-date 00:30:00 AM. Now, if I want to count the sales on between 30 minutes intervals from 20210725.0000 to 20210725.1800,…
Rafailo
  • 29
  • 4
1
vote
1 answer

Add leading zeros to a character variable in progress 4gl

I am trying to import a .csv file to match the records in the database. However, the database records has leading zeros. This is a character field The amount of data is a bit higher side. Here the length of the field in database is x(15). The…
1
vote
1 answer

Why does the Informix 4GL compiler complain about unknown option -fwritable-strings?

I am beginner at Informix and when I want to compile and debug a program in Informix 4GL, but I can't. This the code: MAIN DISPLAY "HELLO" END MAIN And this the problem: cc:errors: option "-fwritable-strings" non reconnue sur la ligne de…
1
vote
1 answer

Convert Informix 4gl to Genero to create and write to .4gl - error of Permission denied to write to .4gl

I have a code in Informix 4gl that creates and writes to .4gl file. In short, it's code that generates a new program. It works perfectly in Informix:** let p_output = p_prog clipped,".4gl" start report rpt1 to p_output output to report…
1
vote
1 answer

Can't debug using Informix 4GL Interactive Debugger

I am pretty new to Informix and I have a program that I am adding some functionality to. It seems that the program has some existing issues with it though. When I run make -f makefile.mk I get success and the .4ge gets generated and I am able to run…
1
vote
2 answers

What does String formatter "<<<&" in Informix 4GL code mean?

I am reading through a legacy 4GL script. In the report section I came across the following: int_type_variable USING “<<<&” I understand this is supposed to convert the integer into a String using the String formatter. According to IBM Informix…
Ron
  • 149
  • 2
  • 16
1
vote
1 answer

Can Python talk to Informix 4GL Forms?

I am an Informix 4GL developer. Due to maintainability I was tasked to write a wrapper to automate some tasks on a 4GL forms based command line application. Does anyone have any idea how this can be done on python ? (I‘ll take other languages too…
Karl
  • 146
  • 1
  • 1
  • 12
1
vote
2 answers

Command (.4gl) executed with SSH.NET SshClient.RunCommand fails with "No such file or directory"

I have a web service that uses SSH.NET to call a shell script on a Unix box. If I run the script normally, it works fine, does its work correctly on the Informix DB. Just some background: I call a script that executes a .4gl (cant show this as its…
JvD
  • 473
  • 3
  • 18
1
vote
1 answer

How to tell if a row is locked?

When doing select on a table row in INFORMIX, how do you know if it is currently being locked by another user without using "for update" construct?
mihirp724
  • 129
  • 5
1
vote
2 answers

Informix 4GL report to screen - Reverse

I have a generated report in Informix 4GL that prints to the screen. I need to have one column displayed in reverse format. I tried the following: print line_image attribute(reverse) But that doesn't work. Is this possible at all?
Moses Davidowitz
  • 982
  • 11
  • 28
1
vote
1 answer

Progress 4GL - get today + 1 day

Today keyword gives me today's date, but how can add one (or more) days so I can compare it? I've tried the following code. FOR EACH foo where date(today) +1 > end_date NO-LOCK The error I get is "PREPARE syntax is {FOR|PRESELECT} EACH..."
Baked Inhalf
  • 3,375
  • 1
  • 31
  • 45
1
vote
1 answer

OpenEdge - Progress ABL: How to open a web browser inside a dialog window

For the moment i have a code that allow me to open a web browser directly from my Progress application. DEFINE VARIABLE cProgramName AS CHARACTER NO-UNDO. DEFINE VARIABLE cPageAddress AS CHARACTER NO-UNDO. DEFINE VARIABLE iReturnResult AS…
hamzarh
  • 330
  • 2
  • 6
  • 20
1
vote
2 answers

Progress 4GL nesting blocks to display related data

First all I'm very new to Progress 4GL and still trying to get my head around how nesting FOR EACH blocks works. I have the following two tables that I'm getting information out of, ivc_header and ivc_mchgs: ivc_header invoice_nbr |…
CuriousOne
  • 51
  • 10
1 2
3
11 12