(Marina Greenstein) If you’re migrating to IBM DB2 Universal Database (UDB) from a database that supports bit and Boolean operations and functions, you may be wondering how to handle these types and functions in DB2. The author offers a method that includes table creation with columns of the bit-lik
Other News
Forming Opinions, Part Two
(Micah Dubinko) Previously, this column examined Web Forms 2.0, or WF2, a technical report recently presented to the W3C by Opera and the Mozilla Foundation. WF2 seeks to extend forms-related aspects of SGML-based HTML 4.01 and XHTML 1.x.
Oracle, Siebel held acquisition talks, reports say
(James Niccolai) Fresh from its takeover of PeopleSoft Inc., Oracle Corp. was recently in discussions about the possibility of buying out another applications rival, Siebel Systems Inc., although the talks are no longer active, according to published reports.
Moving your schema objects to production
(Kent Milligan) We have some tables created by SQL in a development box. How can we move these tables with data into another box (Production)? (R)
IDUG 2005 – Technical Symposium
Participating in IDUG 2005 – Technical Symposium not only provides you with essential information needed for success as a DB2 professional, but addresses critical, timely topics of interest as determined by your peers – DB2 users who share many of the same challenges as you. Make plans today to atte
Search Using Dynamic PL/SQL
(Bhagwan Singh) This script returns the column and table names for a value input by a user. For example, if we know that there is a character value of ‘US-15017094’ with no other details available, this routine will search the user schema and list both table and column name for that value.
Generate execution plans direct from the library cache
(Garry Robinson) The introduction of Oracle9i brought with it the capability to view execution plan information for all parsed cursors stored in the library cache. This information is exposed through the view V$SQL_PLAN and is fairly similar in format to the well known PLAN_TABLE, which is used by d
Separator First Formatting
(Andrew Novick) The second theme of 2005 for the Coding-in-SQL newsletter is T-SQL Coding Style. That is, how T-SQL statements and comments are presented.
Transact SQL Enhancements in SQL Server 2005 – Common Table Expressions
(Mahesh) A new feature in SQL Server 2005 is the introduction of a new virtual table (rather a ResultSet) called Common Table Expressions (CTE). CTE stores temporarily the results set during the execution of a SELECT, INSERT, UPDATE or DELETE statement. The advantage of using CTE is the ability to w
Using OpenXML
(Vasant Raj) OPENXML provides an easy way to use an XML document as data-source to your procedures. OPENXML allows the data in XML document to be treated as columns and rows of your database table i.e., xml tags as columns and the value as rows. Data can be inserted / updated very quickly and effici