Date Range
Date Range
Date Range
Mainframestechhelp started with the concept of online learning and to deliver online content for readers to have the flexibility of learning from anytime and anywhere. Our journey was started with Mainframestechhelp in 2012, which contains all mainframe related tutorials.
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.