Host variable <str> is defined as CHAR[1] and cannot be used in
  SQL statements.

  Explanation:  The named variable is defined as CHAR[1].  The
  length of character variables used in SQL statements must be at
  least 2 since SQL always includes a NULL terminator.

  User Action:  Use a different variable.