Tag Archives for " #ibmi "

Mar 04

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

More Waffle
Jan 08

How to update RDi – Rational Developer for IBM ‘i’ Programmers

Last night was I was chatting to an old programming chum in Chicago. As you may be aware, for most people in the AS400/iSeries/IBM-i arena the term “old programming chum” automatically implies a gray haired old fart wearing frayed cords, cheap (but comfortable!) shoes and excessively dour facial features with a slightly “smarter than thou” […]

More Waffle
Aug 09

‘device file does not contain an entry for screen size’

Upgraded our IBM i systems to IBM i V7.3 yesterday and so far everything is running nicely except for this one weird little glitch: some of the existing DDS WINDOW SCREENS are bombing with CPF4169 The device file does not contain an entry for screen size when they seem to have been quietly working for years, […]

More Waffle
Jun 13

Funky IBM i Email Validation Program using SQL Regex

Following on from my previous blog (basic email validation) I decided that it would much nicer to (a) have the regex stored in a data area so that we can easily play with it to try different validation scenarios and (b) lets have a shot at a much stricter validation because there is an official […]

More Waffle
Jan 02

+Happy New Year 2018

+Happy New Year 2018. One of my new years resolutions was to write cleaner code, and in the spirit of out with the old and in with the new… I already use the RPG COPYRIGHT statement and the CL COPYRIGHT STATEMENT to store the copyright message and (more importantly to me) the Version or Release number […]

More Waffle
Oct 30

IBM i 5250 Screen Sizes – Widescreen for the Win!

Back in the good old days (thats programmer-speak for decades ago, when doing anything on a computer was a lot more complicated than it is today)  5250 screen sizes of 24 rows and 80 characters wide seemed like plenty of room. Monitors were green text, on black background, with none of those fancy annoying graphics […]

More Waffle
Aug 16

IBM i gets a medieval System Reset Button

Breaking news from a medieval insider at the IBM laboratory rochest’r, mn – in ‘rd’r to bett’r competeth with the growing competition from microsoft s’rv’rs, ibm plans to installeth a big r’d did reset button on the newly did announce pow’r systems and changeth all ibm i op’rating system ‘rr’r message text to readeth “gen’ral […]

More Waffle
Apr 21

IBM i v7.3 is here and its pretty cool

You think you know IBM i? You havent met 7.3 IBM i 7.3 Announcement & Material IBM® DB2™ for i Temporal Support, enabling clients to conduct accurate analysis of data within a specific historical time period More advanced analytics capability driven by enhanced OLAP functionality, allowing clients to better forecast, define gaps and build new […]

More Waffle