Tips

DB2
DB2 Programming Tips
How DB2 gets your data
DB2 Design Considerations
Disaster Recovery Options
DB2 SQL Code -805 or -818
DB2 Outer and Inner Joins
DB2 Date, Time, Timestamp Usage
Updating Views with Check Option
Column Check Constraints
Quick Fix for Datasets in 119 Extents
Using Concurrent Copy in DB2
Reorg Utility Changes for DB2 6.1
DSNTEP2 - Dynamic SQL
SQL Edit Macro
Procedure to copy production image copy to test DB2 tablespace


QMF
Canceling Interactive QMF Queries
Limiting Number of Rows Fetched

IMS
Using Image Copy 2


SQL Server
Setting Up a SQL Server Login
Procedure for Linking SQL Servers
Procedure to Copy SQL Server Database to Another SQL Server
Procedure to Relate Tables
Procedure to Register A Server
Hot Spots
Using Set ROWCOUNT, TOP, and PERCENT to limit a result set
Variable Declaration
Truncate VS Delete
Inserting Your Own Identities
Another Method to Count(*)
Store Procedure MSForEachTable
String Manipulation Functions
Procedure to Encrypt DTSRUN Parameters
Sending Email in SQL Server
Consistent Performance Statistics
Bulk Copy Program
Row Count For Each Table in a Database

SMP/E
Generating Reject Commands
How to Print Information in SMP/E
Adding DDDEFs
Changing SREL for a Zone
Receiving a Base Tape
Receiving a Cumulative Tape
Finding FMID
Creating the Accept/Check Job
Creating the Apply/Check Job
Listing Information in SMP/E
Loading RIMLIB to DASD
Receving a PDO tape
Removing a SMP/E Zone