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

SAS proc sql concatenation and join like

I'm trying to build a data model in SAS structures for Financial System Data. The idea is to keep IDs in a table as character expression and then build a proc sql with INNER JOIN to them from another table - the LIKE should get IDs which start with…
rkubic
  • 51
  • 1
  • 7
4
votes
1 answer

4GL ABL Openedge loop through handle?

here is my current code def var hbTT as handle. for each Cust: hbTT:buffer-create(). assign hbTT::Name = Cust.Name hbTT::address = Cust.Address. end. now what I want to do is to loop through hbtt. How can I do that? I tried for…
BobNoobGuy
  • 1,551
  • 2
  • 30
  • 62
4
votes
3 answers

Proc SQL with space in the column name

How I can use column with space in the name ('library name') in PROC SQL in SAS? proc sql outobs=10; select * from sashelp.vtable where library name = xxx ; run; I tried: proc sql outobs=10; select * from sashelp.vtable …
PNPTestovir
  • 287
  • 3
  • 5
  • 12
4
votes
2 answers

Add a new language to Visual Studio 2010 with syntax highlighting and intellisense

I am trying to add support for a different language in Visual Studio 2010. I was hoping to add custom syntax highlighting, and have some sort of basic intellisense work with it. The language I am trying to add is 4Js Genero (a newer version of…
DRiFTy
  • 11,269
  • 11
  • 61
  • 77
4
votes
2 answers

Convert SQL query "SELECT UNIQUE 1..." in Informix-4GL program to Java code

I want to convert Informix-4GL program to Java, and I have some problems. I have a Java code and connect to Informix with success, but I'm having some problems. How can I use "SELECT UNIQUE 1..." in method executeQuery() because UNIQUE 1 not…
user1774492
  • 71
  • 2
  • 3
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
1 answer

How to ignore or replace "carriage return" in informix 4GL

Say I have the following query: insert into myTable values ("TEST 1 TEST 2") Then I'm selecting the description to output to an excel sheet: select description from myTable Result: description TEST 1TEST 2 This will result the output for the…
Moses Davidowitz
  • 982
  • 11
  • 28
3
votes
2 answers

Select 2 distinct columns in 4GL

Needed for my 4gl program: Let's say I have a table that holds a phone number and a name. There can be 2 people with the same phone number, or 2 names with 1 phone number. I need to select just 1 of each phone number in the table. I did: SELECT…
Moses Davidowitz
  • 982
  • 11
  • 28
3
votes
2 answers

Where to go after Informix 4GL?

We have a large homegrown ERP system written in Informix 4GL. Currently we are running on old Sun hardware, Solaris 8, and a ten year old version of 4GL and Informix. We need to move on, and one option obviously is to get the latest versions of 4GL…
Chris Harris
  • 41
  • 1
  • 3
3
votes
2 answers

PROGRESS - Validating a user-input file output path

I've written some PROGRESS code that outputs some data to a user defined file. The data itself isn't important, the output process works fine. It's basically DEFINE VARIABLE filePath. UPDATE filePath /*User types in something like…
user2961924
  • 31
  • 1
  • 2
3
votes
4 answers

What is 12345 >> 2 Really Doing arithmetically?

My question is in the following example what does val = val >> 2; do? That is I believe it is division by 4. int val = 12345678; val = val >> 2; Here is the background to this question. I have a read from a water meter, say 12345678. The way our…
octopusgrabbus
  • 10,555
  • 15
  • 68
  • 131
3
votes
1 answer

list of capability codes for Informix 4GL termcap

Is there a reference document that lists all the capability codes actually used by 4GL (and, ideally, all those appearing in the termcap supplied with 4GL RDS)? for example: gs - start graphics mode (box-drawing characters) GS - start graphics…
RedGrittyBrick
  • 3,827
  • 1
  • 30
  • 51
2
votes
1 answer

How to list all lines in a field with Progress 4GL

An address field in a Progress database evidently is multiple lines. So if I do something simple like: for each customer where customer-number = "123" no-lock. display customer-number customer-name customer-address. I get results…
Trey
  • 23
  • 2
2
votes
1 answer

Formatting not working in 4gl [ USING clause ]

I was trying to format the output variable as follows: Scenario 1: LET msg = "Roopesh Majeti here " Empno Using "&&&&&" Call Logmsg(msg) In this scenario, the empno get formatted to 5 digits [ I should say spaces ] and gets…
Roopesh Majeti
  • 556
  • 1
  • 11
  • 23
2
votes
3 answers

SAS Array to jump by 10

I want to achieve the same output but instead of harcoding each of the array-element use something like var1 - var10 but that would jump by 10 like decades. data work.test(keep= statename pop_diff:); set sashelp.us_data(keep=STATENAME…
Mateusz Konopelski
  • 1,000
  • 4
  • 20
  • 37
1
2 3
11 12