Filter
Top Products
Index
499
limiting number of 450
ODBC configuration 68
on SELECT statements 253
procedures 251
custom collations
about 339
creating 339
creating databases 351
D
daemon
database server as 28
data
duplicated 273, 274
exporting 171, 174
importing 171
in transactions 295
input and output formats 172
invalid 273
loading 171
data definition
concurrency rules 300
data definition language
about 99
data integrity
constraints 276
overview 273
rules in the system tables 285
data modification
permissions 173
data source description
ODBC 67
data source name
ODBC 67
See Also DSN, FileDSN, data sources 64
data sources
about 63
configuring 67
connecting with 59
creating 64
Embedded SQL 63
ODBC 63
UNIX 72
data types
character 219
conversion during loading 204
converting 202
converting between Adaptive Server Enterprise and
Adaptive Server IQ 217
creating with
sp_addtype 10
dropping user-defined 10
FLOAT 218
integer 218
matching Adaptive Server IQ and Adaptive Server
Enterprise 217
money 219
REAL 218
retrieving 11
specifying in table creation 120
SQL and C 271
database administrator
See Also DBA 354
See DBA
database administrator (DBA)
defined 354
database file
ODBC configuration 69
database name
ODBC configuration 69
database options
changing or displaying 10
Open Client 491
startup settings for TDS connections 491
database segments
locating for best performance 445
database server
about 5
as Windows NT service 28
command-line switches 28
connecting to 60
emergency stop 96
name caching 84
name switch 31
naming at startup 32
starting 21
starting from NT Start menu 26
starting on UNIX 23
starting on Windows NT 26
stopping 43, 45
DatabaseFile connection parameter