Index
502
ODBC configuration 69
EncryptedPassword connection parameter
about 73
encryption
network packets 70
Encryption connection parameter
about 73
ENG connection parameter
about 73
EngineName connection parameter
about 73
ENP connection parameter
about 73
entity integrity
about 276
enforcing 281
environment variables
SQLCONNECT 62
error handling
ON EXCEPTION RESUME 258
error messages
character set translation 336
PIPE_NOT_CONNECTED 179
redirecting to files 175
errors
data conversion 220
insertions and deletions 300
procedures 255
transaction processing 300
ESCAPE CHARACTER option
LOAD TABLE option 181
euro symbol
1252LATIN1 collation 332, 333
exception handlers
procedures 261
exceptions
declaring 257
EXECUTE IMMEDIATE statement
procedures 264
exporting data
about 174
overview 171
extended characters
about 319
external procedures
about 268
F
failures
media 377
system 377
FETCH statement
procedures 252
file data source name
See FileDSN
FileDataSourceName connection parameter
See FileDSN
FileDSN
connection parameter 63, 73
creating 71
distributing 64
See Also data sources 64
FileDSN (file data source name)
See FileDSN
files
locating for best performance 446
redirecting output to 174
FILLER option 201
FIXED format 172
fixed width character sets
about 321
flat files
load conversion options 204
loading from 175
FLOAT_AS_DOUBLE option
Open Client 491
follow bytes
about 321
FOR statement
syntax 239
foreign keys
creating 126
inserting data 196
optional 284
referential integrity 284
retrieving information 11
unenforced 126
FoxPro format 172
FROM clause
join indexes 152
UPDATE statement 225
functions
external 268