Programming Guide

A

ALIAS

dbms command

aliasing column names 11-5

Aliasing

column names to widgets 11-5

Application

aborting 5-97, 5-232

escaping to operating system 5-288

getting handle for client area 5-369

getting handle for instance 5-372

getting handle for object 5-411

getting handle to frame 5-371

getting initial state 5-370

getting previous handle 5-373

getting runtime properties 5-407

global variables 5-221, 5-233

initializing 5-218

error message 5-217

resetting display 5-425

returning after escape 5-429

setting runtime properties 5-414, 5-418

starting 5-246

using Java methods 7-2

Application runtime properties

getting 5-401

Application server

advertising services

in JetNet/Tuxedo 2-2

Array

clearing all data 5-102

copying data 5-112

declaring in JPL 2-93

deleting occurrence 5-143

find next synchonized 5-375

getting

current occurrence number 5-394

inserting occurrence 5-227

reading file contents into 5-170

sorting

at runtime 5-391, 5-392

trimming 5-458

using text editor 5-166

writing contents to file 5-164

Asynchronous service call 2-69

B

Background color

setting 5-91

Backtab 5-84

Backward compatibility

before image data 5-500

Backward scrolling

viewing database rows 11-25, 11-27, 11-51

Base window

getting Widget ID 5-563

Before image processing

backward compatibility 5-500

comparing values 5-86

copying current values 5-88

initializing 5-89

retrieving data 5-199, 5-204

Bell

invoking 5-85

setting in messages 2-39

BINARY

dbms command

fetching binary column values 11-8

Binary variable

getting maximum number of occurrences 5-7

setting occurrence length 5-8

Binary variables

deleting occurrence 5-3

getting

pointer to occurrence 5-2

getting maximum occurrence length 5-6

getting occurrence data 5-5

getting occurrence length 5-4

Buffer

copying data to 5-205

Built-in control functions 3-1

Bundles

appending data 5-78

counting items in 5-201

counting occurrences 5-202

creating 5-113

destroying 5-193

getting name 5-203

of data in JPL 2-64

optimizing 5-77

reading an occurrence 5-200

receiving 5-422

verifying name 5-229

writing to 5-450

C

Case sensitivity

transaction manager commands 8-4

CATQUERY

dbms command

writing results to widget or file 11-10

CHANGE

transaction manager command

switching transactions 8-10

Check digit function

executing 5-98

CLEAR

transaction manager command

clearing data in widgets 8-11

CLEAR command

setting behavior 5-68

Client

notifying from application server

in JetNet/Tuxedo 2-43

Client authentication

data function

in JetNet/Tuxdeo 2-13

in JetNet/Tuxedo 2-13

post-connection function

in JetNet/Tuxedo 2-14

Client connection

closing

in JetNet/Tuxedo 2-10

opening

in JetNet/Tuxedo 2-11

CLOSE

transaction manager command

closing database transaction 8-13

CLOSE CONNECTION

dbms command

closing database connections 11-14

CLOSE CURSOR

dbms command

closing database cursor 11-15

CLOSE_ALL_CONNECTIONS

dbms command

closing database connections 11-13

Colon preprocessing

simulating from C 5-23

Color attributes

setting

for area 5-91

COLUMN_NAMES

dbms command

mapping column names only 11-17

COM

creating named property 5-357

creating object 5-356

COM applications

error handling 5-421

COM components

calling methods 5-378

calling QueryInterface 5-107

getting error code 5-108

getting error message 5-109

getting property settings 5-386

receiving method's parameters 2-59

returning method's parameters 2-61

sending error to client 2-53

setting event handler 5-110

setting property settings 5-389

Combo box widget

updating contents 5-530

Command

launching 5-263

Components

creating 5-383

destroying 5-384

CONNECTION

dbms command

setting database connection 11-19

Container

counting number of widgets 5-289

creating object list 5-293

destroying object list 5-290

traversing 5-291

Continuation file

specifying 11-51

using in transaction manager 5-479

CONTINUE

availability in transaction manager 5-479

dbms command

fetching next set of rows 11-20

transaction manager command

fetching next set of data 8-16

CONTINUE_BOTTOM

