News for hackers. Stuff that matters.
Re:IBM AS/400: Databases all the way down [video] by unixhero on Tuesday May 02, 2023 @05:00PM (#35794125)
A friend of mine got a job as a junior developer at an insurance company whom rely solely on IBMi and RPG programs running on it.

It is not dead.

Re:IBM AS/400: Databases all the way down [video] by shreddit on Tuesday May 02, 2023 @08:00PM (#35795949)
My company has one as their main database too, these things just run and run and run
Re:IBM AS/400: Databases all the way down [video] by unixhero on Tuesday May 02, 2023 @09:45PM (#35796702)
[He got the job in the year 2022. They were using RPG version 4 on IBM i and are not migrating anywhere. Rather they are hiring!]
Re:IBM AS/400: Databases all the way down [video] by artificialLimbs on Tuesday May 02, 2023 @10:35PM (#35797063)
Sadly. We're using an i currently. It has sort of locked us in because all of the programs that touch the money are written in ancient RPG. You can't just change a table (which IBM calls files...) when you want to add a field, oh no. You have to change the table AND update EVERY program in RPG that uses that table, because RPG has to know about every field in every file it touches. We are slowly working on migrating out to PHP.
Re:IBM AS/400: Databases all the way down [video] by lmz on Wednesday May 03, 2023 @08:08AM (#35801345)
Some would say that's great as you get instant database integrated type checking. Some people actively look for that.
Re:IBM AS/400: Databases all the way down [video] by artificialLimbs on Wednesday May 03, 2023 @02:34PM (#35805997)
I don't know, but suspect there are better ways than having to touch all our programs when a table changes.
Re:IBM AS/400: Databases all the way down [video] by crunchyX38921 on Friday May 05, 2023 @11:40AM (#35830692)
The sad part is that the only reason you have this constraint is because your team/company chose to have it. It has nothing to do with the language or system itself, it's 100% self-inflicted.

You can absolutely add new fields to database tables on the system without updating every program - if you architect the software properly. Use embedded sql, explicitly select field names (ie don't do "SELECT *"), and put default values on new fields. I haven't written a new RPG program using the old file-specs in years - all new code has been embedded sql.

Not willing to give up SELECT *? Fine - create views on top of the real database tables to do your SELECT * from. Then you can still add new fields to the database tables without changing everything else.

Re:IBM AS/400: Databases all the way down [video] by martin1b on Wednesday May 03, 2023 @04:23PM (#35807267)
The hardware is solid. The development community is aging out.

We have the same thing and are currently migrating off as there are no RPG developers available for hire. Most of them are retiring. There are very few schools teaching RPG 3, 4, and Free.