Ikuti Public Training AS/400 SQL Implementation & Embedded Programming (13-17 Mei 2019)
0 likes18 views
This document describes a public training course on SQL implementation and embedded programming for IBM i. The course provides an implementation of SQL using DB2 for OS/400 or IBM i databases. It aims to teach experienced RPG IV or COBOL programmers and others how to use SQL statements to manipulate databases and embed SQL in their applications. Over the course of 5 days, attendees will learn to use interactive SQL, code queries using SELECT, FROM, WHERE and other clauses, perform joins, use functions and more to retrieve and manage data.
More Related Content
Similar to Ikuti Public Training AS/400 SQL Implementation & Embedded Programming (13-17 Mei 2019) (20)
More from Hany Paulina (20)
Recently uploaded (20)
Ikuti Public Training AS/400 SQL Implementation & Embedded Programming (13-17 Mei 2019)
- 1. Public Training AS/400 SQL Implementation and embedded Programming in IBM I 1317 Mei 2019 Purpose Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database. SQL statements can be embedded in high-level languages, dynamically prepared and run, or run interactively. This course provides an IBM i or iSeries implementation of SQL using DB2 for OS/400 or IBM i database. This course also enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs in RPG IV ILE or COBOL ILE for execution using IBM I Audience Experienced iSeries RPG IV programmers or COBOL programmers who want to learn how to use SQL as a means to perform Input/output (I/O) to access DB2 UDB for iSeries or IBM i in their applications This class workshop is also for end-users, programmers, application designers, database administrators, and system administrators who have experiences in writing RPG IV or COBOL programs but do not yet have knowledge of the SQL Data Manipulation Language (DML) and embedded it in RPG IV or COBOL programs. Objectives On completion of this course, you should be able to: Describe the major SQLs part supported for OS/400 or IBM i Operating System. Using Interactive SQL on OS/400 or IBM i Operating System. Code SQL statements to retrieve data from a DB2 table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses Code inner Joins, including joining a table to itself Use SQL arithmetic operations Use scalar and column functions Use UNION and UNION ALL Use some of additional Scalar Functions and expressions. Code simple CREATE TABLE and CREATE VIEW statements Get Promo! Voucher Carrefour 500 Ribu!!!