dbms command

fetching last set of rows 11-22

transaction manager command

fetching last set of rows 8-19

CONTINUE_DOWN

dbms command

fetching next set of rows 11-24

transaction manager command

fetching next set of rows 8-23

CONTINUE_TOP

dbms command

fetching first set of rows 11-25

transaction manager command

fetching first set of rows 8-27

CONTINUE_UP

dbms command

fetching previous set of rows 11-27

transaction manager command

fetching previous set of rows 8-31

Cookies

retrieving cookie values 5-536

setting 5-541

COPY

transaction manager command

copying data for edit 8-35

COPY_FOR_UPDATE

transaction manager command

changing to update mode 8-37

COPY_FOR_VIEW

transaction manager command

changing to view mode 8-39

Copying

file 5-154

Correlation name

finding corresponding table view 5-52

Creating

unique file name 5-510

Currency format

stripping from string 5-466

Cursor

backtabbing to previous field 5-84

changing delay state 5-136

Cursor (database) 11-1

getting location in field 5-456

getting offset in field 5-140

moving

to field 5-395

to first field 5-216

to last field 5-262

to next line 5-376

to next occurrence of array 5-376

moving to

field 5-211

moving to next field 5-472

toggling position display 5-95

turning off 5-93

turning on 5-94

Cursor (database)

closing 11-15

declaring 11-31

executing statement 11-34

finding default connection 5-11

getting connection name 5-10

getting engine name 5-12

getting handle 5-55

specifying cursor for dbms command 11-57

verifying cursor behavior

in ODBC 5-63

Cursors (database)

verifying status 5-61

D

Data

clearing

in the transaction manager 8-11

copying

in the transaction manager 8-35

copying to buffer 5-205

forcing validation 5-196

formatting in C 5-23

inserting

in the transaction manager 8-47

modifying

in the transaction manager 8-52

receiving data bundles 2-54

restoring saved data 5-428, 5-432

scrolling through result set 11-22

selecting

in the transaction manager 8-57, 8-65

sending data bundles 2-64

Data bundles

appending data 5-75, 5-78

counting bundle items 5-201, 5-202

creating bundle 5-113

destroying 5-193

getting bundle name 5-203

optimizing 5-77

optimizing bundle storage 5-77

reading an occurrence 5-200

receiving 5-422

verifying name 5-229

writing to bundle 5-450

Database columns

aliasing to widgets 11-5

fetching binary values 5-2, 11-8

getting serial column value 12-17

mapping column names into Prolifics variables 11-17

mapping result set to widget/file 11-10

suppress repeating values 11-54

Database connections

closing 11-13, 11-14

cursor

getting the engine name 5-12

on the default connection 5-11

declaring 11-29

disabling support 5-64

finding value of option 5-56

getting handle 5-54

getting name from cursor 5-10

setting current 11-55

setting default 11-19

verifying connection status 5-60

Database cursors

getting handle 5-55

verifying status 5-61

Database drivers

commands 11-1

executing from C 5-14, 5-16

finding value of connection option 5-56

getting last command 5-57

initializing 5-13, 5-58

keywords 13-1

listing of error messages 12-11

setting options 5-65

verifying status 5-62

Database engines

disabling support 5-64

getting from specified cursor 5-12

initializing 5-13

setting current 11-59

setting default 11-33

using more than one 11-59

Databases

Database connections 11-1

Database drivers 11-1

Database engines 11-1

Date/time format

applying 5-446

applying to supplied value 5-525

DBMS commands

defined 11-1

executing from C 5-14, 5-16

finding out last command 5-57

summary 11-2

DDE

callback function

installing 5-131

cold links

creating for Panther client 5-119

cold paste links

creating for Panther client 5-126

destroying links to Panther client 5-123

disabling Panther as client 5-124

disabling Panther as server 5-134

enabling Panther as client 5-125

enabling Panther as server 5-135

executing command from Panther client 5-130

hot links

creating for Panther client 5-120

hot paste links

creating for Panther client 5-127

paste links

creating for Panther client 5-126

poking data from Panther client 5-133

requesting link data 5-129

warm links

creating for Panther client 5-121

