[ ]
{ } for accessing data
Advanced query options in VQB <1> <2>
Aggregate column data in Charting dialog box
All option in VQB <1> <2>
annotation
chart
display
array
data format
data format in VQB
attr
example
Attributes
attributes of data
attr function
example
AutoCommit
example
setting status
status via get
axis labels in Charting dialog box
bestrowid
Between condition in VQB
BINARY data type
retrieving with functions
retrieving with VQB
Binary data type 9
BLOB data types 9
BOOLEAN data type
inserting
retrieving
VQB
braces, curly
brackets, square
bridge, JDBC/ODBC 8
Catalog
catalog, changing
CatalogName
cell arrays
assigning values to cells
data format
Database Toolbox
for exporting data
for query results
setting data format in VQB
celldisp
charting
query results <1> <2>
Charting dialog box
data (x, y, z, and color)
Display <1> <2>
legend <1> <2>
preview <1> <2>
types of charts
classes111.zip example 17
classpath.txt
classes111.zip example 17
classpath.txt file 17
clearing variables from Data area
clearwarnings
close
example
Color data in Charting dialog box
cols
example
ColumnCount
ColumnName
columnnames
exporting example
importing example
columnprivileges
columns
attributes
automatically updated
cross reference
exported keys
foreign key information
imported key information
names, exporting
names, importing
names, via attr
names, via columnnames
names, via columns
number
optimal set to identify row
primary key information
privileges
viewing width
width
columns
ColumnTypeName
columnWidth
commit
example
via exec
Condition in VQB <1> <2>
confds
function reference
JDBC driver example 19
Configure Data Source dialog box
connection
clearing warnings for
close function
closing
creating
database, opening (establishing)
database, opening (establishing), example
information
JDBC
messages
object
opening
properties, getting
properties, setting
read-only
status
status, example
time allowed for
time allowed for, example
validity
warnings
constructor functions
converting numeric array to cell array
crossreference
currency
Current clauses area in VQB
example
Cursor
cursor
attributes
close function
closing
creating via exec
creating via fetch
data element
error messages
importing data
object
object, example
opening
properties
properties, example
resultset object
Data
data
attributes
attributes, example
cell array
column names
column names, example
column numbers
column numbers, example
commit function
committing
displaying results in VQB <1> <2>
exporting
exporting, example
field names
importing
importing, example
in Charting dialog box
information about
inserting into database
replacing
restrictions 7
retrieving from cell array
rolling back
rolling back, via set
rows
rows function
types 3
updating
Data area in VQB
clearing
example
data format
Database Toolbox
for query results in VQB
preferences for retrieval
preferences in VQB
data source
definition 11
for connection
ODBC connection
selecting for VQB
setting up 11
JDBC 17
JDBC, details
local ODBC 13
data types
BINARY, retrieving with functions
BINARY, retrieving with VQB
OTHER, retrieving with functions
OTHER, retrieving with VQB
supported 9
database
connecting to
connecting to, example
JDBC connection
metadata object
creating
functions
properties
properties supported
name
supported 7
URL
database
example
Database Toolbox
about 2
features 3
relationship of functions to VQB 5
starting 20
DatabaseObject
dbdemos
deleting clauses in VQB
demos
dbinfodemo
dbinsertdemo
dbupdatedemo
Visual Query Builder
Display menu in VQB
displaying
chart <1> <2> <3>
data in VQB
query results
as chart
as report <1> <2>
in Report Generator
relationally <1> <2>
Distinct option in VQB <1> <2>
dmd
example
documentation
HTML 20
dotted line in display of results <1> <2>
driver
example
object in get function
driver object
functions
functions, example
properties
drivermanager
drivermanager object
example
properties
properties, via get
Drivers
drivers
JDBC 8
JDBC compliance
loading
ODBC 8
properties
properties, drivermanager
supported 8
unloading
validity
versions
editing clauses in VQB <1> <2>
empty field
error
modifying database
error handling, preferences
error messages
cursor object
database connection object
syntax problem in VQB
error notification, preferences
examples
using functions
using VQB
exec
example
executing queries <1> <2>
example
VQB
exportedkeys
exporting data
cell arrays
inserting
example
multiple records
replacing
replacing, example
using VQB
feature 20
Fetch
fetch
example
fieldName
fields
names
selecting for VQB
size (width)
example
width
Fields in VQB <1> <2>
foreign key information
crossreference
exportedkeys
importedkeys
format for data retrieved, preferences
freeing up resources
functions
database metadata object
get <1> <2>
AutoCommit status
properties
Group by in VQB
Group key number in VQB
grouping statements
removing
Handle
Having Clauses dialog box
Having in VQB
help
online 20
Visual Query Builder
HTML documentation 20
HTML report of query results <1> <2>
Report Generator
images
importing
VQB
importedkeys
importing data
data types
BINARY and OTHER using functions
BINARY and OTHER using VQB
empty field
using functions
example
using VQB <1> <2>
In condition in VQB
index for resultset column
indexinfo
insert
example
inserting data into database
Instance
Is Null condition in VQB
isconnection
isdriver <1> <2>
isjdbc
isNullable
isnullcolumn
isReadOnly
isreadonly
isurl
Java Database Connectivity. See JDBC
JDBC
compliance
connection object
data source, setting up 17
driver instance
drivers
names
supported 8
validity
SQL conversion to native grammar
URL
via get
JDBC/ODBC bridge 8
join operation in VQB <1> <2>
labels
for legend in chart
in Charting dialog box
legend
in chart <1> <2>
labels in chart <1> <2>
Like condition in VQB
loading saved queries <1> <2>
logical data type
inserting
retrieving
VQB
LoginTimeout
Database connection object
Drivermanager object
example
logintimeout
example
LogStream
MajorVersion
MATLAB
workspace variables in VQB
memory problems
RowLimit solution
Message
attr
cursor object
database connection object
metadata object
database
example
database functions
resultset
resultset functions
methods
M-files
MinorVersion
multiple entries, selecting
namecolumn
nested SQL
NULL values
detecting in imported record
function for handling <1> <2>
preferences for reading and writing
reading from database
representation in results
setdbprefs
writing to database
nullable
num2cell
numeric data format
VQB
objects
creating
properties, getting
ObjectType
ODBC
data source, setting up 13
drivers
online help 20
Visual Query Builder
Open Database Connectivity. See ODBC drivers
Operator in VQB <1> <2>
Order By Clauses dialog box <1> <2>
Order by option in VQB <1> <2>
example
ordering results in VQB
OTHER data type 9
retrieving with functions
retrieving with VQB
overloaded functions
parentheses, adding to statements
password
example
ping
AutoCommit
example
platforms 6
precision
preferences
for Visual Query Builder
preview of chart in VQB
primary key information
primarykeys
printing
chart
display
report
privileges
columns
tables
procedurecolumns
procedures
properties
database metadata object
example
driver
getting
setting
qry file extension
example
queries
accessing subqueries in multiple tables
accessing values in multiple tables
creating with VQB <1> <2>
displaying results
as chart
as report
in Report Generator
relationally
executing <1> <2>
executing for export
exporting with VQB
grouping results
loading saved queries <1> <2>
ordering results <1> <2> <3>
refining
results <1> <2>
example
VQB
running via exec
saving <1> <2>
select statement
querybuilder
querytimeout
quitting
Visual Query Builder
quotation marks
in table and column names 7
ReadOnly
readOnly
refining queries
register
Relation in VQB <1> <2>
relational display of query results <1> <2>
replacing data
update function
Report Generator display of query results
reporting query results
Report Generator
table
requirements, system 6
reserved words 8
results
from query
viewing
ResultSet
resultset
clearing warnings for
closing
column name and index
metadata object
creating
properties
object, functions
properties
resultset
retrieving
data from cell arrays
data from database
rollback
RowLimit
fetch
get
set
rows
uniquely identifying
rows
example
rsmd
running queries <1> <2>
saving queries <1> <2>
scale
select statement
selecting data from database
selecting multiple entries in VQB
set
example
setdbprefs
example
VQB
Show legend in Charting dialog box
size
size of field
Sort key number in VQB <1> <2>
Sort order in VQB <1> <2>
sorting results in VQB
spaces
in table and column names 7
SQL
commands 9
conversion to native grammar
join in VQB <1> <2>
statement
executing
in exec
in exec, example
in VQB <1> <2>
time allowed for query
where clause
example
where clause in exec
sql2native
SQLQuery
starting
Database Toolbox 20
Visual Query Builder
Statement
status of connection
example
stored procedures
in catalog or schema
information
running
string and numeric
strings
within strings
structure data format
VQB
subqueries
example
in VQB <1> <2>
Subquery dialog box <1> <2>
supports
example
system requirements 6
TableName
tableprivileges
tables
index information
names
privileges
selecting for VQB
selecting multiple for VQB
tables
example
Tables in VQB
time
allowed for connection
allowed for SQL query
TimeOut
TransactionIsolation
Type
typeName
typeValue
undo
ungrouping statements
unique occurrences of data <1> <2>
unregister
update
example
URL
JDBC database connection
validity
URL
use field names for labels
UserName
username
example
versioncolumns
viewing query results
Visual Query Builder
demo
examples
help
main steps for using
overview <1> <2>
quitting
relationship to Database Toolbox functions 4
starting 20, <1> <2> <3>
steps to use
VQB. See Visual Query Builder
Warnings
warnings, clearing
where clause
example
Where Clauses dialog box <1> <2>
Where option in VQB <1> <2>
width
example
wildcards in VQB
workspace variables in VQB <1> <2> <3>
clearing from Data area
writable
X data in Charting dialog box
X labels in Charting dialog box
Y data in Charting dialog box
Y labels in Charting dialog box
Z data in Charting dialog box
Z labels in Charting dialog box