Loading…
NAViGATE 2022 has ended
Back To Schedule
Wednesday, October 5 • 9:45am - 10:45am
SQL in CL? Why not?!

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback Survey
One of the most recent ways that IBM enhanced CL was to add direct support for the execution of SQL statements. Is this necessary, or even desirable, in a job control language? In this session, Ted Holt talks about the ways that CL supports SQL and discusses how you might use that support in your shop. Among the topics presented are the RUNSQLSTM and RUNSQL commands, dynamic compound statements, and DB2 for i Services.

Learning Objectives:
1. Learn to access the database from CL programs and procedures 2. Learn when SQL use is and is not appropriate in CL
Speakers
avatar for Ted Holt

Ted Holt

President, General Computer Consulting Inc
Ted Holt is President of General Computer Consulting, Inc. and former senior technical editor of The Four Hundred newsletter at Guild Companies. Holt has over 40 years experience in Information Technology, primarily with IBM midrange systems.  He is author or co-author of several... Read More →

Wednesday October 5, 2022 9:45am - 10:45am CDT
Sterling Studio 4 / Virtual 4
  Programming - General
  • Session Level Intermediate
  • Audience IBM i programmers and database engineers

Attendees (27)