• SELECT SITE CURRENCY
Select a currency for use throughout the site
DB2 Universal Database
E-Careers, January 2012, Pages: 8
DB2 has a long history and is considered by many to have been the first database product to use SQL (also first developed by IBM).
This Training Course is designed for COBOL programmers who want to implement SQL into programs to access data in DB2 tables. It provides an overview of embedding SQL in a program. Course Study Format
This course is delivered through ONLINE method. The course is available for you to complete at your convenience over a 12 month period.
IT Training Course Tutor Support
ALL our home study courses include step by step online training and keyword search facilities.
Our Interactive Online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.
Should you still have any questions regarding your online course, our tutor support hotline will be available from 9am to 8pm Monday to Friday. Job Prospects
Become fully trained and substantially improve your chances of employment or earn more money!
Upon completion of the course, you can download the completion certificate as well as any other qualifications you have been awarded.
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide.
Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 9.00am-5.00pm to help you out if you get stuck.
Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.
Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.
Total Course Duration: 8 Hours
The Programming Environment
This course introduces the programming considerations related to embedding SQL statements in a COBOL program.
Duration 2 Hour(s)
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
Row and Table Manipulation
This course provides an overview of the use of DB2 and how to use it to change and manipulate data in DB2 rows and tables to affect the outcome of COBOL programs.
Duration 3 Hour(s)
Select and retrieve a single row of data Operate Working Storage to receive VARCHAR columns Select and retrieve multiple rows of data Use the FETCH statement to bring multiple rows into the application Create direct table updates Create indirect table updates Locate column values
Program Development and Efficiency
This course provides an overview of the interactive tools available for program development methods to prevent failures and invalid updates.
Duration 3 Hour(s)
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