AS400 and SQL Tricks

Join two physical files to create Join logical file in AS400 Introduction In this blog, we will be seeing an example that tells us how to create a…

Join Logical file in AS400 Introduction A Join Logical file consists of fields from more than one physical file in one record format. A join logi…

Select and Omit criteria in Logical file in AS400

Non-Join Logical file in AS400

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 …

Logical file in AS400 Introduction The Logical file (LF) is a database file object that does not contain actual data but denotes how the data is a…

ADD Constraint in DDL tables Constraints are one of the important concepts in the DDL tables. In this article, we will go through how one can add c…

Auto-update Timestamp Column using ROW CHANGE TIMESTAMP in DDL table We all have faced this case in our career when we have auto-update a file field …

Working with multimember physical files using SQL

Copy, Clear and Remove member in the multimember physical file in AS400

Attributes of DDL table DDL table attributes DDL table is formed with the help of SQL, so it is also called SQL table. A DDL table consists of many…

Column Text in DDS and DDL tables The column text is the text provided to each file field when making the file fields to understand the field. Co…

Column Heading in DDS Files and DDL tables The column heading is the name provided to each file field, which makes the file fields easy to understa…

Ways to display data of multiple members of multimember physical file in AS400