Sunday, October 23, 2005. DB2 - DataBase Abend SQL -811. THE RESULT OF AN EMBEDDED SELECT STATEMENT IS A TABLE OF MORE THAN ONE ROW, OR THE RESULT OF THE SUBQUERY OF A BASIC PREDICATE IS MORE THAN ONE VALUE. Alternatively, a subquery contained in a basic predicate has produced more than one value. DB2 - DataBase Abend SQL 100.

Thursday, December 13, 2007. In this guide I assume that you have some mainframe experience and you can understand the terms like PARMLIB, PROCLIB, IEASYSxx, IPL, and POR etc. There are three different types of consoles. This section describes the PARMLIB members that affect the console definition.

Sunday, June 10, 2007. Avoid joins that involve more than two TABLES. Break it up into multiple SQL statements. In a case study, a 5-table join used 4190 CPU hours in a month for a weekly process. Breaking it up dropped the usage to 9 CPU hours per month! If using CURSOR SQL for read only, use FOR FETCH ONLY in the SQL. COLLID NAME CONTOKEN OWNER CREATOR TIMESTAMP.

I can also make people happy by explaining little known tips and tricks from the realm of mainframe systems! When the first computers were developed, I was there. I designed and worked on some of the first computers which hardly could fit in a room. It was back in the early 80s.