On 22-Oct-2015 11:29 -0500, Vernon Hamberg wrote:
I probably speak from ignorance, but I don't think non-i RDBMS typically
have an equivalent of column headings
Probably they do have that attribute; and the data coming from a
LABEL ON COLUMN ... IS statement syntax available from their SQL.
But probably even more likely, they would have REMARKS [aka
LONG_COMMENT], if only to provide something for the ODBC 1.0
capabilities of the sqlColumns function; i.e. data coming from a COMMENT
ON COLUMN ... IS statement syntax.
And IIRC, the sqlColumns() API results from IBM i drivers originally
[and likely still do] effect for the REMARKS, the expression of
COALESCE(remarks, labeltext, "LABEL") against SYSCOLUMNS catalog data.
Therefore the TEXT() and COLHDG() *may* have value to requests made from
elsewhere, if\when there was no COMMENT ON COLUMN done for that
Since ODBC 1.0 was added the SQL_DESC_LABEL to the sqlColAttribute
function. AIUI, that data correlates directly to the effect of the
LABEL ON COLUMN ... IS statement's string-constant data; i.e. the
"LABEL" [aka COLUMN_HEADING] from SYSCOLUMNS. That is why my opening
"Probably they do have".
- I do believe I've seen descriptions of columns in SQL Server,
though, which would be like the TEXT attribute.
I am similarly ignorant, as a result of fading memory, but what I
recall is that other databases have and use Column Heading where the DB2
for i would use\expect TEXT; that other databases have LABEL ON COLUMN
... IS statement syntax in their SQL, but nothing equivalent to the
LABEL ON COLUMN ... TEXT IS statement syntax in their SQL.
I also believe that column headings can be used in non-i reporting and
query tools, but again I speak from relative ignorance and not having
tried for awhile.
Most likely, the SQL_DESC_LABEL data; i.e. most client-based accesses
are going to reflect ODBC specifications.?