ibm v4
7832  Reviews star_rate star_rate star_rate star_rate star_half

Loading dashDB Tables Using CLPPLUS and REST API

This IBM Web-Based Training (WBT) is Self-Paced and includes: - Instructional content available online for duration of course - Visuals without hands-on lab exercises This offering teaches cloud...

Read More
$205 USD
Course Code K04007G-WBT
Duration 4 hours
Available Formats Self Paced

This IBM Web-Based Training (WBT) is Self-Paced and includes:
- Instructional content available online for duration of course
- Visuals without hands-on lab exercises

This offering teaches cloud database support staff how to use the CLPPLUS and REST API  command line tools to load data into a dashDB for Analytics or dashDB for Transactions database.

Note: Guided eLearning is a self-paced offering which includes web-based content for self study and videos (including audio) that demonstrate the hands-on activity.

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. /terms

Skills Gained

Please refer to course overview

Who Can Benefit

Data Analysts or Data Administrators 

Prerequisites

- Knowledge of relational database fundamentals is required. Some experience creating relational database objects and load tables is recommended

Course Details

Course Outline

- Selecting tools for loading data into dashDB tables- Add a dashDB database connection for CLPPlus- Creating dashDB database objects using CLPPlus- Table organization for dashDB tables- Table compression for dashDB tables- Using the IMPORT command to load data in dashDB- Using the LOAD command to load data in dashDB- Using dashDB REST API to execute load processing for local data files- LOAD recoverability and restart- LOAD processing for row compressed tables- Table statistics for newly loaded dashDB tables- Loading a dashDB table directly from a query result- Using database recovery history to review load processing