Tag Archives: OS400

Reading Every Records on CLP – Using Record Format

At this time I will discuss about reading each record in a file in CLP using the record format in a file. To find out which file format to read, we can use the Display File Field Description (DSPFFD) command.

Continue reading Reading Every Records on CLP – Using Record Format

AS400 Display File Field Description

Display File Field Description (DSPFFD) is a command to find out the field information in a file for use in database processing. With this command we can find out the file record format along with the name of the table field with its attributes. I use this command to get information when creating a program in database processing.

Continue reading AS400 Display File Field Description

AS400 CLP Using CAT/BCAT/TCAT

Combining the two character variables on the AS400 CLP can use CAT, TCAT or BCAT. Here are the details:

  • CAT – concatenates 2 strings according to variable length (as is).
  • TCAT – concatenates 2 strings by ignoring variable lengths and removing trailing blanks for the first variable.
  • BCAT – concatenates 2 strings by ignoring variable lengths, removing trailing blanks on the first variable and adding spaces between the two variables.
Continue reading AS400 CLP Using CAT/BCAT/TCAT

AS400 Use of Journal Cache

For AS400 systems that have quite high activity, the use of Journal Cache is needed to speed up the process of writing journals to the journal receiver. By using a journal cache, entries not directly written to disk but to memory first. If several journal entries have been recorded in memory, then they will be transferred to disk.

Continue reading AS400 Use of Journal Cache