IDAX.GET_COLUMN_LIST - Get a list of columns

Use this stored procedure to get a list of specified columns from the specified colPropertiesTable table.

Note: This feature is available starting from Db2® version 11.5.4.

The following example shows how to call this procedure.

CALL IDAX.GET_COLUMN_LIST('colPropertiesTable=colPropertiesIris, role=input;id;target;input, type=nom;cont, separator=;');

The following example shows the returned list of specified columns. The columns are separated by semicolons.

COLUMN_LIST
 ------------------------------------------
"ID";"SEPALLENGTH";"SEPALWIDTH";"CLASS"

Parameter descriptions

colPropertiesTable

Mandatory.

The input table that contains the column properties data.

Data type: VARCHAR(256)

role: Optional.; Filter by column role.; Allowed values are input and ignore.; If the parameter is not specified, all roles will be selected.; Data type: VARCHAR(8)
type: Optional.; Filter by column type.; Allowed values are nom and cont.; If the parameter is not specified, all types will be selected.; Data type: VARCHAR(8)
separator: Optional.; Character used to separate the returned columns.; Default: ','