1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
|
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<meta name="GENERATOR"
content="Microsoft FrontPage (Visual InterDev Edition) 2.0">
<title>MPSQL - Options Menu</title>
</head>
<body bgcolor="#ffffff">
<p><a href="mpsql.html">MPSQL
Contents</a> </p>
<h2>Options Menu</h2>
<p><img src="menu.gif" width="350" height="19"></p>
<p><strong>Spool File</strong></p>
<p>Displays a spool file dialog to the user:</p>
<p><img src="spool.gif" width="200" height="74"></p>
<p>The user enters a filename to spool the query results to.
This does not enable spooling, it only sets the file that data should be spooled
to. To create a character delimted output file using a spool file, the user
should select a column separator, set column headings off and set the column
width to zero.</p>
<p><strong>Syntax
Highlighting</strong></p>
<p>Displays a cascade menu controlling the syntax
highlighting feature.</p>
<p>Options:</p>
<blockquote>
<p>Enabled - turns on syntax highlighting.</p>
<p>Disabled<strong> </strong>- turns
off syntax highlighting.</p>
</blockquote>
<p><strong>Tabs</strong></p>
<p>Displays a tab settings dialog to the user:</p>
<p><IMG alt="" src="tabs.gif"
></p>
<p>Allows the user to enter the spacing for tabs used in the <A href="mpsql_edit.html">SQL command window</A>.</p>
<blockquote>
</blockquote>
<p><strong>Column Separator</strong></p>
<p>Displays a cascade selection of column separator
characters. These can be used to create delimited files in conjunction with
spool option. The selections available are none, tab, space and comma.</p>
<p><strong>Output Alignment</strong></p>
<p>Displays a cascade selection of output alignment
options:</p>
<blockquote>
<p>Aligned - output columns are sized and aligned by
datatype and width.</p>
<p>Standard - old style psql output, all columns are run
together. Use with column separator to spool delimited output files.</p>
<p>Expanded - displays a record with each field as a
separate line. This is identical to the expanded option in
psql.</p>
</blockquote>
<p><strong>Output Type</strong></p>
<p>Displays a cascade selection of output types:</p>
<blockquote>
<p>Text - normal text output.</p>
<p>HTML - formats output into HTML tables.</p>
</blockquote>
<p><strong>Output Options</strong></p>
<p>Displays a cascade selection of output formatting
options: </p>
<blockquote>
<p>Spool Results - controls file spooling.</p>
<p>Column Headings - controls the display of column
headings in the <a href="mpsql_output.html">Results
Window</a>.</p>
<p>Echo Query - controls the display of the SQL query in
the <a
href="mpsql_output.html">Results
Window</a>.</p>
</blockquote>
<p><strong>Save Options</strong></p>
<p>Saves the selected the currently set options and database
connection information to a configuration file in the user's home directory.
($HOME/.mpsql_cfg)</p>
<p><img src="bar.gif" width="400" height="40"></p>
</body>
</html>
|
