1. Basics

This chapter explains the basics of using SQL. It contains the following sections:

Organization of this chapter

1.1 SQL coding format

1.2 Data types

1.3 Literals

1.4 USER, CURRENT_DATE value function, CURRENT_TIME value function, and CURRENT_TIMESTAMP value function

1.5 Embedded variables, indicator variables, ? parameters, SQL parameters, and SQL variables

1.6 Null value

1.7 Component specification

1.8 Routines

1.9 Java routines

1.10 Specifying a datetime format

1.11 Relationship to HiRDB External Data Access

1.12 Restrictions on the use of the inner replica facility

1.13 Locator