Character Classes or Character Sets are used to define a list of characters to be used inside a RegEx. Represented using square brackets […] Characters inside the…
RegEx Meta characters are similar to Keywords in programming languages. They have special meaning in RegEx. Here is a list of meta characters- 210-060 questions…
Regular expression (aka RegEx) is a way to define the pattern of any text. This pattern can represent the complete text or a part of…
[Q]SQL : Browser based SQL client for IBM I. GitHub REPO
FLOAT is also a type of binary data type. Due to IEEE standards, most of the programming languages handle FLOAT in the same way. INTEGER…
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…