Index

A

access control list 392
ACID principles 373
atomicity 373
consistency 373
durability 373
isolation 373
ACL 392
activate event 304
ActiveX components 35
Adaptive Server Anywhere
ODBC database configuration for 127
ODBC driver configuration utility 126
remote use 126
Adaptive Server Enterprise 31, 111
adding rows 346
All Packages folder 438
ancestor 257
apartments
multi-threaded 455
single threaded 455
API, getConnectionCacheByName 295
application
objects 40
partitioning 5, 7, 154
server 16
server, features of 4, 16, 19
application partitioning 7
application start wizard 155
applications
compiling 431
debugging 416-424
deploying 431-436
distributed 348
multi-threaded 446, 448, 455, 471
prototype client 429
updates 346
architecture 2, 17
business application 8
client/server 11
advantages of 10-11
development of 11
CORBA 39
fat client 12
fat server 14
advantages 14
limitations 15
network traffic 14
performance 15
host-centric 9
Jaguar CTS 28
Jaguar-CORBA 44
multi-tier 5
n-tier 5, 16
advantages of 18
single tier 3, 8
advantages of 9
logic placement 8
three-tier 3-4, 16-17
business logic 17
disadvantages of 17
logic placement 17
network traffic 17
two and a half-tier 12
see fat server
two-tier 3, 10
arguments 464
NULL 264
strings 463
arrays 267, 351, 453
of structures 357-358
asynchronous
calls 456
processing 446
attributes 192
access rights 252
authentication 398
login 404
NT groups 401
auto demarcation/deactivation 381
stateless components 220
autoinstantiated objects 459
automation interface 35

B

base class 462
behaviors 192
binding 293
blob 324, 328, 361, 371-372
arguments 372
copying to 362, 365
read-only 371
variable 365
bottlenecks 15, 17, 23
breakpoints 417, 419
setting in script editor 419
browser
ultra-thin application 37
buffers
changes 366
DataStore 357
delete 357
looping 355
original 346, 355
primary 352, 357
source 357
build option 375
business application architecture 8
business logic 6, 318
examples of 6
placement of 12, 17
business rules layer 6
business rules, encapsulating 321

C

