There are many challenges in responding to the needs of improving Global Software Delivery. IBM supports and enables these requirements by: Closed Loop Software Delivery Management: Faster, higher quality build and production cycle time Developing Flexibility: that incorporates proven best practices
Author: SSWUG Research
Kewl DB2 for z/OS Version 8 Feature Part 5: INSERT within SELECT
(Willie Favero) This is one of those features added in Version 8 that is just plain cool and could give you a bit of a performance boost. It lets you SELECT what has just been INSERTed in the same SQL statement. Think about all the neat places you could use something like this. For example, say you
Calculating financial values in SQL Server
(Arthur Fuller) SQL Server 2000 and 2005 do not include much in the way of financial functions, but there are many sources for the formulas for financial calculations. In this tip, I present the present value (PV) and future value (FV) functions, both of which are scalar UDFs.
Full-Text indexing files with Microsoft SQL Server
(boci) This article is about the full-text search capability of SQL Server 2000 (2005). It is an easy to use, very fast and extensible solution to index and search in various types of document’s content. For example in word, excel, adobe portable document format (pdf) and html files.
Restoring an existing database on the same server
(Greg Robidoux) One task sometimes needing to be accomplished is that of restoring an older version of an existing database to the same server. It may be necessary for auditing purposes, restoring or recovering older data or even for reporting. In most cases you wouldn’t use your production server,
ASP.NET Tip: Control Access to a File Download
(Eric Smith) A developer, working on a Web application that allowed only registered members to access a file, recently asked me if there was any way to control how the file could be downloaded. He had to avoid using the “gray box” popup dialogs because the access was controlled via the application.
Uploading Files and Navigating Directories in PHP
(Jacques Noah) In this article we are going to look at how to upload files and also how to navigate through directories. It is the second part of a tutorial that began last week with “Reading, Writing, and Creating Files in PHP.”
Mini-tip #6 – Private Variables
(Lewis R Cunningham) A member of the oracle-sql-l mail group asked about private variables in procedures and packages and how to go about doing that. I am going to go into this in a lot more detail when I get back to my Learn PL/SQL tutorial.
Ajax3D: The Open Platform for Rich 3D Web Applications
(Tony Parisi) Real-time 3D is emerging as a first-class media type for the web. Network bandwidth and graphics hardware processing power are now sufficiently advanced to enable compelling web-based 3D experiences, including games, online virtual worlds, simulations, education and training. Commerci
Create XML-based stored procedures using the DB2 Developer Workbench
(Naveen Balani and Rajeev Hathi) Create a stored procedure that retrieves XML data using IBM DB2 9 Developer Workbench. Take a look at how DB2 Developer Workbench provides a comprehensive development environment for creating, editing, debugging, deploying, and testing DB2 stored procedures. (R)