The following macros allow you to obtain the size information stored by the database server for a
VARCHAR column:
Table 1. Varchar type related macros
| Macro |
Description |
| MAXVCLEN |
Returns maximum number of bytes allowed in a
VARCHAR column (255). |
| VCMIN(size) |
Returns minimum number of bytes that you can store in a
VARCHAR column |
| VCLENGTH(len) |
Returns length of the host variable |
| VCMAX(size) |
Returns maximum number of characters that you can store in a
VARCHAR column |
| VCSIZ(max, min) |
Returns encoded size for the VARCHAR
column |