(Tutorial : SQL) Using Structures in SQL

Host structures are groups of variables
- Data structures in RPG
- Group items in COBOL

Structures can be used in SQL statements
- Replaces list of variables

Sample:
D EMP DS
D Job 5 0
D Name 25
D Sal 7 2
D EmpNbr S 1
C/EXEC SQL
C+ SELECT POS, NAME, SAL
C+ INTO :EMP
C+ FROM EMPL WHERE NBR = :EmpNbr
C/END-EXEC


You Might Also Want To Visit The Following Tutorial Posts:
AS/400 For Dummies
AS/400 Tutorial
SQL/400 Tutorial
Query/400 Tutorial