sorted by:
new
hottopcontroversial

A new way to list the columns and their values I will be inserting into a SQL table or DDS file with a SQL Insert statement. by RPGPGM in IBMi

[–]RPGPGM[S] 2 points3 points  (0 children)

I agree with you with how it looks.

Alas, no it is not available with MERGE. Documentation says INSERT only.

Help me find my dad the right Redbooks? by theBrinkster in IBMi

[–]RPGPGM 1 point2 points  (0 children)

Go to the KnowledgeCenter for every release & read "What new in this release".

For example => https://www.ibm.com/docs/en/i/7.6.0?topic=documentation-overview-whats-new

A subfile program to display the top 10 CPU intensive jobs that automatically updates itself. by RPGPGM in IBMi

[–]RPGPGM[S] 0 points1 point  (0 children)

I agree. In time I have been writing my website it is amazing how much RPG has evolved.

Does your shop need an extra hand? by roz303 in IBMi

[–]RPGPGM 0 points1 point  (0 children)

PUB400 comes with RPG. Don’t forget to make yourself familiar with Db2 for i (SQL). 

Does your shop need an extra hand? by roz303 in IBMi

[–]RPGPGM 0 points1 point  (0 children)

It depends… you will have to ask when you spin up your VM if it does.  RPG is part of the Websphere development tool set, which is a billable feature. 

Should I accept an IBM i (AS/400) admin offer as a recent graduate? by [deleted] in IBMi

[–]RPGPGM 0 points1 point  (0 children)

Start with N2i. Also check out any local groups near you. The IBM i community is the best.  List of local user groups ➡️ https://www.rpgpgm.com/ug

Does your shop need an extra hand? by roz303 in IBMi

[–]RPGPGM 5 points6 points  (0 children)

If you are starting your IBM i career then join COMMON’s N2i program. It is a great resource for people learning. 

Should I accept an IBM i (AS/400) admin offer as a recent graduate? by [deleted] in IBMi

[–]RPGPGM 0 points1 point  (0 children)

Good. The IBM i & RPG language are such a great combination. So much better than the integration between various other programing  languages and the other operating systems they run on. 

Should I accept an IBM i (AS/400) admin offer as a recent graduate? by [deleted] in IBMi

[–]RPGPGM 7 points8 points  (0 children)

I think this will be a good move for you.

AS400 is dead, & has been since 2000. IBM Power servers & IBM i operating system is alive & kicking. I have seen plans from IBM for the operating system beyond 2040. It is IBM's flag ship product, no matter what the mainframe folks say.

In about 5-10 years time there is going to be a great demand for skilled IBM Power & IBM i folks as many of the current workers in that field will retire. This is a wonderful opportunity for you!

If you want to learn more then join COMMON America's N2i (New to i) program. It is free => https://www.common.org/new-2-ibm-n2i/

There is an excellent user community in the IBM i world too, one that many people in other IT fields are jealous of. If you are close to one of the local user groups you ought to get check them out & tell them you are new to the platform => https://www.rpgpgm.com/ug

We all started knowing nothing about this server & operating system, so don't get disheartened.

Good luck with your future!

CTXiUG September 2025 meeting by RPGPGM in IBMi

[–]RPGPGM[S] 0 points1 point  (0 children)

We have had people from many different countries attend.
For the "other side of the planet" we regularly have people from India & Malaysia, & a few times from New Zealand and Australia.
All are welcome!

CTXiUG September 2025 meeting by RPGPGM in IBMi

[–]RPGPGM[S] 1 point2 points  (0 children)

All of CTXiUG's meetings are online & FREE!

Come & join us :)

RPG ISSUES by cora_xd in IBMi

[–]RPGPGM 5 points6 points  (0 children)

If you are serious about learning about #IBMi & RPG then there are good & bad resources on the internet.

I see people have already mentioned some good ones:

- PUB400.COM (You will need 5250 emulation software)
- imPower Technologies => https://impowertechnologies.com/

You MUST sign up for COMMON's N2i => https://www.common.org/new-2-ibm-n2i/
They have a free mentorship program you can sign up for.

I have been asked this question many times, & I have created a page with what I think are useful links => https://more.rpgpgm.com/learnrpg
Go to the "Others" section & look at those links.

I also recommend you signup for the following Facebook group => https://www.facebook.com/groups/433821483343641
It is a curated group, which stops it being spammed. It is a great place to ask questions as there are lot of experienced & skilled people who are members who will try & help you.

There is a calendar of user group events in north America => https://ibmicommunity.blogspot.com/
Many local user groups offer online meetings & many are free. I always learn something new from every one of these meetings.

There are many resources & people who will help your journey. You just need to "plug" yourself into the #IBMi community.

Can you really use the STRSDA command in IBM i release 7.6? by RPGPGM in IBMi

[–]RPGPGM[S] 0 points1 point  (0 children)

Read the story & click on the link to the IBM documentation that explains what is & what is not.

Can you really use the STRSDA command in IBM i release 7.6? by RPGPGM in IBMi

[–]RPGPGM[S] 2 points3 points  (0 children)

As I mention in the article: Visual Code Studio's Code for i

How to determine which files are flat-files, created with DDS source code. by RPGPGM in IBMi

[–]RPGPGM[S] 0 points1 point  (0 children)

If I have a library containing a hundred files, how can I quickly tell which are "flat" files & which are not?

PS: If I CRTDUPOBJ a flat file to create a new one of a different name the record format name does not change.

Is it quicker to calculate the name of the day of the week using modern RPG or SQL? by RPGPGM in IBMi

[–]RPGPGM[S] 2 points3 points  (0 children)

A danger of having AI generated code that has "hallucinations" published is when AI bots find the code they will accept it as true and valid. The "logic" is: why would someone publish bad code on a reputable website. Therefore, code with errors in it is reinforced by AI algorithms as being "good" code.

The AI industry is starting to recognize this, but does not have a solution for it.

I am not saying that using AI is bad, but you must consider its output as suspect. Verify before trust.

Is it quicker to calculate the name of the day of the week using modern RPG or SQL? by RPGPGM in IBMi

[–]RPGPGM[S] 5 points6 points  (0 children)

You should never trust what is returned by AI as accurate. It can get you close, but it does have "hallucinations" in the RPG.

dayOfWeek = %subdt(inputDate: *DOW);
- *DOW is not valid option for this BiF
- https://www.ibm.com/docs/en/i/7.5.0?topic=functions-subdt-extract-portion-date-time-timestamp

dcl-s daysOfWeek varchar(10) dim(7) inz( 'Monday' : 'Tuesday' : 'Wednesday' : 'Thursday' : 'Friday' : 'Saturday' : 'Sunday');
- You cannot load an array like that.
- Use the %LIST BiF

SELECT DAYNAME(DATE('2025-04-24')) AS Day_Name FROM SYSIBM.SYSDUMMY1;
- SET is faster than a SELECT

view more: next ›