Total Time: 2 hour(s)

Summary: 
This course introduces the programming considerations related to embedding SQL statements in a COBOL program.

Ojectives: 
After completing this course, students will be able to:
Describe when and why SQL is embedded in a COBOL program
Identify the tools available and the tasks to perform in the users 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

Topics: 
Overview
Embedding SQL in a Program
Host Variable Coding Requirements
Responding to DB2 Messages
Stored Procedures

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.