Learning Center Log in Start Learning Free

SQE vs CQE at a Beginner-Friendly Level | iRPGenie

← Learning Center

SQLRPGLE

30 of 33 in this topic

SQL on IBM i · Sqe Vs Cqe

← Previous Next →

32Basic SELECT on IBM i
113What is SQLRPGLE?
114Native RPGLE File I/O vs Embedded SQL
115Basic EXEC SQL Syntax in RPGLE
116Host Variables in SQLRPGLE
117SELECT INTO for Reading One Row
118Using SQL Cursor to Read Multiple Rows
119INSERT with Embedded SQL
120UPDATE and DELETE with Embedded SQL
121SQLCODE and SQLSTATE Basics in SQLRPGLE
122Handling No Row Found in SQLRPGLE
123FETCH Loop for Reading Multiple Rows
124Basic WHERE Conditions in Embedded SQL
125ORDER BY and Result Ordering
126Simple JOIN in SQLRPGLE
127NULL Handling Basics in SQLRPGLE
128Common SQLRPGLE Mistakes and Best Practices
241DDL on IBM i: CREATE TABLE, ALTER TABLE, and DROP TABLE
242SQL Indexes and Views on Db2 for i
243Constraints on IBM i: Primary Key, Foreign Key, Unique, and Check
244ACS Run SQL Scripts for IBM i Developers
245SQL Stored Procedures on IBM i
246External Stored Procedures with RPGLE
247SQL Triggers on IBM i
248User-Defined Functions on IBM i
249SQLCA, SQLCODE, and SQLSTATE in Depth
250Static SQL vs Dynamic SQL on IBM i
251SQL Precompilation with CRTSQLRPGI
252Query Optimization Basics on Db2 for i
253SQE vs CQE at a Beginner-Friendly Level
254Encoded Vector Indexes Introduction
255DRDA and Distributed Database Concepts
256Common Advanced SQL Mistakes on IBM i

Lessons in SQLRPGLE

32Basic SELECT on IBM i
113What is SQLRPGLE?
114Native RPGLE File I/O vs Embedded SQL
115Basic EXEC SQL Syntax in RPGLE
116Host Variables in SQLRPGLE

Lesson 253 of 288

SQL on IBM i

SQE vs CQE at a Beginner-Friendly Level

What SQE and CQE are, why Db2 for i has two query engines, and why this matters when reading performance advice.

~7 min read

Log in to continue

Create a free account to read this lesson and save your progress through the IBM i Fundamentals path.

Log in Create account

117

SELECT INTO for Reading One Row

118Using SQL Cursor to Read Multiple Rows

119INSERT with Embedded SQL

120UPDATE and DELETE with Embedded SQL

121SQLCODE and SQLSTATE Basics in SQLRPGLE

122Handling No Row Found in SQLRPGLE

123FETCH Loop for Reading Multiple Rows

124Basic WHERE Conditions in Embedded SQL

125ORDER BY and Result Ordering

126Simple JOIN in SQLRPGLE

127NULL Handling Basics in SQLRPGLE

128Common SQLRPGLE Mistakes and Best Practices

241DDL on IBM i: CREATE TABLE, ALTER TABLE, and DROP TABLE

242SQL Indexes and Views on Db2 for i

243Constraints on IBM i: Primary Key, Foreign Key, Unique, and Check

244ACS Run SQL Scripts for IBM i Developers

245SQL Stored Procedures on IBM i

246External Stored Procedures with RPGLE

247SQL Triggers on IBM i

248User-Defined Functions on IBM i

249SQLCA, SQLCODE, and SQLSTATE in Depth

250Static SQL vs Dynamic SQL on IBM i

251SQL Precompilation with CRTSQLRPGI

252Query Optimization Basics on Db2 for i

253SQE vs CQE at a Beginner-Friendly Level

254Encoded Vector Indexes Introduction

255DRDA and Distributed Database Concepts

256Common Advanced SQL Mistakes on IBM i

Have a question?

The AI Tutor is for educational guidance only. It cannot connect to a real IBM i system, execute code, or analyze production code. Opening it from here shares this lesson's title and content so it can answer questions about it directly, without leaving this page.

Try asking: “Why might a shop still have query patterns that end up handled by CQE instead of SQE?”

Practice this topic

←Query Optimization Basics on Db2 for i Encoded Vector Indexes Introduction→