cache
connection 432
finding a database connection in 296
cache name
incorrect 417
resetting 417
CacheName 296, 299
CacheName option 299
calling asynchronously 446
calling methods 260
changes
applying 370
conflicting 371
losing 359
on stateful components 359
saving 348
status flag 366
user 352
class
descendent 257
name, argument 185
object, custom 250
ClassName 130
clear deployment 182
client 4
development 431
interface 467
making Jaguar ready 325
proxies 87
workstation 10
client application 279, 318, 432
library list 465
managing state 233
client/server 10
advantages of 11
architecture 292
model 4
clusters 59
columns
changing values 346
status flags 357
updateable 355
COM
Jaguar server support of 29
COMMIT 300, 374, 377
commit, two-phase 374
committing the transaction 348
communication protocols
HTTP 30
IIOP 30
TDS 30
component
interface
definitions 430
Component Lifecycle Manager 29
Component Properties
dialog box 84
Component properties
All Properties tab 89
General tab 84
Instances tab 87
concurrency option 88
options 88
pooling option 88
Transactions tab 86-87
Automatic Fail-over option 87
demarcation/deactivation option 87
Component Properties dialog box 89
Component Type option 85
Component Wizard 82, 238
components 34, 74, 192, 406
activeX 82
adding 150, 431
adding methods 90
base 428
calling methods 199-200
communication with 194
data logic 292
deactivation 200, 202
debugging 417, 421
define new 83
define new option 82
deleting 90
deployment 75, 324, 412
deployment in Jaguar server 148
deployment verification 149
development 428, 431
events 257
function calling 261
generating proxies 413
installing 81
instance 293
deactivating 380
interface 85, 139
functions that allow NULL 266
interface definitions 250-251
interfaces supported 85
Jaguar 193, 293
life-cycle 195
lifecycle 193
model 130
model, APIs 100
models 74
models supported by Jaguar 81
models, Jaguar support for 34
modifying 89
moving 434
n_cst_states_list 342
properties 325
security 410-411
service 137, 234
shared 137, 234, 236-237
standard 137-138, 234
stateful 198, 210, 346, 381, 383-384, 441
stateless 198, 218, 346, 381-382, 384
statelessness 87
testing 429
thread 293
thread-safe 236
user name 410
variable space 193
concurrency 356
conflicting changes 371
CONNECT statement 297
connecting to a database 293
connecting to Jaguar 160
connection 297
parameters 293
connection cache 27, 31, 98, 437, 441
accessing properties 104
administration 100
database connection parameters 107
server name 107
database server performance 99
deleting 109
Driver tab 108
Enable Connection Sanity Check option 105
installation 100
guidelines 110
installion
on Jaguar server 102
modifying 103
naming 100
new connection menu 101
number of connections 105
Oracle, creating the 119
overview 99
properties 105
refresh 110
requests
waited connection 107
Connection Cache Properties
dialog box 109
Driver tab 114
General tab 114
Connection Cache properties
Microsoft SQL Server 125
Connection Manager 30-31, 98
database connections 437
connection object 156-157, 447
application property 186
custom, building a 170
custom, functions of 171
driver property 157
error codes 176
error event 173
events
constructor 159
destructor 159
error 159
functions and events 159
functions of, used by PowerBuilder 160
generated, using 167
generated, variables 167
Jaguar CTS properties 158
location property 157
naming 165
properties 157
userid 158
properties, initialization 172
Connection Object Wizard 162
connection pool
see connection caches
connection pooling 441
see database connection pooling
connections
forced 438
no wait 438
peak maximum 438
wait 438
connectstring 158
constructor 130
cookie parameter 371-372
CORBA 39
Dynamic Interface Invocation (DII) 261
IDL 74
internal error 336
object 41
stubs. See Jaguar proxy objects
CORBAfacilities 40
CORBAservices 40
CORBA 1.1 specification 40
CORBA 2.0 specification 40
CORBA IDL 82, 140, 178, 250, 271
supported PowerBuilder data types 251
CORBA ORB
stubs and skeletons 42
CREATE 298, 459
CREATE USING 275
CT-Lib software 114
Custom Class 462, 464
custom-class object, as Jaguar component 132
custom-user object, building 130

D

data 7
access 292
drivers supported 98
buffers 346
copying 357
copying into a non-DataWindow source 334
loss 441
modifications 373
moving 358
placement 12
retrieval using Jaguar CTS 318
services, examples of 7
types 92
Data Control Language (DCL), statements 308
Data Definition Language (DDL) 306
statements 308
data encryption 392
data layer 7
tasks of 7
Data Manipulation Language (DML) 306
Data Retrieval
client/server model, using 314
data sources 292
heterogeneous 3
hetrogeneous, integration of 22
pre-processing 23
data updates 346-370
database
handling connections in stateful and stateless objects 305
handling initialization and connectivity 304
instance 294
performance and scalability 305
protocols 294
update 380
database connections 293
Connection Manager 437
disconnect 304
pooling 20, 99
Database Management System (DBMS) 10
DBMS 12
Database Profile Setup 301
DBPARM parameters 303
Jaguar/MTS tab 301
Preview tab 303
data-source name (DSN) 122
DataStore 238, 298, 310, 312-313, 357
buffer 357
building a base object 319
getting data using the 321
initialization 313
DataWindow 292, 310, 314
buffers 311, 330
child data values 341
children 339
control 310
object 310
object property 338
object update properties 312
objects
DDDW 339
server-side 341
status flags 311, 352
synchronization 324, 337
techniques 314
using on the client 328
using the object notation 338
Data-Window object
DataStore control 313
DataWindow synchronization 328, 361-372, 389
DBMS 296
property 294
DBPARM 299
options 299
property 295-297
DBPass 296
deactivate event 381
debug role 392
debugging 416-424
breakpoint 417
breakpoints 419, 422
components 417, 421
Jaguar Component Project 418
Jaguar Component Wizard 418
Jaguar CTS server
console mode 419
Jaguar log file 416
Jaguar server 418
remote 417-423
DECLARE PROCEDURE 309
default behavior 464
DELETE 350
delete 346, 349, 352
buffer 357
deleting rows 346, 359-360
delimited string 464
DESTROY 298, 453
destructor 130
development
component-based 192
operating system 429
dialog window
MDI frame and department 314
Direct Connect 22
disadvantages of 9, 11, 23
DISCONNECT 297
display data 292
distributed
application development 430
applications 154, 318
architecture 432
computing 2-3, 5
technologies 424
Distributed PowerBuilder 161
Distributed Transaction Coordinator 374
DML SQL statements 373
Domain Name Services (DNS) 158
dot notation 354, 357
DPB
application
client 161
applications 304
objects, migrating 195
drivers
JDBC 292
native 292
ODBC 292
OLE DB 292
DropDownDataWindow (DDDW) 339
DSN 126, 297
dynamic
embedded SQL formats 308
functions 261
library 431
Dynascript 37

