On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
|
|
400+ Course Offerings:
| DB2 for z/OS |
| DB2 for Linux, UNIX, Windows |
| Structured Query Language (SQL) |
| Java, Java EE, Frameworks and OO Design |
| Oracle |
| WebSphere MQ |
| CICS/TS |
| Mainframe - Assembler, COBOL, MVS/JCL, REXX, SAS |
| HTML, XML, Web Services and SOA |
| WebSphere Application Server |
| WebLogic |
| IMS |
| Linux |
| UNIX, C, C++ |
| PowerBuilder / InfoMaker |
| Microsoft - .NET, SharePoint, SQL Server |
| Project Management |
| Business Intelligence/Cognos |
|
|
DB1042 DB2 for z/OS Advanced Embedded Programming
|
|
|
|
Request a Course using our convenient on-line form, or Call 800.756.3000 to schedule a class in your area.
|
|
Full Course Description
|
| |
|
Duration |
2 Days |
|
Delivery Method |
Instructor Led, Hands-on Workshops |
|
Public Price |
$1125.00 | |
DESCRIPTION (Return to Top)
Have you been coding SQL in embedded programs such as COBOL for a while and looking to fine tune your skills? If so, this course is for you. Learn some advanced techniques for coding cursors including some of the new features in the latest releases of DB2. Also learn how DB2 locking affects the way programs should be coded. The course concludes with a primer on SQL optimization and the toolset provided by IBM for optimizing the queries in a program.
AUDIENCE (Return to Top)
Developers who code SQL queries embedded in host languages such as COBOL.
TOPICS (Return to Top)
- DB2 and SQL Components
- Using Scrollable Cursors
- Multi-Row Operations
- Locking Strategies & Concurrency
- SQL Performance
PREREQUISITES (Return to Top)
DB1010 or equivalent experience.
|
|
|
|
Copyright ©2013, Themis Inc. All Rights Reserved