warm paste links

creating for Panther client 5-128

DECLARE CONNECTION

dbms command

making database connection 11-29

DECLARE CURSOR

dbms command

creating database cursor 11-31

Delay cursor 5-136

Delayed write

flushing 2-26, 5-183

Deleting

file 5-159

translation table 5-561

Deselecting

in selection group 5-138

Dialog box

displaying message 5-324

for file selection 5-239

selecting file 5-160

viewing file type 5-162

Display

getting HWND handle 5-564

getting Widget ID 5-564

Display attributes

setting

for area 5-91

in status line 2-39

DLL

getting load error 5-459

installing function from 5-460

loading 5-462

dm_

@dm global variables 12-1

Double clicking

getting time between clicks 5-368

Drawing function

attaching to widget 5-80

E

Editor

invoking for arrays 5-166

Email

creating new mail object 5-303

sending 5-302, 5-304

attachments 5-300

field contents 5-305

text file 5-301

widget image 5-306

ENGINE

dbms command

setting database engine 11-33

Enterprise JavaBeans

receiving method's parameters 2-59

returning method's parameters 2-61

sending error to client 2-53

Error handler

installing 5-387

Error handling

DLL loading 5-459

for COM objects 5-108, 5-109

for menu API 5-307

for properties API 5-405

for reports 5-433

sending message to client 5-421

Error log

creating 5-296

Error messages

database drivers 12-11

displaying 5-191, 5-192

for user 5-147, 5-151

from service components 2-53

in the transaction manager

transaction manager 10-1

in Web applications 5-538

initializing application 5-217

Error messages (database)

calling function after dbms command 11-45

calling function before dbms command 11-40

engine-specific codes 12-4

engine-specific messages 12-6, 12-8

generic database driver messages 12-11, 12-14

listing 12-11

in transaction manager 5-481

installing error handler 11-42

warning codes 12-9, 12-10, 12-18

Errors

transaction manager 5-477, 5-478, 5-482, 5-483, 5-488, 5-497, 5-498, 5-499

from database 5-481

Event

posting to event broker

in JetNet/Tuxedo 2-47

subscribing to

in Tuxedo 2-82

Event broker

posting an event

in JetNet/Tuxedo 2-47

subscribing to event 2-82

unsubscribing from event

in Tuxedo 2-92

Event functions

installing 5-142, 5-224

Event handler

for COM components 5-110

Exception event

handler installed for transaction

2-101

EXECUTE

dbms command

executing statement 11-34

generating SQL

changing bind values 5-27

Executing

SQL statements 11-47, 11-48, 11-49

Exit screen 3-2

External menu 5-322

F

FETCH

transaction manager command

fetching next row of data 8-41

Fetch

setting number of rows 5-67

Field

getting cursor offset 5-140

setting current 5-211

Field data

clearing

in transaction manager 5-473

clearing all fields 5-101

clearing from array 5-102

copying array data 5-112

copying to buffer 5-205

deleting occurrence 5-143

forcing validation 5-196

formatting emtpy numeric field 5-9

getting length 5-141

of word wrapped text 5-556

reading 5-189

double precision float 5-117

from LDBs 5-71

integer 5-226

long integer 5-294

unformatted data 5-466

word wrapped text 5-558

testing

all fields for changes 5-523

for no value 5-230

for yes value 5-231

if null 5-377

validating

with check digit function 5-98

writing 5-420

double precision floating point 5-145

formatted data 5-73

integer 5-236

long integer 5-298

word wrapped text 5-559

Fields

using Java methods 7-3

File

checking for 5-156

copying 5-154

deleting 5-159

getting path name 5-153

moving 5-157

selecting in dialog box 5-160, 5-162, 5-239

File I/O

closing file stream 5-165

error handling 5-167

getting file stream handle 5-175

opening file 5-176

reading characters from file 5-172

reading line from file 5-173

rewinding file stream 5-182

setting error code 5-169

writing array to file 5-164

writing character to file 5-179

writing file contents to array 5-170

writing line of text to file 5-180

File name

creating unique 5-510

File selection

in dialog box 5-239

File types

selecting in dialog box 5-162