E

early deactivation 222, 224
EAS demo database 295, 314
embedded SQL statement 307
EAServer. See Enterprise Application Server.
EAStudio. See Enterprise Application Studio.
embedded SQL 298, 306, 348, 352, 355, 389
dynamic 308
static 306
encryption 413
Enterprise Application Server 2, 4, 26
Enterprise Application Studio 26
installation 49
enterprise solution 19
environment
development 432-433
duplicate 432
production 432-433
testing 432
error 464
error code 463
error event 174
available arguments 174
error handling 299
and logging 286
error messages 463
50 Distributed Service Error E13 Could not create object of class 189
50 Distributed Service Error E19 Unsupported driver name 188
57 This connection object is not connected to a server 188
compiler warning 272
Destination host unreachable 188
Error Code(20535) Error calling external object function 271
ErrorLogging 378, 416
errors
handling 289
logging 286
reporting to user 288
event calling 261
events 257
activate 132, 197
CanBePooled 132, 199, 226
choosing between functions and 260
ConnectionBegin 304
ConnectionEnd 304
constructor 197
DBError 319
deactivate 132, 199, 381
destructor 199
expose user option 258
itemchanged 359
open 470
overriding 259
SystemError 176
ue_DDDW 342
ue_save 370
ExceptionAction
ExceptionFail! 174
ExceptionIgnore! 174
ExceptionRetry! 174
ExceptionSubstituteReturnValue! 174
value types accepted 174
exceptions 91
EXECUTE DYNAMIC 309
execution path 448

F

fail-over 3, 21
fat client 12
advantages of 12
performance degradation 13
scalability 13
security 14
fat server 12, 14
advantage of 17
fault tolerance 21
filter 352, 357
filter buffer 357
flags
row status 357
status 352
forced connections 107, 438
4GL tools 11
function
CreateInstance 185
function calls 461
dynamic 261
static 261
functional implementation 192
functions 74
changing 351
choosing between events and 260
ConnectToServer 170-171
CreateFrom 336
CreateInstance 185-186, 205, 282
creating 147
DisconnectServer 172
GetChanges 367
GetContextService 286, 378
GetFullState 362
GetItem 338
GetStateStatus 371
ImportString 330, 357-358
is_connectfrom 167
IsTransactionAborted 378
local memory during call to 268
Log 287
name mangled 259
of_connect 171
of_DBMSConnect 303
of_deactivate 208, 273
of_delete 350
of_disconnect 172
of_GetConnectionInfo 167, 169
of_GetEmpByDept 322, 352
of_GetHelloObject 270
of_GetStatesList 341
of_hello 255
of_hello2__N 265
of_initialize 172-173, 254
of_insert 350
of_notify 462
of_RemoveValue 241
of_save 368, 382
of_update 349-350, 356
overriding 256
PostEvent 257
public 259
ResetUpdate 358
server memory during call to 268
SetAbort 379
SetChanges 368
SetComplete 300, 379
ShareData 327
SharedObjectRegister 450
update 346, 348, 368
Update DataWindow 311

G

General Inter-ORB Protocol (GIOP) 40
GetChanges 362, 367
GetConnectionOption 300
syntax 300
GetConnectionOption values
JAG_CM_FORCE 301
JAG_CM_NOWAIT 301
JAG_CM_WAIT 301
GetContextService 130, 378
GetParent 130
GetStateStatus 362, 371
global groups 402
global transaction object 318
global variables 297, 450
group account 392
groups
global 402
local 402

H

hackers 424
host variable 307
host-centric 8
HTTP 30

I

