With “GROUP BY” clause SQL accept a single set of columns and based on that set final result is produced.
In any exam how are participants are ranked ? Participant(s) with highest marks got the 1st rank. Participant(s) with 2nd highest marks got the 2nd rank…
ROW_NUMBER is the most basic OLAP function. It is very easy, powerful, and very handy to use function. ROW_NUMBER assigns a temporary number to each row…
OLAP functions : OnLine Analytical Processing functions What is online here? An online algorithm is one that can process its input piece-by-piece in a serial fashion”.…
RPG has multiple numeric datatype support. Other then TWO most famous ZONED and PACKED numbers there are BINARY , INTEGER and FLOAT.
If you need to run the same dynamic SQL statement more than once per job use the PREPARE – EXECUTE statements using EXECUTE IMMEDIATE incurs…
Description This utility can write Subfile code for any given SQL select statement with little or no user interaction. It takes less than 20 seconds…
EXECUTE IMMEDIATE is simple option to execute a Dynamic SQL. Here is an example TableName = ‘CUSTOMER’; SQLString = ‘DELETE FROM ‘+ %TRIM(TableName) ; EXECUTE…
Here is a sample code to add 2 number in Free Format RPG 0001.00 D Total S 10 0 INZ 0002.00 C *ENTRY PLIST 0003.00…
Free Format RPG was a major step towards the modernization of RPG language. This change in RPG syntax gave RPG programmers flexibility to write code…
There are two ways to write SQL one is Static SQL which get job done in most case and second one is Dynamic SQL for…
SQL is always much better than RPG for handling string data. Embedding SQL in RPG gives RPG the great power not only to handle database…
We can use very simple correlated query to fine nth highest or lowest record in a table. Here is the query to find 2nd highest…
There are multiple ways to Delete duplicate data from A Table using SQL Query.Here we are going to talk about using Correlated subqueries to Delete…