FINISH

transaction manager command

closing current transaction 8-43

Floating point

reading from field 5-117

writing to field 5-145

Flush buffered output 2-26

Flushing

buffered output 5-183

For loop 2-27

skip to next iteration 2-42

FORCE_CLOSE

transaction manager command

discarding changes 8-45

Form

closing 5-237

opening 5-241

Form list 5-187

Form stack

return to base screen 3-3

FORMAT

dbms command

formatting result set 11-36

Frame

getting handle 5-371

FROM clause

changing SQL generation 5-32

Function

calling from JPL 2-8

Functions

installing from DLL 5-460

G

Global JPL variable

declaring 2-29

Global variables

changing to transient status 5-543, 5-544

creating

on Web 5-539

database drivers 12-1

getting value 5-401

getting values 5-221

updating values 5-233

Goups

using Java methods 7-6

Graphics file

Windows

returning object ID 5-105

Grid widgets

using Java methods 7-5

Group

controlling cursor key 5-256

converting to field number 5-213

forcing validation 5-214

getting name from field reference 5-194

GROUP BY clause

changing SQL generation 5-35

H

HAVING clause

changing SQL generation 5-37

Help mode

invoking 5-451

Help screen

displaying 5-215

HINSTANCE handle 5-372, 5-373

HOME

moving cursor to 5-216

Hook functions

installing 5-142, 5-224

HTML

getting cookie values 5-536

setting cookies 5-541

HWND handle

getting

for drawing area 5-144

for screen-resident widget 5-545

getting for display 5-564

I

If logic 2-31

Included JPL modules 2-33

Initial state

getting 5-370

Initialization

application 5-218

error message 5-217

key translation file 5-253

menu system 5-328

of database driver 5-13

of database drivers 5-58

video translation table 5-533

Input

simulating from keyboard 3-5, 5-527

testing for keyboard activity 5-251

Insert operation

generating argument list

for service call 5-514

Inserting data

generating argument list 5-514

Installing

translation table 5-561

Instance

getting handle 5-369, 5-372

getting previous handle 5-373

Integer value

reading from field 5-226

writing to field 5-236

Interface

accessing for COM components 5-107

Interrupt handler 5-97

INVALID_CONTEXT exception 2-91

J

Java

library function interfaces 6-1

Java interfaces

calling methods

for application servers 7-8

for fields 7-3

for grids 7-5

for groups 7-6

for screens 7-7

for the application 7-2

for widgets 7-9

JetNet applications

executing JPL commands 5-511

getting service alias 5-519

inserting data 5-514

selecting data 5-515, 5-516

JIF

advertising services in 2-2

checking for changes 2-34

rereading 2-35

JPL

commands

summary

section 1-1

displaying messages 2-37

executing commands

in JetNet applications 5-511

global variables

adding to save list 5-539

changing to transient status 5-543, 5-544

loading as public module 5-244

making memory-resident 5-187

receiving data bundles 2-54

sending data bundles 2-64

unloading module 5-245

JPL calls

from C function 5-243

to JPL and installed functions 2-8

JPL commands

arguments 2-1

JPL module

include module 2-33

loading as public 2-51

unloading public 2-89

JPL procedure

declaring return type 2-49

returning from 2-60

JPL variable

allocating size 2-93

declaring 2-93

as array 2-93

global 2-29

initializing 2-93

name conventions 2-93

K

Key

disabling 5-255

get logical value 5-208

getting integer value 5-249

getting label 5-254

pushing onto input queue 5-527

setting cursor key options 5-255

Key label

displaying in messages 2-39

Key translation

initializing table 5-253

Keyboard

opening for input 5-220

Keywords

database drivers 13-1

L

Launching command 5-263

LDB

activating 5-285

changing to read/write 5-285

changing to read-only 5-285

copying data from 5-264

copying data from LDB 5-266

enabling write-through 5-118

forcing read from screen 5-297

getting

contents 5-272

current state 5-284

handle 5-274

getting active LDB handle 5-268

getting data from LDB 5-264

getting name 5-278

getting previously activated 5-270

getting previously inactivated 5-271

getting recently inactivated 5-269

