nco_sql output breaks line at every 80 bytes

The nco_sql tool is a wrapper script around isql. The nco_sql tool only exposes a subset of the functionality of the isql utility. The isql utility is supplied by Sybase and searching the internet for the Sybase manuals will show the complete set of commands which might be able to help in formatting the required output.

The following information taken from the manual may help:

Format options for isql

Option	Default	Meaning
-s colseparator	Single space	Changes the column separator character
-w columnwidth	80 characters	Changes the line width
-e	N/A	Includes each command issued to isql in the output
-n	N/A	Removes numbering and prompt symbols

To increase the column width of your nco_sql output (to 200 characters for example), perform the following:

1) Create a backup copy of the original nco_sql wrapper script

e.g.

cd $NCHOME/omnibus/bin
cp nco_sql nco_sql.orig


2) Edit the script by changing the following line:

From:

exec $COMMON_ARCH_BIN_DIR/isql -S$OMNISERVER -U$OMNIUSER $OMNIPASSWD -I$INTERFACES $OMNITIMEOUT_ARG

To :

exec $COMMON_ARCH_BIN_DIR/isql -w 200 -S$OMNISERVER -U$OMNIUSER $OMNIPASSWD -I$INTERFACES $OMNITIMEOUT_ARG