Tag: mainframe

SELECT COUNT(*) FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT() FROM Persons

SELECT

OPEN

GET

EXTRACT

SELECT FirstName FROM Persons

SELECT Persons.FirstName

EXTRACT FirstName FROM Persons

EXTRACT Persons.FirstName

SELECT DISTINCT

SELECT DIFFERENT

SELECT UNIQUE

SELECT SAME

LEFT JOIN

RIGHT JOIN

FULL JOIN

SELF JOIN

True

False

True

False

Alternate Key

Foreign Key

Unique Key

Alias Key

COUNT()

GROUP BY()

SUM()

MAX()

A REXX clause can be coded in uppercase, lowercase or mixed case.

Multiple instructions can be coded on 1 line, as long as they are separated by a ','

A REXX program should start with a comment clause /* REXX */

Continuation of REXX instructions is achieved by using a ',' as a continuation indicator