genFixedLengthSqlLike

The genFixedLengthSqlLike build descriptor option indicates whether a host value used in an SQL LIKE clause includes trailing blanks to conform to the fixed length of the value, if the value is of type CHAR, MBCHAR, or UNICODE. The option applies to COBOL and Java generation and to behavior at debug time.
For example, the myVar variable in the following code has the value abc with two blanks:
myVar UNICODE(5) = "abc";
The genFixedLengthSqlLike build descriptor option indicates whether the following SQL statement processes "abc" with or without the two blanks:
get myRecord with #sql{
      select COLUMN01 from MY_TABLE
      where COLUMN02 like :myVar
   }
   into myOtherVar;

Values

NO (the default value)
Removes trailing blanks when the variable is used in a LIKE clause.
YES
Retains trailing blanks. The variable is treated as having a fixed length. However, if the sqlVariableLen property is set to YES on the field, the trailing blanks are removed when the variable is used in a LIKE clause, regardless of the value of the genFixedLengthSqlLike build descriptor option.

Feedback