SQL JOINS allows you to combine records for multiple tables based on some condition. This condition, in most cases, is “common…
SQL TABLE EXPRESSION gives you the power to create a temporary table inside a query. The life of this temporary table is only inside that query. As soon as the query is completed temporary table will vanish.
With the “GROUP BY” clause, SQL accepts a single set of columns, and based on that set final result…
ROLLUP and CUBE both are extensions for the “GROUP BY” clause.
To understand RANK and DENSE_RANK functions, let's examine how participants are ranked in…
From ancient times we RPG programmers have been using INDICATORS from handling display files to tracking errors. But maintaining source with indicators in INXX(XX= 01 to 99) form is always complex. So, the concept of “Named Indicators” gives programmers the power to provide long…
In RPG, how can we track if the user pressed any of the function keys (F01 to F24) on the screen? Of course, by using CA/CF indicators. But how can we check if the user pressed the enter key on the screen?