Db2 for i MERGE Statement: INSERT, UPDATE & UPSERT
Learn how to use the Db2 for i MERGE statement to update matching rows and insert new rows in one operation, with practical IBM i SQL examples and performance guidance.
RPG Programming
RPGLE Constants and Literals
Learn the difference between an RPGLE variable, a named constant, and a literal, and how to use DCL-C, character/numeric/typed literals, and figurative constants correctly.
RPG Programming
RPGLE Data Structures Explained
Learn RPGLE data structure basics: declare typed subfields, use QUALIFIED access, reuse layouts with LIKEDS, and read simple nested structures.
RPG Programming, RPGLE
RPGLE Data Types, Lengths, and Precision
Use RPGLE character, decimal, integer, date/time, and indicator types correctly by understanding what each declaration’s length and precision mean.
RPG Programming
RPGLE Variables and Storage Types
Declare RPGLE variables with DCL-S, and see how scope and storage type – automatic, static, and working storage – control where a value is visible and how long it lives.
IBM i Fundamentals, RPG Programming
RPGLE Source Layout and Readability
Organize fully free-form RPGLE with consistent sections, spacing, indentation, continuations, and comments that make program flow easier to review.
RPG Programming, RPGLE
RPGLE Indicators and Status Flags
Learn how RPGLE indicators and status flags control legacy program flow, and how to map many patterns to clearer fully free-form logic.
RPG Programming, RPGLE
RPGLE Calculation Specs and Logic Blocks
Learn how legacy RPGLE C-specs express calculations and control flow, then map those responsibilities to clear, fully free-form RPGLE logic.
RPG Programming, RPGLE
RPGLE Input and Output Specifications Explained
Beginner guide to traditional RPGLE input and output specifications, their relationship to records and fields, and the modern fully free-form approach.
RPG Programming, RPGLE
RPGLE Control Specifications and Compiler Directives
Beginner guide to RPGLE compiler directives, the **free directive, ctl-opt, and program-wide control options.