Course Name: CA-IDMS/SQL Enhancements Course Number: TT420 Description: This course describes a relational database and states its benefits. The course will describe SQL statements to retrieve data, based on specific criteria along with SQL statements to insert, modify, and delete data from a table. This course is set up to be used in conjunction with the demo relational database provided with CA-IDMS. There are also discussions on the data description language of SQL. Duration: 1 day Prerequisites: Familiar with CA-IDMS/SQL Option under Release 12.0. Target Audience: Database administrators or the persons responsible for implementing and supporting the CA-IDMS SQL option Objectives: Upon completion of this course, student will be able to: Describe the DISPLAY and PUNCH syntax for SQL entities Explain differences with dynamic SQL syntax Explain the use of SQLSTATE field in the SQLCA Describe changes in optimization enhancements