getting to another instance 5-279

inactivating 5-285

initializing 5-275

loading 5-276, 5-277

popping 5-280

pushing 5-281

reading data from all 5-71

setting state 5-285

testing if loaded 5-276

unloading 5-287

writing to entry 5-282

Libraries

getting load error 5-459

installing function from DLL 5-460

loading DLL 5-462

setting search path 5-464

Library

closing 5-258

opening 5-259, 5-261

screen as window 5-548

opening screen

at cursor location 5-79

Library functions 5-1

Java interfaces 6-1

Log file

setting

for Web application 5-538

writing server message to 2-36

Logical key

getting integer value 5-249

getting label 5-254

getting value 5-208

Long integer

reading from field 5-294

writing to field 5-298

Loop

breaking from 2-4

for condition 2-27

skipping to next iteration 2-42

while condition 2-98

M

Mail

creating new mail object 5-303

sending 5-302, 5-304

attachments 5-300

field contents 5-305

text file 5-301

widget image 5-306

Math expression

specifying in function call 5-96

MDT bit

clearing for all fields 5-100

testing for modified field 5-523

Memory

allocating for application 5-218

deallocating 5-425

from argument lists 5-513

Memory-resident list

purging 5-431

updating 5-187

Menu

adding item 5-335

changing properties 5-309

creating

at runtime 5-313

deleting

at runtime 5-314

deleting item 5-338

external reference 5-322

getting last error 5-307

getting property 5-315

initializing 5-328

installing 5-318

installing unique content 5-321

loading 5-344

popup for field 5-404

property constants 5-310, 5-316

removing 5-322, 5-323

setting scope 5-318

sharing content 5-321

unloading 5-346

Menu item

adding at runtime 5-335

changing properties 5-329

deleting 5-338

getting properties 5-339

property constants 5-340

type constants 5-336

Menu items

property constants 5-330

Menu script

loading into memory 5-344

unloading into memory 5-346

Message

acknowledgment 2-38, 2-40

acknowledgment key 2-39

bell 2-39

default display

in status line 2-38

in window 2-38

displaying

error tag 2-37

forcing to window 2-40

in dialog box 5-324

through JPL commands 2-37

using function 5-147, 5-151

displaying attributes in 2-39

displaying error message 5-191, 5-192

displaying in status line 5-147, 5-151

finding 5-355

forcing to status line 2-40

automatic dismissal 2-39

key labels in 2-39

line break insertion 2-40

putting on status line 5-350

Ready/Wait status 5-454

retrieving from message file 5-352

setting attributes 5-148

writing to log 5-296

Message dialog box

button combinations 5-325

default button 5-326

modality 5-326

system icon 5-326

text format options 5-325

Message file

deleting 5-351

reading 5-353

Message handler

invoked by client 2-56

Metafile

displaying and printing 5-434

Method

receiving parameters 5-423

Methods

executing COM methods 5-378

returning parameters 5-430

Middleware

broadcasting service message

in JetNet/Tuxedo 2-5

connecting client to

in JetNet/Tuxedo 2-11

disconnecting client from

in JetNet/Tuxedo 2-10

Middleware transaction

committing 2-104, 2-106

completing 2-106

rolling back 2-106, 2-108

starting 2-100

Mouse events

getting state of buttons 5-347

getting system time 5-368

Mouse pointer

help mode shape 5-451

Moving

file 5-157

N

NEW

transaction manager command

entering new data 8-47

Numeric data

formatting empty field 5-9

O

Object ID

for graphics file 5-105

Objects

creating 5-383

OCCUR

dbms command

setting occurrence for SELECT 11-38

Occurrence

deleting 5-143

deselecting

in selection group 5-138

getting current number 5-394

inserting 5-227

ODBC

verifying cursor behavior 5-63

ONENTRY

dbms command

calling function before dbms command 11-40

ONERROR

dbms command

installing error handler 11-42

ONEXIT

dbms command

calling function after dbms command 11-45

Operating system

escaping from application 5-288

executing command 5-457

from JPL 3-6

getting date/time 5-446

returning to application 5-429

Option menu widget

identifying to external screen 5-399

updating contents 5-530

