Re: sqlcmd man page
On Wed, Jun 10, 2009 at 06:44, Haszlakiewicz, Eric<EHASZLA@transunion.com> wrote: > I'm having trouble getting the sqlcmd man page to show up right. I > built and installed sqlcmd 86.00 on RHEL4. Most of the man page looks > ok, but some sections don't, e.g: > > The extension commands are: > > INFO BAprintsEthe information about the base tables in the > database. > > INFO SYprints the names of any synonyms in the database. > > INFO SYprintsSthe information about the system catalog. Etc... Yeah, I see the same effect - sometimes. And mostly I don't see it, which is puzzling. So, it requires a change in the troff/nroff source. > How do I fix this? In the short term, and not very beautifully, find the lines that look like: .P The extension commands are: .HS .HI "INFO BASETABLES" .br prints the information about the base tables in the database. .HI "INFO SYNONYMS" .br prints the names of any synonyms in the database. Change the .br lines into .sp lines. It looks better, but more spaced out, if you also add a '.sp' before each .HI line. In the medium term, I'll try to work out why it sometimes works and sometimes doesn't. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Josh Billings - "Every man has his follies - and often they are the most interesting thing he has got." - http://www.brainyquote.com/quotes/authors/j/josh_billings.html
The file in question is sqlcmd.1. I've no idea which emailer doubled up the dots in the 'troff' example source which was carefully indented four spaces to avoid having things mess it up. It was also single spaced. Isn't modern technology wonderful. On Fri, Jun 12, 2009 at 00:31, Jonathan Leffler<jleffler.iiug@gmail.com> wrote: > On Wed, Jun 10, 2009 at 06:44, Haszlakiewicz, > Eric<EHASZLA@transunion.com> wrote: >> I'm having trouble getting the sqlcmd man page to show up right. I >> built and installed sqlcmd 86.00 on RHEL4. Most of the man page looks >> ok, but some sections don't, e.g: >> >> The extension commands are: >> >> INFO BAprintsEthe information about the base tables in the >> database. >> >> INFO SYprints the names of any synonyms in the database. >> >> INFO SYprintsSthe information about the system catalog. > > Etc... > > Yeah, I see the same effect - sometimes. And mostly I don't see it, > which is puzzling. > > So, it requires a change in the troff/nroff source. > >> How do I fix this? > > In the short term, and not very beautifully, find the lines that look like: > > ..P > > The extension commands are: > > ..HS > > ..HI "INFO BASETABLES" > > ..br > > prints the information about the base tables in the database. > > ..HI "INFO SYNONYMS" > > ..br > > prints the names of any synonyms in the database. > > Change the .br lines into .sp lines. It looks better, but more spaced > out, if you also add a '.sp' before each .HI line. > > In the medium term, I'll try to work out why it sometimes works and > sometimes doesn't. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Woody Allen - "Money is better than poverty, if only for financial reasons." - http://www.brainyquote.com/quotes/authors/w/woody_allen.html
>On Fri, Jun 12, 2009 at 00:31, Jonathan >Leffler<jleffler.iiug@gmail.com> >wrote: >> In the short term, and not very beautifully, find the lines >that look like: >> ..HI "INFO SYNONYMS" >> >> ..br >> >> prints the names of any synonyms in the database. >> >> Change the .br lines into .sp lines. It looks better, but >more spaced >> out, if you also add a '.sp' before each .HI line. >> >> In the medium term, I'll try to work out why it sometimes works and >> sometimes doesn't. That helped. I can actually read the man page now. Thanks! I couldn't figure out where to look for documentation about all of those formatting macros. Do you know if there's a man page (or anything) that explains this particular variant of nroff/troff/whatever is is? eric
On Solaris, you can use "man -s 5 man" to find out about the macros. I found that using 'nroff -man sqlcmd.1 | more' gave me correctly formatted output, but using 'man sqlcmd' gave the erroneously formatted output. I do not have an explanation for that at all. On Mon, Jun 15, 2009 at 15:05, Haszlakiewicz, Eric <EHASZLA@transunion.com>wrote: > >On Fri, Jun 12, 2009 at 00:31, Jonathan > >Leffler<jleffler.iiug@gmail.com> > >wrote: > >> In the short term, and not very beautifully, find the lines > >that look like: > >> ..HI "INFO SYNONYMS" > >> > >> ..br > >> > >> prints the names of any synonyms in the database. > >> > >> Change the .br lines into .sp lines. It looks better, but > >more spaced > >> out, if you also add a '.sp' before each .HI line. > >> > >> In the medium term, I'll try to work out why it sometimes works and > >> sometimes doesn't. > > That helped. I can actually read the man page now. Thanks! > > I couldn't figure out where to look for documentation about all of those > formatting macros. Do you know if there's a man page (or anything) that > explains this particular variant of nroff/troff/whatever is is? > -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. W. C. Fields <http://www.brainyquote.com/quotes/authors/w/w_c_fields.html>; - "If I had to live my life over, I'd live over a saloon." --0015174be6ea9b5223046c71eee7