isql.txt

SQL> select column_name, column_def from sysibm.sqlcolumns where table_name='BOOKS' and table_schem='LIBTEST'
+---------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| COLUMN_NAME                                                                                                                     | COLUMN_DEF                                                                                                                                                                                                                                                                                                  |
+---------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| AUTHOR_VISIBILITY                                                                                                               | 0                                                                                                                                                                                                                                                                                                           |
| STATUS                                                                                                                          | 0                                                                                                                                                                                                                                                                                                           |
| READ_STATUS                                                                                                                     | 0                                                                                                                                                                                                                                                                                                           |
| NULLABLE_STATUS                                                                                                                 | 0                                                                                                                                                                                                                                                                                                           |
| LANGUAGE                                                                                                                        | 0                                                                                                                                                                                                                                                                                                           |
| ILLUSTRATOR_VISIBILITY                                                                                                          | 0                                                                                                                                                                                                                                                                                                           |
| ID                                                                                                                              | ID                                                                                                                                                                                                                                                                                                          |
| FONT_SIZE                                                                                                                       | 0                                                                                                                                                                                                                                                                                                           |
| COVER                                                                                                                           | 'hard'                                                                                                                                                                                                                                                                                                      |
| NAME                                                                                                                            | ''                                                                                                                                                                                                                                                                                                          |
| FORMAT                                                                                                                          | ''                                                                                                                                                                                                                                                                                                          |
+---------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns -1
11 rows fetched
SQL>