ORDER BY clause

changing SQL generation 5-43

P

Parameters

declaring in JPL

named procedure 2-49

unnamed procedure 2-45

name requirements

in JPL 2-45

Password

supplying on client connection

in JetNet/Tuxedo 2-13

Path

finding for file 5-153

Percent escapes

in JPL message commands

in message commands 2-38

Playback function

turning on or off 5-250

Polling

for reply from service 2-69

Popup menu

invoking 5-404

Printing

report metafile 5-434

screen 5-374

Procedure

declaring in JPL 2-49

Programming

in JPL

command summary 1-1

Properties

error handling 5-405

for application 5-221, 5-233

getting at runtime 5-407

getting handle to object 5-411

setting at runtime 5-414

setting item 5-418

translating JPL mnemonics to interger IDs 5-413

Public module

loading 2-51, 5-244

unloading 2-89, 5-245

Q

QueryInterface

calling for COM components 5-107

R

Ready/Wait status

displaying 5-454

Record function

turning on or off 5-250

REFRESH

transaction manager command

refreshing the screen 8-50

Reliable queue

dequeuing message

in Tuxedo 2-18

enqueuing message

in Tuxedo 2-22

Report processing

returning last error message 5-433

running reports 5-435

Reports

generating

with JPL 2-62

printing 5-434

viewing report metafile 5-434

Repository

opening 5-139

Request broker command

executing from C function 5-511

Return codes

stored procedures 12-7

Return value 2-60

declaring type in JPL 2-49

Rows

determining number fetched 12-15

fetching 11-20, 11-22

value of @dmrowcount in DBMS START 11-50

Running reports

with JPL command

refheader 2-62

Runtime properties

getting 5-407

setting 5-414

S

SAVE

transaction manager command

saving database changes 8-52

Screen

changing window through keyboard 3-7

closing 3-2, 3-4, 5-103, 5-237

displaying 5-70

forcing validation 5-436

forcing write from LDB 5-297

freeing saved data 5-469

HWND handle 5-144

memory-resident

adding to list 5-295

removing 5-528

memory-resident list

updating 5-187

opening

as a window 5-548

as form 5-241

as window 5-247

at cursor location 5-79

search path 5-185

through dialog box 3-4

pre-loading into memory 5-295

printing 5-374

refreshing 5-424

removing from save list 5-529

restoring saved data 5-428, 5-432

save list

check for screen 5-235

saving

in memory 5-470

saving data 5-438, 5-468

setting next sibling window 5-453

shrinking 5-458

translating coordinates to pixels 5-521

trimming 5-547

using Java methods 7-7

widget ID 5-144

Screen data transfer. See Sending data

Screen editor

setting defaults 5-464

Screen save list

adding screen 5-295

removing screen 5-528

Scrolling

specifying backward scrolling 11-25, 11-27

specifying continuation file 11-51

Search path

screen 5-185

SELECT

transaction manager command

fetching data for update 8-57

SELECT statement

fetching binary columns 11-8

formatting result set 11-36

freeing memory 5-26

generating SQL

appending text 5-46

changing select list 5-40

number of rows fetched 12-15

no more rows status 12-15

scrolling through result set 11-20, 11-51

setting number of rows 5-66

setting number of rows per fetch 5-67

setting starting row 11-50

suppressing repeating values 11-54

writing results

to a file 11-10

to a specific occurrence 11-38

Selecting data

generating argument list 5-515, 5-516

Selection group

deselecting 5-138

selecting 5-449

Sending data

appending bundle item 5-78

appending to bundle

Bundles

appending data 5-75

counting bundle items 5-201, 5-202

destroying bundle 5-193

getting bundle name 5-203

initializing bundle 5-113

reading bundle data through JPL 2-54

reading occurrence from bundle 5-200

verifying bundle name 5-229

with C function 5-422, 5-450

writing data to bundle

through JPL 2-64

Serial column

@dmserial 12-17

Service

advertising

in JetNet/Tuxedo 2-2

returning from

in JetNet/Tuxedo 2-79

Service components

receiving method's parameters 2-59

returning method's parameters 2-61

sending error to client 2-53

Service group

