Flat File in AS400

Flat File in AS400
Flat File in AS400,Flat File in IBMi, Flat files, Create flat files, create flat file in AS400, create flat file in IBMi, CRTPF, PF with no DDS, PF with record length
Flat File in AS400

Introduction

A flat file is a physical file without DDS (Data Description Specification) and having a record length.

Create command

The CRTPF command is used to create a Flat File object since this file does not have any field definitions i.e. DDS so record length is used instead.
CRTPF FILE(EASYCLASS1/FLATFILE1) RCDLEN(100)

CRTPF, Flat file in as400, create flat file in AS400, file with no dds and record length
CREATE FLAT FILE IN AS400 USING CRTPF COMMAND

DSPFFD on Flat File 

Flat file name, a Record format name, field name are all same in the flat file. The record length provided at the time of creating flat file becomes its field length 
FLAT file in as400, CRTPF, create flat file in as400, create flat file in IBMi, DSPF, DSPFFD
DSPFFD EASYCLASS1/FLATFILE1

STRSQL

Flat file field list from STRSQL session.
Flat file in as400, CRTPF, flat file in as400
STRSQL 

Operations on Flat File

Just for your information We can perform the I/O operations such as Write, Read, Chain-Delete, Chain-Update on the flat files, and the flat file are defined as the program described files in RPG programs.


Did you find the information listed in this article helpful? If you enjoyed this article, share it with your friends and colleagues!


Thanks!



 

 


Related Post

Reading Flat File in RPGLE
Writing in flat file in RPGLE
Chain and Update in Flat file in RPGLE
Chain and Delete in Flat File in RPGLE

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain