Re: sysibm.sqlcolumns column_text Corrections

Hi Chuck

You may have seen my post where I recommend NOT using SQLCOLUMNS, rather, to use SYSCOLUMNS.

Briefly,

LABEL ON COLUMN [column-name] IS 'Field Label'

update COLUMN_HEADING in SYSCOLUMNS - nothing in SQLCOLUMNS, which knows nothing about column headings (the 3-part, each 20 long stuff).

I did try a COMMENT ON TABLE, and that comment IS stored in the actual PF object - even a regular PF, not a TABLE.

I also did a COMMENT ON COLUMN, and it is also stored in the PF in the list of columns you see in a DMPOBJ output.

These "remarks" are not visible, however in DSPFD for the table or in DSPFFD for the columns.

EEEEEENteresting!

Arte J.

On 12/1/2015 8:43 AM, CRPence wrote:

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'
)