Index_S

S

saving tables, 37–38

scanning result sets

See also SQL; querying

from C#Builder, 410–411

from Delphi, 344

from Java, 364–365

from JBuilder, 364–365

from PHP, 435

from Visual Basic, 390–391

from Visual C#, 410–411

via ADO, 390–391

via ADO.NET, 410–411

scopes and indexes, 78–79

SCORE() scalar function, 87–88, 249, 293–295

indexes and, 71

keep score, 87–88

SCOREDISTINCT() scalar function, 249, 293–295

indexes and, 71

Seagate Crystal Reports driver for ADS, 24

SECOND() scalar function, 247

security

See also data dictionaries; passwords

data dictionaries and, 93, 106–118

parameterized queries and, 251–252

setting passwords for free tables, 43–46

SQL scripts and, 251–252

seeks and indexes, 78–79

SELECT statement, 239, 254, 256, 273, 275–295

semaphore connection file path, 15

serial number, viewing, 13

server types for ADS, 11, 19–20, 21–22

server-side cursors and ADO, 373

SET reserved keyword, 239, 297–298

SET TRANSACTION statement, 300

SHORTINTEGER data type, 36

shutdown function in AEPs, 172

SIGN() scalar function, 248

SIN() scalar function, 248

sorting records, 65, 75–78, 283–284

SOUNDEX() scalar function, 249

SPACE() scalar function, 248

sp_AddIndexFileToDatabase, 315

sp_AddTableToDatabase, 315

sp_AddUserToGroup, 315

sp_CreateGroup, 315

sp_CreateLink, 315

sp_CreateReferentialIntegrity, 315

sp_CreateUser, 315

sp_DropGroup, 315

sp_DropLink, 315

sp_DropReferentialIntegrity, 315

sp_DropUser, 315

sp_ModifyDatabase, 315

sp_ModifyFieldProperty, 315

sp_ModifyGroupProperty, 315

sp_ModifyTableProperty, 315

sp_ModifyUserProperty, 315

sp_RemoveUserFromGroup, 315

SQL

Advantage Query Builder, 258–262

advantages of using, 234–235

alternatives to using, 234–235

column names in, 252

comments in, 249–250

creating triggers in, 207–211

database names in, 252

extended support for, in ADS 7, 26

field names in, 236–238

generating statements, 258–262

index names in, 252

keywords, 238–239

literals, 240–243

Native SQL Utility, 262–265

ODBC SQL Utility, 265–267

operators, 243–246

overview, 234–236

performance and indexes, 68

reserved keywords, 239

scalar functions, 246–248

scripts, 59–62, 121–122, 199, 250–252

statements, dimensions of, 252

statements, elements of, 235

subqueries, 256–257

syntax checking, 265

table names in, 236–237, 252

using, 270–300

using from ALS, 235

SQL scalar functions, 246–249

date/time, 247

math, 247–248

miscellaneous, 247, 249

string, 247–248

SQL scripts

generating, 59–62, 121–122, 258–262

in triggers, 199

security issues and, 251–252

SQL set-based databases, 5–6

SQRT() scalar function, 248

startup function in AEPs, 171–172

static cursors, 252–256, 281, 283, 285, 287, 289, 290

statistics, calculating, 286–287

stored procedures

See also Advantage Extended Procedures (AEPs)

benefits of using, 168–170

defined, 168

executing, 316

system, 314–326

string comparison operators, 245

string concatenation operator, 245

string literals, 241–242, 252

string operators, 245

structural index, defined, 30, 64

Structure Query Language. See SQL

subindexes, 71

subqueries, 256–257, 282–283

SUBSTRING() scalar function, 248

SUM reserved keyword, 239, 286

Sun ONE Studio

See also Advantage JDBC Driver; Java

driver for ADS, 23–24, 26

using with ADS, 23

system stored procedures, 314–326

system tables, 302–310

system.columns, 304–305

system.dictionary, 304

system.files, 306

system.indexes, 305–306

system.iota, 310

system.links, 309

system.objects, 310

system.permissions, 307–309

system.relations, 309–310

system.storedprocedures, 309

system.tables, 304

system.triggers, 306–307

system.usergroupmembers, 307–308

system.usergroups, 307–308

system.users, 307

system.views, 309