ID 466
IDL interface 84
IDL modules 139
CORBA specifications 139
IIOP 30, 41, 157
default Jaguar server port 57
listener setup 136
implementations 192
implicit transaction 382
ImportString function 357-358
information 2
inherit 462
inheritance 256, 259, 273
inheritance chain 279
INI file 165, 172, 466
naming 166
INSERT SQL 350
INSERT statements 358
inserts 349
instance pool 199
instance pooling 132, 138, 200, 224, 441
enabling option 225
example 228
support of 225
instance variables 460, 462-463, 465, 467
instantiate 297
instantiated object 458
inter-component transactions 375
interface definition 74, 81-82, 85, 192, 250, 431
Interface Definition Language (IDL) 41, 74
interface options dialog box 250
interface, public 259
interfaces 192
Internet Inter-ORB Protocol (IIOP) 40
inventory report 466
IP address
using ipconfig to get 66
IsTransactionAborted 378
itemchanged event 359

J

jagadmin 61, 392
user tasks 61
jagadmin password 403
Jaguar
as component-centric 193
building a client application 161
client support for 35
communication protocol support in 30
component support in 34
component wizard 234
configuring HTTP web server 69
connecting to 184
as console application 54
DBMS DLLs used by 108
and distributed PowerBuilder 161
enabling validation 272
security 33
steps to connect a client to 160
validation of data types 272
Jaguar application
client/server, differences between 154
establishing multiple connections 162
overview 319
problems 188
Jaguar client 143
building 270
steps to build application 156
Jaguar component 34, 143, 276
build in PowerBuilder 132
building a base object 273
building the 321
calling other PowerBuilder objects 275
client application 279
database connections 98
deploying 277
getting data from 327
invoking methods 186
library options 278
NULL values 264
passing Jaguar proxy to 269
properties 278
testing 280
validation 271
Jaguar Component Project 375, 418
Jaguar Component Project Wizard 151, 324
Jaguar Component Wizard 150, 418
Jaguar connection
cache 300
properties 158
Jaguar Connection Manager 293, 387
connection caches 99
Jaguar CTS 24, 26-27, 319, 392
3.0 bugs 403
as NT service 51
basic administration of 55
configuring 58
database driver support for 31
features of 29
installation and setup of 48
Listeners 64
logging activity 62
with Microsoft SQL Server 120
Oracle drivers 116
password 404
pre-configured listeners 65
server
console mode 419
starting and stopping 50
user ID 404
3.0 menu 55
Jaguar development server 425
Jaguar kernel 374
Jaguar log file 416
writing to 416
Jaguar Manager 33, 55, 74, 199, 204, 214, 216, 219, 234, 236, 299, 392, 398, 402-404, 431, 434
administering packages in 77
administrating component in 81
components, modifying 89
create Open Client connection cache 114
functions 33
getting around in 57
logging into 56, 71
logging out 70
method properties of a component in 265
Packages folder 77
Jaguar objects
accessing on different server 285
accessing, on the same server 282
adding database connectivity 303
Jaguar proxy object 143
destroying 189
generating 177-178, 326
packages and components 180
passing reference 271
Specify Server Information dialog box 179
Jaguar proxy project
creating 183
Wizard 178
Jaguar repository 74, 193
Jaguar Security Manager 392
Jaguar server 29, 431
administrator password 62
component accessing and creating 185
connecting to Sybase Adaptive Enterprise databases 112
debug mode 418
installing connection caches 102
listeners 63
log 320
properties 60
Properties, Log/Trace Tab 63
property tabs 62
Specify Server Information dialog box 164
specifying a default package 165
threading 29
unavailable dialog box 149
Jaguar transaction API 377
Jaguar Transaction Manager 139, 374, 377, 379, 387
Jaguar Users 406
JaguarHello objects
application 143
project 143
user 143
JaguarStateManager 242
JAR file 434-435
Java 82
Java DataWindow 338
Java Transaction Service (JTS) 32
JDBC driver 108

K

kernel 29
Jaguar 374
key columns 355
key field 349
key values 355
keyword
POST 262
TRIGGER 262

L

Library Painter 134
library path 429
library search path
modifying 429
listener
adding 67
deleting 66
HTTP information 67
load balancing 3, 21, 433, 437, 442-443
load testing 442
local groups 402
local object 459, 461
localhost 180
logic, update 347
LogID 296
login, authenticating 404
LogPass 296
loop 351

