-blank_pad ESQL Preprocessor Flag
The -blank_pad ESQL preprocessor flag specifies how values are padded with blanks when selecting values from character columns into host string variables. This flag has no effect in host languages that do not support variable-length character data (for example, Fortran).
ANSI/ISO Entry SQL-92
Specify -blank_pad. The host variable is padded with blanks to its declared size. For example, if you select a value from a column defined as char(5) into a 10-byte character variable, the host variable is padded with blanks to its full length of 10 bytes.
Ingres Default
By default, the receiving variable is padded with blanks to the width of the column from which data is selected. This flag affects the results of the following SQL statements:
• EXECUTE IMMEDIATE
• EXECUTE PROCEDURE
• FETCH
• GET DATA
• INQUIRE_SQL
• SELECT