Skip to main content

The Qlik February 2020 release has been delayed by a couple of weeks due to a security vulnerability that recently surfaced with Node.js, which is impacting a large portion of the software industry. The release is expected to be delivered before the end of the month, with a target date of February 25th, as Qlik is actively running tests to ensure that the February GA release is stable and not affected by this security malware.
To read more about this vulnerability: https://nodejs.org/en/blog/vulnerability/february-2020-security-releases/

QlikWorld 2020 Global Conference. Keynote speaker Malcolm Gladwell. Register now and save

SQLColumns

The sqlcolumns statement returns a set of fields describing the columns of an ODBC or OLE DB data source, to which a connect has been made.

Syntax:

SQLcolumns

The fields can be combined with the fields generated by the sqltables and sqltypes commands in order to give a good overview of a given database. The twelve standard fields are:

TABLE_QUALIFIER

TABLE_OWNER

TABLE_NAME

COLUMN_NAME

DATA_TYPE

TYPE_NAME

PRECISION

LENGTH

SCALE

RADIX

NULLABLE

REMARKS

For a detailed description of these fields, see an ODBC reference handbook.

Example:

Connect to 'MS Access 7.0 Database; DBQ=C:\Course3\DataSrc\QWT.mbd';

SQLcolumns;

Some ODBC drivers may not support this command. Some ODBC drivers may produce additional fields.

SQLColumns

See also:

Feedback