Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
If you have read my previous blogs, you probably know that I recommend we all stop guessing file sizes and switch to SIZE(*NOMAX) for all physical files! Now for something a little more radical, STOP USING DDS and start defining your database objects with SQL instead! Upgrading from legacy DDS to SQL for defining tables, …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
DDS, IBM i, Programming, RPG
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 …
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 …
