Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
SQL Tables with Indexes and Views are faster than DDS Phsyicals and Logicals. #HONEST SQL is a wonderful beast for quickly getting data from huge tables (aka Files). The trouble with SQL is that it’s so very simple to use; programmers get lazy and sometimes forget to do the analysis to make it as simple …
Data Area (*DTAARA) using IBM i SQL Our first problem is, SQL doesn’t know what a *DTAARA is. SQL reads data from Tables but our gloriously quirky IBM i Box has other places to secretly store data. Data Areas are just one of these tricky little blocks of data that other machines don’t know about …
Read lots of rows (records) into a data structure (array) Us IBM i blokes love reading things from files. Hashtag internet fact. But sometimes we just want to read a certain number of records, or rows in SQL speak. For example, when building a page by page subfile with say 15 lines per page, we …
SQLRPGLE and COMMIT(*NONE) Moving to SQL (from native file IO) has been a major game changer in the RPG programming world. SQLRPGLE can be confusing to learn, horrible to use if it needs lots of compile time parameters but using Exec SQL SET OPTION something answers my prayers. I first played with SQL back the golden …
