Dedicated hosting Ibm server

Date – An 8-character-wide field having the format mm/dd/yy. This can be modified to other country formats with either SET DATE experession (Section 9) or by using what is called a PICTURE clause (Section 7). The SET CENTURY ON displays the entire year, i.e., mm/dd/yyyy (Section 9).

margin-left: 28.35pt; margin-right: 0in; margin-top: 0in; mso-line-height-rule: exactly; tab-stops: 21.3pt 35.45pt; text-align: justify; text-indent: -28.35pt;"> Numeric- A number consisting of a number, a decimal point, and, if it exists, the decimal part of the number. When computing the width, include the decimal point. For example, the number 9999.99 requires a field width of 7.

Logical – A 1-character-wide field containing a. T. (true or yes) or. F. (false or no) entry. Your database program returns a F. when a condition is not satisfied; a. T. is returned when a condition is satisfied. You will see operations that illustrate this process later in the book.

Memo-A memo field contains ASC II text. When looking at a memo field in the database structure, a width of 10 is shown. However, the text of the memo field is stored in a corresponding file having the file extension such as DBT. A memo field varies in length depending on the amount of text. To access the contents of a memo field, point to the field and type Ctrl+Home.