DDS to DDL

SQL versus traditional file access term

SQL versus traditional file access term There are two ways with which we can access DB2 tables and their data and they are SQL and system file acce…

QSQGNDDL API - IBM to convert DDS file into DDL table In the previous articles, on DDS to DDL conversion, it is explained how we can convert a DDS …

Identity column in DDL table Identity Column The identity column in the DDL table is a column that can be auto-populated by the system. In most cas…

QSQGNDDL API - IBM to convert DDS file into DDL table (Continuing...) This is the continuation of the article QSQGNDLL API - IBM (Part:1) before m…

DDS to DDL Modernization - Level Check Error Introduction When the DDS file gets converted to the DDL table then Level Check Error is very common…

Create View and LF Non-Keyed in IBM i View and LF are applied to the existing tables to access their data more quickly and efficiently. This articl…

Create Index and LF keyed in IBM i Index and LF are applied to the existing tables to access their data more quickly and efficiently. This article …