RPGPGM.COM - From AS400 to IBM i

Today IBM has announced the latest Technology Refreshes for the current IBM i releases, 7.3 TR 10 and 7.4 TR4. While the PTFs for some of...

I was asked: What about referenced tables when you specify a foreign key when creating a table? I can check this when I run DSPFD, it i...

In the western Christian calendar today is doubly special. It is Easter day, and it is Saint Isidore of Seville saint's day. St Isid...

Yesterday afternoon I found that IBM had replaced their documentation website, IBM KnowledgeCenter, with a new one, IBM Documentation. W...

The next meeting for the Central Texas IBM i User Group, CTXiUG , will be on Tuesday April 13 at 6:30 CT . CTXiUG is fortunate to have...

The question was simple:  Can you tell when a subsystem started? I am going to give two examples. The first will show what I would do if...

Many years ago, and yes it is so long ago I cannot remember exactly how long ago, when I was first embedding SQL into my RPG/400 programs ...

One of the problems of using the SQL Views to list the columns of SQL Tables, Views, etc. is that they do not include objects in the libra...

The question was: How can I check if job is still on the job queue and if it is held? Fortunately the solution is simple using SQL. I ca...

Someone created a SQL DDL Table with a long name and with long column names only, and did not give short or system names. I have discussed...