These are options for the admin command line client that are documented
in the Administrator's Reference.
-COMMAdelimited
Specifies that any tabular output from a server query is to be formatted as
Specifies that any tabular output from a server query is to be formatted as
comma-separated strings rather than in readable format. This option is
intended to be
used primarily when redirecting the output of an SQL query (SELECT command).
The
comma-separated value format is a standard data format which can be
processed by
many common programs, including spreadsheets, data bases, and report
generators.
-TABdelimited
Specifies that any tabular output from a server query is to be formatted as
Specifies that any tabular output from a server query is to be formatted as
tab-separated
strings rather than in readable format. This option is intended to be used
primarily when
redirecting the output of an SQL query (SELECT command). The tab-separated
value
format is a standard data format which can be processed by many common
programs,
including spreadsheets, data bases, and report generators.
Barry Fruchtman
ADSM Development
bf AT us.ibm DOT com
Date: Tue, 22 Jun 1999 16:25:14 -0400
From: "Norrgard, Nathan" <NNorrgard AT LIBERTY-BANK DOT COM>
Subject: ADSM 3.1.2.20 on NT
I know that you can redirect output to files from the various administrative
interfaces. However, while I can opt to do this either with Formatted
output, or delimited through the Admin GUI, I can only get formatted output
from a command-line. Is there a way to run a query and redirect the output
to file with a delimiter? Like a 'TAB'? It seems strange that you cannot.
Nathan J. Norrgard
PC Systems Administrator
Liberty Bank
860-638-2938 (v)
860-703-2113 (f)
nnorrgard AT liberty-bank DOT com
|