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: "We can include other contexts through the use of the include directive."

A block of code is set as follows:

<?xml version="1.0" encoding="UTF-8"?>
<OPTPROFILE VERSION="9.1.0.0">
<!-- Global optimization guidelines section. -->
<OPTGUIDELINES>............</OPTGUIDELINES>
<!-- Statement profile section. -->
<STMTPROFILE ID="Guidelines for Q1">
<STMTKEY SCHEMA="TEST">
<![CDATA[SQL Query]]>
</STMTKEY>
<OPTGUIDELINES>...........</OPTGUIDELINES>
</STMTPROFILE>
</OPTPROFILE>

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

<OPTGUIDELINES>
<MQTENFORCE>
 <NAME='MQT1'/> <TYPE='REPLICATED'/> 
</MQTENFORCE>
<OPTGUIDELINES>

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

CREATE TABLE REPLACE1 (c1 INT, c2 INT) CREATE TABLE REPLACE2 (c1 INT, c2 INT) CREATE VIEW v1 AS SELECT * FROM REPLACE1 CREATE VIEW v2 as SELECT * FROM v1 CREATE FUNCTION fun1() LANGUAGE SQL RETURNS INT RETURN SELECT c1 FROM v2 CREATE OR REPLACE VIEW v1 AS SELECT * FROM REPLACE2 

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: "In the previous section, we can observe following information for Operator#2:".