In the Spring and Fall IBM updates the IBM i Performance FAQ. The latest one was released on Friday.
It covers all aspects of the IBM i from hardware to software and programming. If you have not perused it I think you will find the parts that are relevant to your career interesting.
You can find it here.
For over a year we have had a SQL table function to be able to retrieve information about the SQL codes. Now we can do the same kind of thing for SQL states. The major difference is that we retrieve the information for the SQL statuses from a SQL View: SQLSTATE_INFO in the library QSYS2.
When working with SQL codes and statuses it is important to remember that they are not all a one-to-one relationship. There are some SQL states that are associated with more than one SQL code, and there are some SQL codes that are associated with more than one SQL state.
The SQLSTATE_INFO view returns three columns:
If SQL state is associated with more than one SQL code each combination will have its own row.
I will be involved with three events this month:
Wednesday November 5, starting at 6:30 PM (CT), is the next meeting of the Central Texas IBM i User Group, CTXiUG. IBM champion Gregory Simmons is the guest speaker, and he will be talking about becoming an ACS power user.
It is online only. You can learn more about it and register here.
The following day, Thursday November 6 starting at :100 PM (ET), is the final installment of System i Developer's Lunch and Learn series. I will be presenting my top five favorite SQL.
If you have not already registered for the Lunch and Learn series you can do so here.
Updated:
Finally, on Tuesday November 18, starting at 2:00 PM (CT), I will making two back-to-back presentations to QUSER.
This is online. You can learn more and register here.
I hope to see you, virtually, at all of these presentations.