advertising

in JetNet/Tuxedo 2-2

Service messages

broadcasting

in JetNet/Tuxedo 2-5

dequeuing from reliable queue

in Tuxedo 2-18

enqueuing on reliable queue

in Tuxedo 2-22

forwarding

in JetNet/Tuxedo 2-77

sending from server to client

in JetNet/Tuxedo 2-43

unloading data from

in JetNet/Tuxedo 2-90

Service request

cancelling

in JetNet/Tuxedo 2-75

event stream 2-69

forwarding

in JetNet/Tuxedo 2-77

getting Tuxedo callid 5-520

initiating

in JetNet/Tuxedo 2-66

receiving arguments from client

in JetNet/Tuxedo 2-54

returning from

in JetNet/Tuxedo 2-79

setting priority 2-68

unadvertising

in JetNet/Tuxedo 2-87

waiting for completion

in JetNet/Tuxedo 2-95

Services

getting service alias 5-519

inserting data 5-514

selecting data 5-515, 5-516

Setup variables

setting at runtime

Application behavior

setting at runtime 5-397

Sibling window

changing focus 5-552

setting next opened window 5-453

SQL

executing SQL statements 11-47, 11-48, 11-49

on named cursor 11-34

generating 5-19

SQL generation

appending text 5-46

calling in C 5-19

changing bind values 5-27

changing FROM clause 5-32

changing GROUP BY clause 5-35

changing HAVING clause 5-37

changing ORDER BY clause 5-43

changing select list 5-40

changing WHERE clause 5-48

generating SELECT statement 5-53

START

dbms command

setting starting row 11-50

transaction manager command

initiating transaction 8-62

Starting

Panther 5-246

Status bar

deleting section 5-439

formatting 5-440

getting contents 5-441

inserting section 5-442

setting contents

of section 5-445

Status line

cursor position display 5-95

default message 2-37

overriding 2-37, 5-114

flushing 5-299

message 5-350

setting text 5-452

toggling status 5-454

Status line function

cursor position display 5-95

STORE

dbms command

setting continuation file 11-51

Stored procedures

return codes 12-7

String

reading from file 5-173

writing to file 5-180

Styles

disabling 5-17

enabling 5-18

Synchonized arrays

finding next 5-375

Synchronous service call 2-69

T

TAB

calling in C function 5-472

Table view

before image data 5-204

Table views

getting correlation name (alias) 5-52

Terminal

changing display size 5-426

flushing buffer 5-183

flushing delayed write 2-26

initializing 5-218

refreshing 5-424

resetting to system defaults 5-425

Text

reading from field

word wrapped 5-558

writing to field 5-420

word wrapped 5-559

Text editor

invoking for arrays

File I/O

invoking editor for editing array 5-166

Timeout

preventing 2-66

Timeout function

testing input 5-251

Transaction

Database drivers 11-1

in the transaction manager

changing transactions 8-10

closing the current transaction 8-43

starting a new transaction 8-62

setting timeout

on middleware transaction 2-100

specifying service call outside of 2-67

XA

committing 2-104

completing 2-106

rolling back 2-108

starting 2-100

Transaction commands

executing 5-475

Transaction events 8-5, 9-1

after an error 8-5

clearing event stack 5-474

getting event name 5-487

getting event number 5-485

popping event from stack 5-505

pushing onto stack 5-508

Transaction manager

availability of CONTINUE 5-479

before image processing 5-86, 5-88, 5-89, 5-199, 5-204

changing to update mode 8-37

changing to view mode 8-39

clear fields 5-473

clearing data in widgets 8-11

clearing event stack 5-474

closing current transaction 8-43

closing database transaction 8-13

commands 8-1

listing of events 8-5

controlling event stack 5-505, 5-508

copying data

for edit 8-35

discarding changes 8-45

entering new data 8-47

error processing

error list 10-1

errors

database 5-481

error logs 5-483

reporting 5-477, 5-478, 5-482, 5-488, 5-497, 5-498, 5-499

executing command 5-475

fetching data

for update 8-57

for view 8-65

getting first set of rows 8-27

getting last set of rows 8-19

