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.

(more…)

0 Comments

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.

(more…)

0 Comments

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.
(more…)

1 Comment