Loading…
POWERUp 2019 has ended
Experience the magic of education. 
Saturday, May 18 • 12:30pm - 4:00pm
A4CF WORKSHOP: SQL Programming

Log in to save this to your schedule and see who's attending!

SQL is much more than a query language. Besides querying and manipulating data in database objects and generating those database objects, SQL also provides all kinds of commands and constructs, for writing and executing programs. With the SQL Programming Language, Stored Procedures, Triggers and User Defined (Table) Functions can be written, without knowing anything else than SQL commands!

Learning Objectives:

This session will give you an introduction into the SQL Programming Language. The procedure and function create options and controls are explained. You’ll learn how to structure the source code within the routine body, how to define variables and cursors, what control statements are available, how to read data row by row in a loop, how to receive and return parameter values and result sets and how to handle errors. Besides the pure coding you’ll get also a short introduction into the development tools.

To register for a workshop, please visit Cosmo.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Saturday May 18, 2019 12:30pm - 4:00pm
Fantasy Tower Monorail A-B
  • Focused Education Roadmap SQL Programming
  • Level Intermediate
  • Operating System IBM i
  • Audience Managers, programmers, database administrators and even (SQL) Query users who want to enhance their SQL knowledge.

Twitter Feed