Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "Partitioned indexes facilitate data maintenance by making rollin and rollout operations easier."

A block of code is set as follows:

SELECT DISTINCT
STORE, INTEGER(SALESDATE)/100
FROM POS.SALES

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

db2 "CREATE TABLE POSP.MQT_REFTBLS AS ( … )
...
MAINTAINED BY SYSTEM
DISTRIBUTE BY REPLICATION"

Any command-line input or output is written as follows:

CREATE GLOBAL TEMPORARY TABLE TMP_INVCDET LIKE POSP.INVCDET ON COMMIT DELETE ROWS NOT LOGGED IN POSTEMP8K;

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Navigate to Database partition groups, right-click, and choose Create…."