Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 AS400 Questions What is the Configuration of the …
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 CONTROL LANGUAGE (CL/400) How to start a CL …
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 …
IBM i, AS400, iSeries, Programming, RPG
Find the IBM i System Name Three Ways Let’s look at three techniques to find the IBM i System Name Let’s dive straight in: (1) Get Sysname using SQL The IBM i System Name is not the same thing as the SQL Local DB Server name, although it may be the same by default. You …
Control Language (CL or CLP) has a neat and little used header specification command called ‘COPYRIGHT’ Just like the RPG header level COPYRIGHT parameter we can also do the same thing in CL programs. By using the COPYRIGHT command in CL we can embed our companies copyright statement into the code for the program. What …
IBM i, AS400, iSeries, Programming, RPG
I have a NUMERIC in an RPG program that I want to move RIGHT into an Alpha field. In the old days of RPG3 I would use MOVE but in the new days of RPG4 I have a couple of more flexible solutions. So, lets say we have a numeric field containing the number 1234, …
IBM i, AS400, iSeries, Programming, RPG
Pointing at Pointers and laughing aka “How to Display Pointer Data” RPG has all kinds of different data types. In the olden days of RPG, we only really thought in terms of character variables and numeric variables (signed numeric and packed numeric). But as the language has advanced and adopted new technologies, methods of talking …
System Request 3 Here’s a blast from the past: I was just testing an IBM i program that is importing data from a Windows Server, converting the data, juggling it, tweaking it and when its finished playing it finally shoves it into an IBM i Database. Fun Fun FUN! But if its running interactive and …
Modernizing RPG Programs – Learn the RPG History first I had email email from an old work colleague this morning. He was a windows programmer, with limited exposure to RPG, but works in a company that is driven by a huge, old, complex RPG3 application that has changed little over the last decade. He is …
IBM i, AS400, iSeries, Programming, RPG
RPG CODE EXAMPLE – “Write to joblog” in Free Format RPGLE Write to the IBM i joblog is a neat way of recording details of any running jobs information. This example lets us send messages from inside a running RPG program. It’s simple using one of IBM’s API’s – QMHSNDPM – and this source code …
another snippet from an old document I found in a dim dark and hazy corner of an even older HDD… rather than let it disintegrate, here it is migrating to the web just in the (extreme) off chance that it may be useful to someone out there. Hey.. if YOU are reading this then its dont its job 😉
RLU is used to design a report image, print prototype reports, create printer files, and generate DDS from which the report will be created. A prototype report is a printed copy of the report image that looks like the report that an application program will generate.
The Design Report display is the main screen from which you edit the report. From this display you can use function keys to go to other displays where you can add information at the file, record and field levels. You can also go to the Change Session Defaults display where you can control the characteristics of your edit session.
...I found this excellent article by Birgitta Hauser, Software and Database Engineer, Toolmaker Advanced Efficiency GmbH. It covers the basic concepts you will need to consider if you want to “Replace IBM i Native File Access with SQL” Just in case it vanishes I’m going to reproduce it here: If you are considering SQL and …