M

Macintosh 451
main thread 460
mapping 258
marketplace 2
MASP 336
maximum thread property 442
MDI frame and department dialog 315
memory leaks 203-204
metadata 74
method
parameters 91
method calls 461
arguments 262
asynchronous 262
posting 262
subsequent 200
method properties
deleting methods 94
modifying methods 94
Method Properties dialog box 91
New Parameter window 92
methods 74, 192
Allow NULL argument 264
calling 260
synchronous 262
calling, syntax and values 261
name, underscores 255
of_connect 185
of_GetHelloObject 269
of_initialize 185
passing arguments as read-only 267
passing arguments by reference 267
passing arguments by value 267
passing arguments to 266
passing information to 263
passing object references 269
properties 90
restrictions on arguments 263
restrictions on return values 263
testing 284
triggering and posting 262
writing 145
Microsoft Distributed Transaction Coordinator (DTC) 32
Microsoft SQL Client, configuration utility 120
Microsoft SQL Server 120
Client software
configuring 121
Client utility, installation 121
database connection authentication 123
ODBC configuration for 123
Microsoft Transaction Server 378
middle tier
see application server
mission critical 3
Modules folder 74
multi-threaded
apartment 455
application 446, 455, 471
client application 446
multi-threaded application 448

N

name mangling 264
network 437
network communication 156
protocols 156
network traffic 330, 437
network-centric 16
no wait connections 438
nonvisual user object 449
nonvisual user object (NVO) 318, 449
not supported 383
notify object 446, 457, 462-464, 467
specialized 462
notify object reference 447
n-tier architecture 5, 18, 23-24, 319
availability of 21
business logic, maintainability of 22
business logic, reusabilty of 22
data source access,advantages of 23
programming for 23
scalability 18
web-enabling 18
NULL 202
null object reference 453, 458
NULL values 140
numeric data 462

O

object 192
access rights 253
application 133
attributes 252
autoinstantiated 459
building 143
check out 426
checking in 428, 430
checking out 429
concurrent access 455
connection 447
CORBA 41
custom class user 318
custom-class 130
deactivated 380
deploying 148
dot notation 354
ErrorLogging 286, 378
events 257
functions 253
overloading 254
GetContextService 320
instantiated 458
Jaguar proxy reference 269
local 459, 461
nonvisual 130, 297
nonvisual user 449
notify 446, 457, 462, 464, 467
overriding fuctions 256
presentation 292
processng 130
project 76, 431
proxy 255, 392, 431, 465, 467-468
ResultSet 335
ResultSet, using the 335
shared 356, 446-449, 454, 458-461, 463, 470
skeleton 196
SSLServiceProvider 286
stateful 305
stateless 305, 441
stub 392
transaction 294
TransactionServer 286, 300, 378
window 468
working copy 427
Object Adapter 43
object attributes 458
object class 130, 459
object instance 458, 460-461
Object Management Architecture (OMA) 39
Object Management Group (OMG) 39
object reference 451, 453, 457-458, 460-461
NULL 458
Object Request Broker (ORB) 27
Object Type box 145
object variable, argument 185
Object-oriented
analysis and design 7
object-oriented programming 13
object-oriented techniques
inheritance 273
objects
custom connection 428
ErrorLogging 416
remote 352, 372
shared 451
TransactionServer 378
working copy 428
OCI 98
ODBC
choosing driver 122
connection 297
connection parameters 124
connection testing 124
data source, creating 121
log file 124
statistics file 124
ODBC Administrator 122
configuring data sources 126
ODBC Wizard 122
ODBS
translator 124
Open Client 98
setting Path environment 113
OPEN DYNAMIC 309
open event 470
operating-system authentication 33
options
auto demarcation/deactivation 139, 199, 207
bind thread 236
build 375
concurrency 236
Custom Class 462, 464
DSN 297
Export Package 434
GetConnectionOption 300
Import 435
Include Unreferenced Objects 142
live editing 140
pooling 199
ReleaseConnectionOption 301
remote debugging 140
SQL SELECT 314
transaction support 138
Oracle client software
configuration 118
Oracle DBMS 31
Oracle DBMS driver tab 120
Oracle DBMS General tab 119
Oracle 8 119
ORB 39
client-side 177
overwrite flag 240

