Assignment Rules
These are the rules for numeric assignments:
- You can assign approximate numeric values to approximate numeric targets (database columns or host language variables).
- You can assign exact numeric values to exact numeric targets; the assignment does not lose any leading significant digits.
NOTE: Progress/ESQL extension — The 1989 ANSI standard does not allow you to assign approximate numeric values to exact numeric targets.- You can assign approximate numeric values to exact numeric targets, with possible loss of precision.
The rules for character values depend on whether the target is a table column or a host language variable:
- FETCH, SELECT INTO — You can assign character values to character targets; indicators signal truncation.
- INSERT — You can insert character strings into character targets; the length of the target must be greater than or equal to the length of the source.
NOTE: Progress/ESQL extension — The 1989 ANSI standard requires target length to be greater than or equal to the source.- UPDATE — Character strings can be updated targets that are shorter than the source.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |