DB2 SQL for Experienced Users – SPVC, Milan, martedì, 09. luglio 2019

This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.
Objectives

Incorporate static SQL statements in an application program
Prepare the program for execution
Validate execution results are correct
Produce code to support multiple rows being returned from the database manager using cursors
Identify considerations regarding units of work, concurrency, and restart of programs
Identify differences between static and dynamic SQL
Provide test data for applications
Discuss program and DB2 options relative to performance of static SQL

Audience
This course is for application programmers who need to write embedded SQL programs in COBOL or PL/I (on z/OS)
PreRequisites
You should have experience with coding and executing basic SQL statements.
These skills can be developed by attending SQL Workshop (CE120), or having equivalent experience.

martedì, 09. luglio 2019, Milan, DB2 SQL for Experienced Users – SPVC

Trova eventi più interessanti
Ottenere suggerimenti eventi, sulla base di gusto Facebook. Scarica ora!Mostrami le manifestazioni adatto a meNon adesso