An old AS400 Quiz So, last night I was nosing around in the dim dark corners of an old network share on my homeserver. I stumbled across an old TXT document from the late 90’s, I think. It was sitting in a text file called “AS400 Quiz Brainteasers” -it’s obviously old (look at the as400

Read More

By using MSGCON (message constant) keyword. You use MSGCON, a field-level keyword to declare the text for constant fields is contained in a message description. Years ago, this was used by a lot of companies to create multilingual display files. The idea was that you could remove the ENGLISH language fields from every *DSPF and

Read More

RUNSQLSTM – Run SQL Statement When you do the RUNSQLSTM to create your SQL Objects – Do not qualify library names but use the Turnover variables just like you would define PDM variables: Turnover uses the DFTRDBCOL column “&LI” to populate the other *library* variables. Most shops I’ve been to use QSQLSRC to store the

Read More

Have you been asked to add a part number as a barcode to an existing warehouse report? Does the report currently print as an old fashioned text based spool that looks like it came from the 1980’s? Is this program written in RPG? Is the Printer file defined in DDS? If the answer to these

Read More

Modernizing AS400 aka WEB-ENABLING AS400 and iSeries Converting an old green screen application to run in a website is as easy as typing an email or uploading a photo to facebook. If you are a modern IBM i Software developer the chances are, your system has lots of old AS400 and iSeries that code that

Read More

Twenty years ago these are the kind of things you had to know to work on the old AS400 systems. I found these on an old dusty corner of my homeserver. Enjoy the trip down memory lane or to use old RPG lingo AS400NERD CABEQ ‘1’  START MISCELLANEOUS How do you combine two record formats

Read More

Is SQL faster than CPYF Native IO? For the longest time I’ve heard about the performance difference between a true SQL INDEX and a DDS ACCESS PATH generated index on the IBM i operating system (or ‘OS400’ which was a ten year old, but very commonly used version of the the same OS). But is

Read More

Glendale, CA – Cocoa is a hot new programming language developed by Nestle Microsystems. The language was originally designed for programming hot chocolate machines but Nestle soon realized that the language had the potential to do much more. Because it is “architecture neutral” it can run on any device with a microchip including PCs, the

Read More

Code400.com is probably the best RPG programming related forum around (Bob Cozzi’s comes in a close second but the UI is just awful and I really cant spend to long trying to navigate around without getting annoyed… but I digress…). I frequently read neat little tricks and this is a smart one I saw a

Read More

What is a load all subfile? A load all subfile is one in which we generally specify the subfile size as 9999 in the record format itself. However, you may define the subfile size to be less than 9999 in the record format and still load all your subfile at a time. In that situation

Read More