getting next set of rows 8-16, 8-23, 8-41

getting previous set of rows 8-31

freeing memory 5-26

generating SQL

appending text 5-46

changing bind values 5-27

changing FROM clause 5-32

changing GROUP BY clause 5-35

changing HAVING clause 5-37

changing ORDER BY clause 5-43

changing select list 5-40

changing WHERE clause 5-48

for SELECT statements 5-53

getting attributes 5-491, 5-501, 5-503

hook functions

return codes 8-5

initiating a transaction 8-62

no-operation traversal 8-70, 8-72, 8-74, 8-76

processing for transaction commands 8-1

refreshing the screen 8-50

restrictions 8-5

saving database changes 8-52

setting attributes 5-495, 5-506

setting CLEAR command behavior 5-68

setting number of rows in SELECT 5-66

setting number of rows per fetch 5-67

setting the transaction mode 8-4

setting validation bits 5-69

styles

disabling 5-17

enabling 5-18

switching transactions 8-10

transaction events 5-485, 5-487, 8-5, 9-1

transaction requests 9-1

tree traversal 8-4

Transaction manager commands 8-1

specifying the table view 8-4

Transaction mode

changing to initial mode 8-13, 8-45

changing to new mode 8-47

changing to update mode 8-37, 8-57

changing to view mode 8-39, 8-65

setting 8-4

Transaction model

return codes 8-5

Transferring data. See Sending data

Translation table

installing 5-561

Tuxedo

posting event 2-47

subscribing to event 2-82

unsubscribing from event 2-92

U

ULOG file

writing message to 2-36

UNIQUE

dbms command

suppressing repeating values 11-54

Unsolicited message

handling via message handler 2-56

URL

invoking 5-537

V

Validation

clearing MDT bit 5-100

executing check digit function 5-98

forcing

for field 5-196

for group 5-214

for screen 5-436

testing screen for modified data 5-523

widget 5-531

Validation link

generating list of fields 5-517

getting list of fields 5-518

Variable

declaring global in JPL 2-29

declaring in JPL 2-93

Variables

creating JPL global variables 5-539

getting global values 5-221

updating global values 5-233

Video mapping

initializing 5-533

VIEW

transaction manager command

fetching data for view 8-65

View operation

generating argument list

for service call 5-515, 5-516

Viewport

enabling user to change 5-551

W

WALK_DELETE

transaction manager command

traversing tree 8-70

WALK_INSERT

transaction manager command

traversing tree 8-72

WALK_SELECT

transaction manager command

traversing tree 8-74

WALK_UPDATE 8-76

Warning messages

database 12-9, 12-10, 12-18

Web applications

getting

cookie values 5-536

setting

cookies 5-541

writing an error log 5-538

Web resources

invoking 5-537

WHERE clause

changing SQL generation 5-48

While loop 2-98

Widget ID

getting

for base window 5-563

for display 5-564

for drawing area 5-144

for screen-resident widget 5-545

Widgets

aliasing to column names 11-5

attaching drawing function 5-80

copying 5-381

counting number in container 5-289

creating object list 5-293

deleting

at runtime 5-384

destroying object list 5-290

getting runtime propery values 5-407

invoking popup menu 5-404

repositioning at runtime 5-70

setting runtime propery values 5-414

traversing container 5-291

using Java methods 7-9

validation 5-531

Window

changing focus of 5-552

closing 5-103, 5-237

deselecting 5-535

giving focus to 5-554

opening 5-247, 5-548

at cursor location 5-79

printing 5-374

resizing 5-551

setting next sibling 5-453

setting position 5-247

sibling 5-552, 5-554

Window stack

changing focus in 5-552

changing order 5-554

counting windows 5-534

deselecting window 5-535

WITH CONNECTION

dbms command

setting database connection 11-55

WITH CURSOR

dbms command

setting database cursor 11-57

WITH ENGINE

dbms command

setting database engine 11-59

Word wrapped text

getting length 5-556

reading from field 5-558

writing to field 5-559

X

XA transactions

committing 2-104

completing 2-106

rolling back 2-108

starting 2-100

XML

generating 5-565

to file 5-566

importing 5-567

from file 5-568