The flashcards below were created by user
on FreezingBlue Flashcards.
What utility was used to sort files on the Marist Host?
- virtual storage access method
3 types of VSAM files
- entry sequence data set (esds) (sequential)
- relative record data set (hashtable)
- key-sequence data set (ksds)
what is a cluster
made up of ksds, index set, sequence set
part of the index component that points directly to the data
what is CI and a CA
- ci is the percentage of each control interval to be left free for insertions
- ca is the percentage of control intervals in each control area to be left empty.
T/F duplicates are allowed for an AIX?
What error code did you need to try an achieve for an AIX
- data descriptor
- alternate index
what dd do you need to include in the JCL for your Indexed file if it has an AIX
What is the OPEN mode of the SALESPERSON file for PCS2PRG1
evaluating values contained in 88 clauses
what is COBOL's version of a switch statement?
what should be the status when performing an ADD?
what should be the status when performing an DELETE?
What is the cobol verb that will actually remove a record from a KSDS
Describe the steps required to process a DELETE transaction
salesperson number from the transaction copybook to the salesperson copybook then issue the delete
how do we get the CR picture to appear on a RETURN
- value has to be negative.
- multiply by -1
verb last used to process a RETURN
what is file status 23 and how many appear in the transaction log
- trying to add to somebody that you have already deleted
difference between the SELECT statement use in PCS2PRG1 and PCS2PRG2
one is sequential and the other is processed randomly
what should be done to the alternate key prior to using the START verb, if the alternate key is alphanumeric?
- move NO VALUE to it.
- if it is numeric then move ZEROS to it
List the 5 conditions to test when doing a double control break program (what did you code for the EVALUTE WHEN statements)
- first record
- main control break
- secondary control break
- regular line
T/F By default the CALL statement passes data by value
Which program (Caller/Callee) is the Linkage section coded in?
callee (sub program)
Which program (Caller/Callee) is the keyword USING used in?
- call using
- procedure division using
- ON EXAM
What element # was designated for variables in the Linkage Section?
- SQL Communications area
- keeps a state of your program as it's running
When do the variables in the SQLCA get refreshed?
- after each EXEC SQL cmd
- most important is the SQLCODE
- e.g. open cursor
when programming a DB2/COBOL program, when would you use a cursor?
when you have multiple results coming back
What EXEC SQL verb is used to obtain a row from the results found in a cursor?
What mechanism indicates there are no more rows to process
- Database request module
- output of the preprocessor
- generated by the compiler
- contains all stuff that the EXEC SQL is doing and stores it in the database
executable equivalent of the DBRM
- SQL Dynamic area
- used for dynamic quires
underscores in a variable name
- _ EXEC SQL cmd
- - cobol variable
describe the number and purpose for each cursor used in PCS3PRG1
- there's only one
- for the transaction table
2 parts that make up a host variable
what are the host variables prefixed with so the precompiler knows they are indeed a host variable?
T/F - To process a sales transaction we need to "fetch" the current sales amount first?
- update will do it automatically for you
How many different types of SQL UPDATES were done in PCS3PRG1