Determining Parameter Marker Data Types
When you use a parameter marker, ESQL determines a default data type for the parameter marker from the context in which the parameter marker appears. In general, ESQL assumes for any dynamic parameter marker that is an operand of a binary arithmetic or comparison operator, that its data type is the same as the other operand of the operator. For example, the dynamic parameter marker in this expression has the same data type as the 5, INTEGER (SQLDAINT):
Table 2–14 lists the default parameter marker data types in different statement locations.
If you cannot determine the data type of a dynamic parameter marker based on the rules identified in this table, the dynamic parameter marker is invalid. For example, the following expression is invalid:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |