Lesson 189 of 288
SQL on IBM iA partial-name search screen using an embedded SQL cursor with a LIKE-based WHERE clause, loading matches into a subfile.
Create a free account to read this lesson and save your progress through the IBM i Fundamentals path.
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: “How would I change this search to match only names starting with the entered text, rather than containing it anywhere?”