Hello,
dbaccess presents select query output as a "table", one row per line, if the line is less than 80 chars, and switches to one column per line when greater than 80 chars. It does this in a linux terminal regardless of the width being well over 80 chars. This is very frustrating when you want to read your data as a "table". Does anybody know a way around this behaviour? Thankyou in advance, Rob.
For example:
rake_no fibre fibre_flg ccs ccs_flg harv_dttm
1 1736 P 1205 L 2021-06-07 14:54:17
2 1736 I 1205 N 2021-06-07 15:43:01
Becomes:
rake_no 1
fibre 1736
fibre_flg P
ccs 1205
ccs_flg L
harv_dttm 2021-06-07 14:54:17
crush_dttm 2021-06-08 11:50:00
rake_no 2
fibre 1736
fibre_flg I
ccs 1205
ccs_flg N
harv_dttm 2021-06-07 15:43:01
crush_dttm 2021-06-08 11:57:00
------------------------------
Gary McNair
------------------------------
#Informix