Hi SangGyu,
you are right: if you did not attend the Informix Roadshow ( Thanks Scott and Carlton for the great job!), you will never know about this simple but great feature.
For those who don't know about this new feature, it's an environment variable (export
DBACCESS_COLUMNS=1024) for instance, that display the dbaccess output in one line of (1024 screen columns here) maximum, instead of beyond 80 columns or some similar value, where the table columns value is displayed one line per column. I attach a screen dump so that you can see the result.
The limit seems to be 32768 (smallint) because at 32769 dbaccess returns a core dumped :-(
Sincerely, the code dumped is not a beautiful thing, but 32K is enough for me
------------------------------
[eric] [Vercelletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
------------------------------
Original Message:
Sent: Wed March 25, 2020 12:45 AM
From: SangGyu Jeong
Subject: DBACCESS_COLUMNS environment variable
Hi,
The DBACCESS_COLUMNS environment variable doesn't seem to be found in the knowledge center.
Does anyone know what the maximum value is?
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix