Re: sysibm.sqlcolumns column_text Corrections

On 30-Nov-2015 16:56 -0600, Rob wrote:

<<SNIP>>

[ COMMENT ON COLUMN schema.table.column IS "Field Comment" ] Runs
in System i Navigator without an error.
[ LABEL ON COLUMN schema.table.column IS "Field Label" ] also Runs
in System i Navigator without an error.

But neither change COLUMN_TEXT.
<<SNIP>>

The former statement should have changed the REMARKS. The latter statement makes changes that are not visible\manifest in the data available from the SQLCOLUMNS VIEW [unless the VIEW is customized, or has been updated by IBM to reflect a newer ODBC [than 1.0] specification.

Try instead:

LABEL ON COLUMN schema.table.column TEXT IS 'Field Text'

Or [better IMO], enabling one statement to modify multiple columns, use the following syntax instead:

LABEL ON COLUMN schema.table
( column1 TEXT IS 'Field Text'
, [...]
, columnN TEXT IS 'Column Text'
)