I’m sometimes bemused by gaping holes in the IBMi operating arena. What do I mean by this? The IBM i Operating System is fantastically robust, powerful yet simple to use. It’s evolved from the early days of CPF on the System/3x machines, up through the OS400 years and now in its latest and greatest iteration …

Read More

Turnover and External Procedures I’ve been having a problem promoting Stored Procedures today. After an hour of looking at two different Applications defined in Turnover – where one works fine and the other… *cough…. doesn’t. I’m still none the wiser. Grrrrr So this little cheat sheet may come in handy for me (and for you!) …

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

You DO NOT have an AS400 or an iSERIES! This has been an ongoing argument disagreement in our IBM i and RPG programmer communities for well over a decade: Should IBM have changed the name when the launched the replacement for the old AS/400 computer? Many people using the latest IBM i servers still enjoy …

Read More

Dear IBM i Nerd, I am a System i programmer with 1 year experience and I work for a large company with over 30 programmers. I don’t seem to be taken seriously by my peers or my boss. What can I do to enhance my career advancement opportunities within my company and to achieve credibility …

Read More

Dear Uncle AS400, my disk space keeps creeping higher and higher, and I don’t mean up the stairs!  Is there a simple way I can clean up my disk drives to reduce this amount of disk space being wasted by unnecessary ones and zeros? A: Yes, the system has a very simple command that will …

Read More

IBM i Defaults are just defaults – not the optimal settings This weekend I upgraded an old Turnover 5.4 Change Management installation to the newer V100 version across several LPAR’s of a customer’s IBMi installation. As part of the mission to tidy up the Software Change process – I see a lot of objects that …

Read More

Promoting Files using TURNOVER Using a Change Management tool to promote files makes the creation and replacement of target files so much easier. #INTERNET-FACT: Turnover for iSeries, is a change management tool that really eases this process for us developers. Consider this scenario – we want to make a change to an IBM i *PF …

Read More

Declare the default value for IBM-i Table Data The DFT Keyword is used to specify the default value of a field in the Physical File. The format of the keyword is: DFT(‘value’ | numeric-value | X’hexadecimal-value’ | *NULL) Without this keyword, character and hexadecimal fields are set to blanks as default and numeric fields are …

Read More

This morning I got question from an old RPG3 chum of mine: I know a couple of questions they will ask me, what are the different parms used on sub-procedures like *OMIT/*Nopass. Didn’t we use those any way? I thought we were writing programs that did or did not necessarily get parms depending what called …

Read More

Yes thats right. *SPLFS. IBM Spool Files. I sample several spliffs every day, so I want to keep them secure: Spool files and Printer security Question: I want to set up user profile who just can display spool file but who can not delete it. Answer 1. Spool file security is quite a bit different …

Read More

Talking about an OBJECT in the IBMi world conjures up images of all kinds of wonderful screens defining object parameters: AS400 iSERIES and IBM i Object Authority Question: If a library has security for a user of *USE will this user be able to update files in the library and If files were created with …

Read More