TEXT FORMAT

Here you see an example of FORMAT(TEXTHDR). The first two lines are the headline followed by the table rows.

The first line defines the column names as specified in the subcommand CREATE.

The second line defines the maximum length of a column. However if the column name is longer than the maximum length, then the length of the column name is used.

The table row lines display the cell data padded with blanks up to the maximum column length.

NAME                            FIRST_NAME              CITY
_______________________________________________________________
Bond                            James                   London
Smith                           John                    New York
Schulz                          Emma                    Berlin
Metzger                         NULL                    München
Wagner                                                  Frankfurt 

Note that INGRDS makes a difference between "empty string" and "NULL".

An empty string is a character string with length 0, for example the FIRST_NAME of Wagner is the empty string. But the FIRST _NAME of Metzger is NULL.