DB2

The Programming Environment

	Describe when and why SQL is embedded in a COBOL program
	Identify the tools available and the tasks to perform in your environment
	Explain how SQL reads data into and writes from Working Storage
	Describe the communication that occurs between COBOL and SQL
	Explain the purpose of stored procedures and how they operate

Row and Table Manipulation

	Select a single row into a host structure
	Select multiple rows
	Updates tables -- directly and with a cursor

Program Development and Efficiency

	Explain program development and preparation including the use of SPUFI and DCLGEN
	Discuss error recovery practices and potential errors due to concurrent users
	Describe various considerations for program performance