Procedural Programming - PL-SQL, Cobol, Ispf, CICS, Triggers, Tso, Ims, JCL, Advanced Sql, complex MERGE statements, compound SQL blocks, Complex Query Construction, window analytical functions, Application Embedding, hierarchical queries, PRECOMPILE BIND REBIND, DB2 for AS400, recursive CTEs, Db2 stored procedures