There are two main methods of defining database files in IBM i:
Data Description Specification (DDS) for a relational file system
DB2 UDB for IBM i Structure Query Language (SQL) for a table system