Learning Center Log in Start Learning Free

DDS and SQL: Two Ways to Define Db2 for i Data | iRPGenie

Db2 / DDS

3 of 9 in this topic

Database Fundamentals · DDS Vs SQL Orientation

← Previous Next →

6Physical Files and Logical Files
9Introduction to Db2 for i
25DDS and SQL: Two Ways to Define Db2 for i Data
26Physical Files Explained in Depth
27DDS Field Definitions
28Keyed Physical Files
29Logical Files Explained in Depth
30Access Paths and Why They Matter
31SQL Tables vs DDS Physical Files

Lessons in Db2 / DDS

6Physical Files and Logical Files
9Introduction to Db2 for i
25DDS and SQL: Two Ways to Define Db2 for i Data
26Physical Files Explained in Depth
27DDS Field Definitions

Lesson 25 of 288

Database Fundamentals

DDS and SQL: Two Ways to Define Db2 for i Data

How Db2 for i data can be defined using either traditional DDS or modern SQL, and why both approaches still coexist today.

~6 min read

Log in to continue

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

Keyed Physical Files

29Logical Files Explained in Depth

30Access Paths and Why They Matter

31SQL Tables vs DDS Physical Files

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 would a team choose SQL over DDS for a brand new IBM i project?”

←Working with WRKOBJ, DSPOBJD, and WRKLIB Physical Files Explained in Depth→