As400 Interview Questions Part 7

16 Views

Prev
Next

Here’s the 7th set of 20 IBM i / AS400 interview Q&A — moving deeper into ILE, jobs, files, and system operations 🚀

1. Advantage of ILE over RPG?

  • ILE (Integrated Language Environment) advantages:

    • Modular programming (service programs, binding directories).

    • Better code reuse.

    • Exception/error handling with *PSSR and MONITOR.

    • Can mix languages (RPG, COBOL, C, CL).

    • Activation groups reduce memory issues.

2. Difference between JOBQ and PRINTQ?

  • JOBQ → Queue where batch jobs wait for execution.

  • PRINTQ (Output Queue) → Queue where spool files (reports, job logs) wait to be printed.

3. Can a file be journaled without using it under commitment control?

  • ✅ Yes. Journaling can exist independently for auditing/recovery without commitment control.

4. Can a file be used under commitment control without being journaled?

  • ❌ No. Commitment control requires journaling to track before/after images.

5. How would you print only last 10 pages of a report?

  • Use WRKSPLF → select spool file → option 6 (Print) → specify FROMPAGE / NBRPAGES.

6. Purpose of DSPLIBL command?

  • Displays the current library list of a job.

  • Useful for debugging missing library issues.

7. What are the different Queues available in OS/400?

  • Job Queue (JOBQ)

  • Output Queue (OUTQ)

  • Message Queue (MSGQ)

8. Explain RUNSQLSTM statement?

  • Executes SQL statements from a source member or stream file.

  • Syntax:

RUNSQLSTM SRCFILE(MYLIB/QSQLSRC) SRCMBR(MYMBR)

9. How would you see the Batch job?

  • Command: WRKACTJOB SBS(QBATCH) → shows active batch jobs.

  • Or WRKSBMJOB to see submitted jobs.

10. What are the attributes for the job?

  • Examples: Job name, User, Job number, Status, Subsystem, Job type (BATCH/INTERACT), Priority, Job queue, Output queue, Library list.

11. What are types of files?

  • Physical File (PF)

  • Logical File (LF)

  • Display File (DSPF)

  • Printer File (PRTF)

12. What are 4 level entries of PF?

    1. File level (e.g., REUSEDLT, LVLCHK).

    1. Record level (e.g., FORMAT definition).

    1. Field level (field name, length, type).

    1. Key level (if keyed PF).

13. Purpose of *MAP and *NOCHK in CPYF?

  • *MAP → Maps fields from source to target even if definitions differ.

  • *NOCHK → Ignores differences in record format level identifiers (forces copy).

14. How you list all LF of PF?

  • Use: DSPDBR FILE(MYLIB/MYPF) → shows dependent logical files.

15. What are the 6 level entries of LF?

    1. File level

    1. Record level

    1. Field level

    1. Select/Omit level

    1. Key level

    1. Join level (for join logical files).

16. Does a logical file contain data?

  • ❌ No. LF contains only access paths to data stored in PF.

17. Major differences between PF and LF?

  • PF → stores actual data.

  • LF → provides view of PF (can filter, join, or reorder).

  • PF mandatory for data; LF optional for alternate access.

18. What keyword is used to reference the same field in another file?

  • REFFLD (in DDS).

19. What is a Field Reference File?

  • A PF that defines only field definitions (no data).

  • Other PF/LF can use REF to pull field definitions for consistency.

20. Is PGM and ENDPGM keyword mandatory in CL program?

  • ✅ Yes, every CL source must start with PGM and end with ENDPGM.

✅ That’s now 140 Q&A across 7 sets — you’re building a gold-standard AS400 prep kit 💡

 

AS400 interview questions | Answers with explanation 20 questions | Part7

Prev
Next
Save ()

Post Comments