AS/400 Quiz

1. How can a user insert data from a SQL procedure?Need a hint? Take a look at this AS/400 question: Data SQL procedure

• Insert rows using the INSERT statement
• Run it through an explicit call from a host language program
• Run it from a DBMS query execution shell
• All of the above

2. How can you change the field name in a physical file (PF)?Hint: Check out the discussion

• Change the 'DDM' source
• Creating a new field with either 'DDS or SQL'
• Use the command 'CHGPF'

3. Can I use a single cursor for multiple SQL statements?

• Yes
• No

4. True or False: A user can record a subfile in reverse order using READP.Hint: TomLiotta answered it correctly

• True
• False

5. How can you compare two spool files?

• Putting them into different files
• Copying them to a PF and using CMPPFM
• Using two different QShell commands

6. Can audit and database journal receivers be altered?Hint: The users have AUDIT and ALLOBJ authority

• Yes
• No

7. True or False: Do you need to recompile all dependent objects after adding new fields to an existing physical file?

• True
• False

8. What is the correct command to remove workstations from a subsystem description?Hint: The answer isn't DLTWSE

• DLTWSE
• WRKSBSD
• RMVWSE

9. How many types of data area are there in RPGLE?

• 2
• 3
• 4

10. What is the command to copy a database file to a folder in AS/400?Hint: Read the answers carefully

• CPYTOPCD
• WRKACTJOB
• STRSQL