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
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
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.
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
Command Work with Active Job (WRKACTJOB) are used to show the performance and job status on the system. All job activities on the system can be seen using this command. Many parameters can be used for displaying active jobs. Here are the parameters that I use often:Continue reading AS400 Work with Active Job