http://www.dbatodba.com These are the search results for the query, showing results 1 to 7. http://www.dbatodba.com/Forums/db2/307841733/157131859 The above query returns SQLCODE = -206, saying NULL IS NOT VALID IN THE CONTEXT WHERE IT IS USED. Could you please let us know your exact requirement? No publisher gnanas 2008-06-06T12:30:31Z Comment http://www.dbatodba.com/Forums/db2/547732215/737347565 Thanks, Perallis. Your efforts of staying on task and dedication for this site is unmatchable !!! No publisher gnanas 2008-04-23T10:34:12Z Comment http://www.dbatodba.com/Forums/db2/547732215/187632466 Hi, I thank all of you who are making this site great. I have few suggestions about our site. I have posted Mainframe - Crossword on DB2 Mainframe forum. But it's not displayed properly. That post contains a table and text. Is it possible to post a image or table? I would find CODE tag can be added for our post. Please let me know if any concerns. Thanks! Gnana Sekaran Nallathambi. No publisher gnanas 2008-04-22T09:24:46Z Comment http://www.dbatodba.com/db2-mainframe/mainframes-crossword This is the mainframe crossword. Please try to solve it. Thanks! No publisher gnanas 2011-10-13T09:39:13Z Page http://www.dbatodba.com/db2-mainframe/should-i-use-packages-or-bind-directly-to-the-plan No publisher gnanas 2008-03-26T04:59:37Z Page http://www.dbatodba.com/Forums/db2-mainframe/368779694/249528412 Question Should I use packages or bind directly to the plan?     Answer Use packages. Plans containing a DBRM are currently deprecated. Using packages has the following advantages: When you change one SQL statement, you do not need to bind the entire plan again. You need to bind only the package that is associated with the changed SQL statement. Binding packages into package collections enables you to add packages to an existing application plan without having to bind the entire plan again. Maintaining several versions of a plan without using packages requires a separate plan for each version, and therefore separate plan names and run commands. Isolating separate versions of a program into packages requires only one plan and simplifies program migration and fallback for separate development, test, and production levels of a program. For plans that are bound with only one DBRM, packages still offer the advantage of versioning. However, for plans that use multiple DBRMs, you should probably bind each DBRM into a package, and then bind the packages into the plan. Plans containing DBRMs and the BIND ACQUIRE(ALLOCATE) option are still included in DB2 9, but may be removed from future versions. Use packages and ACQUIRE(USE) to replace the existing function. We expect to deliver some help in migration, but packages are the strong recommendation.   No publisher gnanas 2008-03-24T14:41:35Z Comment http://www.dbatodba.com/Forums/db2/643352398/739194761 Welcome to DB2 forum.  No publisher gnanas 2008-03-23T08:19:57Z Comment