Chapter 7. Working with Databases

This chapter contains recipes that show some of the techniques used to read and write data to databases. It also contains recipes that show techniques to manage tables within a database. In this chapter we will learn:

• Setting up a database connection

• Importing the table schemas

• Reading from database tables

• Using context and globalMap variables in SQL queries

• Printing your input query

• Writing to a database table

• Printing your output query

• Managing database sessions

• Passing a session to a child job

• Selecting different fields for insert, update, and delete

• Capturing individual rejects and errors

• Database and table management

• Managing surrogate keys for parent and child tables

• Rewritable lookups using an in-process database