Database

Creating a Data File in AS400

To create a file named FTPOUT that is 100 characters in length: CRTPF FILE(MYLIB/FTPOUT) RCDLEN(100) The AS/400 actually creates a file named FTPOUT, a member named FTPOUT and a field…

Database

How to Create an iSeries Database File

Procedure Launch a BlueZone iSeries Display session. From the BlueZone MenuBar, choose Transfer:Send/Receive. The BlueZone Host File Transfer desktop user interface will launch. From the Host File Transfer MenuBar choose…

Database

Tips for Database Normalization

Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a two step process that puts data…