P

package 74, 406-409
creating 77
deleting 80
exporting 434
installed on server 75
installing 435
installing on a server 79
package (continued)
Jaguar components 137
modifying 81
security 410
specifying 186
stored in repository 75
Package folder 77
Package Properties
all properties tab 78
general tab 78
Package Wizard 80
parallel processing 455, 457, 470
parameter values 93
parameters
cookie 371
string 460
partitioning 5
password 107, 158, 399, 404, 411, 466
jagadmin 403
PBL 181
choosing 163
peak maximum connections 438
performance 7, 21, 440-443
degradation 15
persistent cache 219
Ping utility 109
pinging 432
placeholder
question mark 309
pointer 460
polymorphism 254
pooled components
building 227
POST keyword 446
PostEvent 130
PowerBuilder 11-12, 24, 27, 130
as component model 130
building a Jaguar client in 154
building client applications 154
check-in 424
check-out 424
component implementation 273
component installation 86
connection object wizard 162
custom class user object 299
development environment 76
dynamic libraries 141
Foundation Class (PFC) library 276
Inherit dialog box 274
inherit menu option 274
inheritance 273
Jaguar component accessing objects 276
libraries 133-134, 424-425, 428-429
Library List 86
library, multiple installations 86
NVO (nonvisual object) 85, 275
object 269, 285
object browser 254
objects accessing other objects 274
PBL (PowerBuilder library) 85
project 77
resource file 142
session 197
PowerDynamo 26, 37
PowerJ 27
PowerJ 3.0 338
powerobject 464, 470
control 471
PowerScript 306
presentation
layer 6, 292
level services 6
logic 6, 12
primary buffer 346, 357
primary thread 448, 461, 471
programming stack 448
project
name definition 141
object 431
painter 431
tasks 76
wizard 151
properties
AutoCommit 300
Instance Timeout 210, 216
maximum thread 442
not supported 383
SQLCode 299
SQLDBCode 299, 307
SQLErrText 307
transaction 375
transaction timeout 388
property
Instance Timeout 218
SQLErrText 299
proxy 392
creating 196
exported 255
generating objects 182
library 181
names 182
object 342, 465, 467-468
object reference 201
reference 196, 447
removing object 202
public
functions 250, 259
interface 259
PWD 297

Q

Quality Assurance Jaguar server 433
queue 461

R

read-only blob 371
redeploying 13
Relational Database Management System (RDBMS) 23, 305
ReleaseConnectionOption 301
values 301
remote
debugger 417-423
object 352, 372
procedure call (RPC) 14
references 460
updates 352
repository 45, 74, 83
modifying connection caches 103
required new 385
ResetUpdate function 358
result set 466, 471
retrieving data 292, 305
role membership 409
roles 33, 392-397, 407
adding 393
adding to components 409
admin role 392
assigning users and groups 395
authorized users 395
components 406
debug role 392
debugger 421
deleting 394
excluded users 395
install new 407
Jaguar Users 406
modifying 395
package 406-407
password 399
refreshing 397
removing 408
removing from components 409
removing users and groups 397
user ID 399
validation 398
ROLLBACK 300, 374, 377, 379
root component 379, 386
row status flags 357
rows
adding 346
deleting 346, 359-360
isolating 355
runtime
error 464
monitoring 439
statistics 439
Runtime Display 439
runtime monitor 282, 284
component instances 437
connection caches 437
database connections 437
network 437
network traffic 437
packages 437

S

