-
DB2 Column Size
If a size of column has been changed in table (Suppose it was of 5 characters and later changed to 4 characters) and forgot to change the DCLGEN in COBOL program, will the program abend abnormally..If yes then what error will occur? If the program will not abend then what will happen?
-
What do the initials DDL and DML stand for and what is their meaning?
DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE and UPDATE.
-
What techniques are used to retrieve data from more than one table in a single SQL statement?
Joins, unions and nested selects are used to retrieve data.
-
-
What is a DB2 access path?
An access path is the method used to access data specified in DB2 sql statements.