Application Engine | Using App Engine system variables in your programs
SQL
Tip 079: Quick and Dirty Bulk Delete
PeopleCode | Using PSRECDEFN or Project Definitions to perform SQL deletes
Tip 073: CreateArrayAny Function
PeopleCode | Using CreateArrayAny to retrieve data from unknown tables
Tip 072: No Matching Buffer
PeopleTools | Understanding and resolving a ‘no matching buffer’ error
Tip 045: Introduction to Tracing
PeopleTools | Tracing options available to a developer
Tip 042: Dynamic SQL Prompts
PeopleTools | Setting up a field prompt based on SQL text created dynamically
Tip 038: SQL Selects in PeopleCode
PeopleCode | Options to perform a SQL select (including the dreaded SQLExec)
Tip 022: COBOL SQL Statement Table
COBOL | Using the SQL statement table for troubleshooting
Tip 007: Setting Exact Column Width in Grids
PeopleTools | Running an SQL statement to set the width for column grids
Tip 006: Checking Records and Fields used in PS Queries
PS Query | Checking to see which records and fields have been used