COBOL Exam Flashcards
Which utility is used to sort files?
DFSORT
What 3 things do you specify for DFSORT?
- File to be sorted (SORTIN)
- File for the output (SORTOUT)
- Specify fields to sort (SORT FIELDS)
What 4 criteria are specified for the sort fields in DFSORT?
- Start Position
- Length of field
- Type of data (CH)
- Ascending/Descending
Which type of files were the predecessors to relational databases?
Indexed Files
What is VSAM?
Virtual Storage Access Method
What 3 types of files are created in VSAM?
- ESDS (Sequential)
- RRDS (Relative Record Data Set)
- KSDS (Key Sequenced Data Set)
What is another word for a data set in VSAM?
Cluster
What are the 2 components of a KSDS?
- Data
- Index
What is a control interval?
Unit of data that VSAM transfers between disc storage and virtual storage
How many records are stored in one control interval?
1 or more
What are control intervals stored in?
Control Areas
What is AMS?
Access Method Services
What is the continuation character in JCL?
’ - ‘
What keyword is used for COBOL’s version of a SWITCH statement?
EVALUATE
When doing a READ, what is file status 23?
Invalid key condition
What 2 functions are used to update a record?
- READ
- REWRITE
What is the AIX defining?
Alternate Key
How do you pass variables by reference to a sub program?
USING
How do you pass variables by value to a sub program?
USING BY CONTENT
What is the default way that COBOL shares variables between programs?
By Reference
What is the LINKAGE SECTION?
Handles the variables passed from one program to another
What number is used to denote the variables in the LINKAGE section?
77
What does SPUFI stand for?
SQL Processing Using File Input
What code is used for VARCHAR fields?
49
What is the SQLDA?
SQL Dynamic Area
What is the SQLCA?
SQL Communications Area
What is an SQLCODE of 100?
End of Results Table (EOF)
What does the pre-compile do with DB2?
Converts EXEC SQL commands to COBOL CALLs and creates a DBRM
What is a DBRM?
Database Request Module
