1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

O

16

17

18

19

20

21

Clues - Across

1

This tablespace must have a clustering Index

6

The Values 'F', 'V' and 'U' are associated with this DCB parameter

7

This statement transfer records from an I/O area to the initial phase of a sorting operation.

8

This verb is used to transfer control from one part of the procedure division to another

12

This is one type of Data format.

13

VSAM can have a maximum of 123 of these

16

This is defined by a RDR(nn) statement.

17

This statement initiates the processing of a file

19

This function changes all occurrences of an expression in a string with another one.

20

This command returns a floating point value based on a specified format.

21

In this state, an image copy on a table needs to be taken while uploading/downloading a table from/to a flat file.

Clues - Down

2

A common Keyword Parameter used in the JOB and EXEC statements

3

Every program in DB2 must communicate by means of this

4

This parameter is used to delete a VSAM dataset using DELETE

5

They are a set of actions that are executed when a delete, insert or an update operation occurs in a table.

9

A general purpose, procedural language.

10

This MVS architecture supported 31 bit addressing

11

This area is set up by storage control and chained to TCTTE

14

Monitoring tool that provides information about a PLAN, PACKAGE

15

A DML command

16

This command is used to load a VSAM dataset with records

18

A user assigned number that identifies a DASD sub-system