(Bernhard Pichler) For each insert or update statement a trigger fires that marks the record as updated or inserted. To allow for this two new columns are to be added to our sourcetable.
Other News
Creating Nested Relationships in XML Schemas
To construct a schema to validate nested data: –Create the individual tables to represent the different hierarchies of data that your XML represents. For more information, see Creating Tables in XML Schemas. –Select the table that represents the nested child element and drag and drop it ont
Collections, Cursors, Bulk Binds and FORALL
(Mark Rittman) Once in a while, I read something about Oracle that stops me in my tracks and makes me really think about how I approach my job. Recent examples include starting to work with 9iAS, and slowly becoming aware of how much I’m going to have to get my head around the role Java and middlewa
HTML DB: A New Kind of Web Application Development
(Scott Spendolini) Product manager Scott Spendolini explains why HTML DB is one of Oracle Database 10g’s hidden gems—and how it can save you substantial development time.
Tie in data with Web services and XSL Transformations
(Nicholas Chase) In Part 5 of this tutorial series on analyzing data with XSLT, the MindMap Research Team decides to tie their data in with other services, pulling information from Amazon Web Services in response to information unearthed in the analysis. Web services provide information in XML, but
DB2 for z/OS: DB2 database design
(Fred Whitlark) Many design decisions made early during the development process can have a significant influence on the performance of your DB2 applications and databases. This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments.
sp_who_3 : An Enhanced and Efficient Version of sp_who
(Narayana Vyas Kondreddi) As you probably know, there’s a system stored procedure called sp_who, that provides information about current Microsoft SQL Server processes and users. Output of this stored procedure can be used for troubleshooting performance problems and blocking issues. Microsoft a
What is Large? What is High Volume?
(Craig S. Mullins) Every now and then some sage consultant will offer advice like “Large DB2 table spaces should be partitioned” or “Bind your DB2 applications using ACQUIRE(ALLOCATE) and RELEASE(DEALLOCATE) for high volume transaction workloads.” But how useful is this advice? What do they mean by
SQL Server Health and History Tool (SQLH2)
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used.
Address for Success
(Bernard Chester) In 15 years of content management consulting (of course when I started it wasn’t called that), I’ve observed that enterprise content management (ECM) projects fall prey to a number of problems that jeopardize their success. I hope to ensure that no one who reads this column encount