Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Data types and values

This chapter is subdivided into the following sections:

  • Overview

  • Data types

  • Values

  • Assignment rules

It has two parts. After an overview of the SESAM/SQL data types and their corresponding range of values, the first part provides you with all the information you need to know about data types with regard to defining table columns:

  • syntax

  • range of values defined by the data type

  • Compatibility between data types

In routines, the routine parameters and the local variables also have a data type.

The second part provides you with all the information you need for using the values of a data type:

  • syntax of the literals

  • rules for entering the values in table columns, routine parameters, and local variables

  • rules for using values in expressions and search conditions

  • rules governing data type compatibility and conversion during assignment