Using DB2 9.7, is it possible to produce a result set where the column-headers contain line-breaks? Something like:
select field_name as "Line1
Line2" from table_name I want the column-header to look like this: Line1 Line2 However, this is not for HTML. Instead I'm wanting it to look this way when I run the query (raw) in my sql editor (Dbeaver ) and in the CSV file I export from Dbeaver (so that the columns are narrower -- to prevent horizontal scrolling while viewing the result-set).
Line2" from table_name I want the column-header to look like this: Line1 Line2 However, this is not for HTML. Instead I'm wanting it to look this way when I run the query (raw) in my sql editor (Dbeaver ) and in the CSV file I export from Dbeaver (so that the columns are narrower -- to prevent horizontal scrolling while viewing the result-set).
Asked by Lonnie Best
(143 rep)
Oct 17, 2016, 08:25 PM
Last activity: Oct 18, 2016, 03:23 PM
Last activity: Oct 18, 2016, 03:23 PM