Ingres 11.2 | -blank_pad ESQL Preprocessor Flag

SQL Reference Guide > SQL Reference Guide > H. Settings for Strict ANSI Compliance > ESQL Preprocessor Flags > -blank_pad ESQL Preprocessor Flag

Was this helpful?

-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

Last modified date: 08/28/2024