save routine 352
saving changes 348
scalability 3, 7, 20
scripts 431
breakpoints 417
search path 465
secure application server 392
Secure Socket Layer (SSL) 33, 413
security 392
authentication 411
component 410
hackers 424
method level 411
package 410
password 411
user ID 411
Security Manager 57, 392
logging into 57
server 4
crash 441
Jaguar 60
load 441
pinging 432
push technique 446, 457, 459, 471
refresh 89
ServerName 296
session management 359
session manager 29, 194
tasks performed 30
SetAbort 300, 379
SetChanges 362, 368
SetComplete 300, 379
SetfullState 362
SetItem 338
shared components
deploying 242
shared object 356, 446-449, 451, 453-454, 458-461, 463, 470
Jaguar 237
managing state 237
shared object API 449
shared object thread 452, 461
SharedObjectRegister 450
Single Document Interface (SDI) 183
single threaded apartment 455
skeleton 42
source 371
buffer 357
control 364
SQL
embedded 348, 352, 355
SQL Plus
running 118
software 118
SQL SELECT option 314
SQL Server
authentication 123
creating connection cache 125
SQLCA 297
default transaction object 298
variable 298
SQLCode 307
property values 307
SQLDA 310
SQL-Net
adding a new database alias in 116
Easy configuration utility 116
Oracle client software 116
SSL 413
stale data 232
state
active 197
idle 199-200
in method 198
State Manager 243
testing 245
stateful components 346, 381, 383-384
deactivation 210
example 211, 214
setting 210
stateful objects
deactivating 381
stateless 87
stateless components 346, 381-382, 384
building 132
example 221
in PowerBuilder 220
managing state 233
setting 219
stateless object 441
statements
COMMIT 296, 377
CONNECT 295
CREATE 275, 298, 459
DECLARE CURSOR 309
DELETE 350
DESTROY 189, 453
DISCONNECT 297
DML 310
DML SQL 373
INSERT 358
INSERT SQL 350
ROLLBACK 296, 377, 379
SELECT 306, 310
SQL SELECT 310, 315
UPDATE 349, 355-356, 358
status flags 311, 346, 352, 372
actions and the effect on 311
applying 359
changes 366
reset 370
resetting 359
stored procedures 14-15, 298
str_emp_data 351
string data types 453
string parameter 460
strings 463
array of 330
passing data 328
passing elements 329
tab-delimited 330, 349, 357-358, 471
structures
class definition of 333
using to pass data 331
stubs 41, 45, 392
Sybase Adaptive Anywhere 314
Sybase Central--Java edition 100
Sybase DBMS
connection testing 113
Sybase Enterprise Application Server (EAServer) 24
SYC database interface 114
synchronized threads 457
synchronous calls 456
System application
Environment tab 111
system performance 330
SystemError event 176

T

tab-delimited strings 349, 357-358, 471
tables, temp 356
target 371
control 364
TCP/IP network stack 432
TDS 30
technology, goals of investments 3
temp table 356
thread
boundaries 460
pooling 29
safe 296
thread,primary 461
threading model 455
threads 448, 451
primary 448
shared object 452
synchronized 457
three-tier application partitioning 17
tier 3
timeout value 388
time-slicing 448
timestamp 363
To Do List 144
transaction 373-374
aborting 377
API 375
boundary 375
committing 348
explicit 375
implicit 375, 382
inter-component 375
management 27, 350
primitive 207
properties 375, 385
properties, not supported 375
properties, required 385
properties, supported 375
root component 377
spanning multiple components 374
timeout 388
Transaction Manager 32
transaction coordinators support for 32
transaction object 294
CORBA IDL 304
creating a new 298
transaction objects 157, 297
Transaction Processing (TP) 27
transactional state 197
TransactionServer 378
TransactionServer Object 378
TriggerEvent 130, 257
two-phase commit 27
two-tier
application 317
environment 317
TypeOf 130

U

ue_save 370
UID 297
PWD 297
update 346, 368
function 348
logic 347
statement 356, 358
update statement 355
updateable columns 355
updates 346, 349, 389
automatic 359
data 346
remote 352
UseContextObject 300
values 300
user
authentication 392
authorization 392
changes 352
name 107
User Object painter 130
userID 296, 399, 404, 411, 466

V

value storage 233
values
instances active 204
method invocations 204
variable scope 453
variables
attributes
exposing 253
global 193, 450
public instance 252
shared 193
Visual Basic 12

W

wait connections 438
Web OLTP (On-Line Transaction Processing) 24
Jaguar CTS
as web server 68
web-enabled enterprise 19
WHERE clause 312, 355-356
window object 468
Windows 3.x 451
Windows 95/98 448
Windows NT 448
4.0 48
Performance Monitor 442
User Manager 399-402
wizards
Jaguar components 133
workstations
multi-tasking 11

X

X.509 digital certificates 33
XA complaint coordinators 32

Y

year 2000 problem 10