Tag Archives for " #snippet "

Apr 22

Skeleton RPGLE Trigger Program

IBM i , Programming , RPG

Chum of mine was chatting to me about writing a trigger program. So I dug out this old trigger (that I copied from somewhere a couple of years back) and just ran through my RPGLE Modernizer routine: **FREE // // Skeleton trigger program using RPGLE V7.1+ //ctl-opt copyright(‘| @SKELTRIG V001 2019.04.19’) debug option(nodebugio:srcstmt) datfmt(iso-) timfmt(iso.) […]

More Waffle
Apr 04

How to get a list of all files in an IFS folder

IBM i

Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. “What’s the best way to read all the spreadsheets in an IFS folder so we can process them?” bald bloke in the office Well, we have a nice simple technique to […]

More Waffle
Mar 04

How to read a Data Area (*DTAARA) using IBM i SQL

IBM i

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 – think of them as a single […]

More Waffle
Feb 27

DSPLY Sucks. QUILNGTX Rocks.

IBM i , Programming , RPG

AKA – writing a new DSPLY opcode that shows more than 52 characters Using the DSPLY opcode to quickly debug a program has long been a staple of us RPG keyboard whackers. The DSPLY operation lets us “display the data in a variable” onto the screen. Everyone uses this quick and dirty technique and everyone […]

More Waffle
1 2 3 5