Articles Index

2007   2006   2005   2004   2003   2002   Other resources

2007

• January 2007 - Oracle: Sequence number in a table column
• February 2007 - Easytrieve: Redirecting report output
• March 2007 - File Manager Dumps for the COBOL Programmer
• April 2007 - SAS: Aggregating ODS Output from Multiple PROC FREQs
• May 2007 - Page Break Logic and PL/I
• June 2007 - Passing pointers to a function in PL/I
• July 2007 - A warning against omitting VAR from JavaScript variables
• August 2007 - TSO/ISPF: Using the START command for more than two screens
• September 2007 - JCL's RESTART Parameter
• October 2007 - What color is that? A trick with MS Paint
• November 2007 - SAS: Parsing and Counting
• December 2007 - SAS: Special missing values

2006

• January 2006 - Easytrieve: Data Compression with Packed Decimal
• February 2006 - Decision Tables
• March 2006 - Recoding data in SAS
• April 2006 - COBOL: Did you remember to test for numerics?
• May 2006 - SAS' Forward Rescan Rule
• June 2006 - Self-documenting data files in SAS
• July 2006 - Sending SAS reports to a PDS (mainframe SAS)
• August 2006 - Compress / Left-justify fields using Easytrieve
• September 2006 - Writing form letters with SAS
• October 2006 - JavaScript: parseInt with radix
• November 2006 - Java: ClassNotFoundException
• December 2006 - JavaScript: Passing data between pages

2005

• January 2005 - SQL Queries and Nulls: the COALESCE function
• February 2005 - SAS: Multiple Records from a Single Observation
• March 2005 - SAS: A Single Record from Multiple Observations
• April 2005 - Using stripped packed fields in COBOL
• May 2005 - Easytrieve: A Cautionary Note on the use of Packed Decimal Fields
• June 2005 - SAS: Parsing email addresses
• July 2005 - SAS: Passing parm data from JCL to SAS
• August 2005 - Variable Length Records: VB, RDW, BDW, Oh my!
• September 2005 - SyncSort: Reformatting variable length records
• October 2005 - SyncSort: Converting variable length records to fixed length
• November 2005 - Easytrieve Plus: Identifying duplicate records
• December 2005 - Easytrieve Plus: Matching files

2004

• January 2004 - Getting started with MySQL
• February 2004 - Accessing MySQL databases through Java
• March 2004 - Dynamic TABINDEX with PHP
• April 2004 - Javadoc
• May 2004 - Object Persistence in Java
• June 2004 - COBOL with Embedded SQL: Handling Null Fields
• July 2004 - Using Objects in Place of Primitives in Java
• August 2004 - Recoding records with SyncSort
• September 2004 - Sending SAS proc output to a SAS data set
• October 2004 - Why use views in DB2?
• November 2004 - Lookup Tables with Easytrieve
• December 2004 - Outer Joins, ON, WHERE and AND

2003

• January 2003 - Decimal Arithmetic You Can Trust (response to last month)
• February 2003 - Concatenated Datasets in ISPF
• March 2003 - An Introduction to Java Exceptions
• April 2003 - Using Exclusive Or to Swap Integers in Java
• May 2003 - Java's BigDecimal class
• June 2003 - Processing Dates in Java
• July 2003 - DB2's LOAD Utility
• August 2003 - HTML table tricks with JavaScript
• September 2003 - Composition or Aggregation?
• October 2003 - Inheritance Revisited
• November 2003 - HTML Table Tricks With XML
• December 2003 - Microsoft Visual C++ .NET Quickstart

2002

• March 2002 - Dynamically load .jpeg images from Java programs
• April 2002 - Creating a Frequency Distribution: SAS or SyncSort?
• May 2002 - When is –32,104 equal to +25,201?
• June 2002 - "Object Think"
• July 2002 - An Introduction to Inheritance
• August 2002 - Storing Dates in DB2
• September 2002 - Format conversion with SyncSort
• November 2002 - FileAid Dumps for the COBOL Programmer
• December 2002 - Java's Dirty Secret (imprecision with doubles)

Other resources

• SQLCODE Table

Copyright © 2007 by Caliber Data Training 800.938.1222