Application Development


Index

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

Symbols

% (percent sign)
in message file 45-8
%A
display attributes in messages 45-9
%B
bell for messages 45-10
%K
key label in message 45-10
%Md
force user acknowledgment of messages 45-11
%Mu
acknowledgment of error messages 45-12
%N
carriage returns in messages 45-12
%W
popup window for messages 45-12
:+ (colon-plus processing) 30-2
:: (parameters)
in DECLARE CURSOR command 30-11
:= (colon-equal processing) 30-7
@ (at)
to reference database driver variable 37-4
@bi(field) global variable 36-18
@date
defining format for 45-19
in JPL 19-52
@length
in JPL 19-52
@range 39-26
@sum
in JPL 19-53
@tm global variables 36-18
@tm_sel_cursor
default select cursor name 28-8

A

ActiveX controls
event handler in Java 21-6
manipulating at runtime 23-13
Aggregate functions
aliasing to widgets 29-6
in automated SQL generation 33-17
ALIAS
dbms command
aliasing column names 29-4
Aliasing
colors 45-26
column names to widgets 29-4
Alphabetic data
range checking 48-5
Animation 39-8, 39-20
Application
customizing 43-7
debugging 39-19
defining project requirements 3-1
exiting base form 24-3
menu
attaching 15-4
optimizing 41-1
packaging checklist D-2
Windows D-2
specifying splash screen for 43-8
specifying startup file 43-8
Application architecture 1-2
defining 4-1
Application behavior
understanding events 17-1
Application components
building 1-13
integrating 1-20
referencing 19-33
with object modifiers 19-34
Application data 45-45
Application Data option
in debugger 39-9
Application development
accessing the database 27-1, 28-1
defining the project team 1-3
defining the requirements 1-2
development environment 1-6
programming application events 1-16
steps 1-2
with the transaction manager 31-2
Application messages 45-6
header file A-33
Application server
preparing 1-4, 5-1
Array
accessing in JPL 19-40
clearing all data 23-8
in transaction manager 36-10
defining 14-5
deleting occurrence 23-8
elements 14-4
inserting occurrence 23-8
numbering 14-6
scrolling 14-6
setting array size 14-6
sum of occurrences 19-53
ASC keyword
specifying data order 33-21
ASCII
non-ASCII display 45-45
ASCII output
menus A-21
reports A-11
screens A-11
service components A-11
Auto Raise/Close 39-8
Automatic functions
defined 44-2
example 44-65, 44-71
installing
field function 44-19
group function 44-27
screen function 44-13
screen function 17-8

B

Background status
displaying 26-9
Backward scrolling
viewing database rows 29-12
Base form
exiting 24-3
Basic colors
keywords 45-27
Before image processing
modifying data in transaction manager 36-7, 36-27
Bell
setting in messages 45-10
bin2c A-2
bin2hex A-4
Binary columns
writing to database 30-10
Binding
supplying database column values 28-6, 30-11
binherit A-6
Bitwise expression 19-55
Bitwise operators 19-53
Breakpoint
clearing 39-21
listing of 39-5
setting 39-20
in JPL 39-15
on event 39-23
sorting 39-10
specifying location 39-24
Breaks menu
for debugger breakpoints 39-11
Built-in control functions 18-7

C

C functions
calling 20-6
executing from control string 18-5
linking to executable 20-4, 42-4
writing your own 20-1
C Type property 30-4
formatting fetched data 29-16
writing values to database
character strings 30-10
hexadecimal strings 30-10
numeric data 30-7
Calling Java Object Methods 21-19
Calling JPL procedure
as hook function 19-21
from control string 19-22
through call command 19-23
within expression 19-23
Cancel Check Out 10-8
Carriage return
in message
%N 45-12
Case sensitivity
alias names 29-5
column names 7-4, 7-8
connection names 8-3
cursor names 28-5
engine names 7-4, 7-7
specifying for library members A-16
widget names 29-3
CATQUERY
dbms command
writing results to widget or file 29-19
Character data
8-bit 45-45
Character mode
setting line and box style in cmap file 45-34
Character strings
reading from database 29-15
writing to database 30-6, 30-10
Check box widget
event handler in Java 21-7
Check digit function 44-40
return codes 44-40
Check In 10-8
Check Out 10-7
Child property
determining child table view 31-8
Class property 36-14
Client
configuring environment of 6-1
Client authentication
installing data function 44-28
installing post-connection function 44-30
Client executables 42-1
Client library 1-13
Clients
building screens for 13-1
CLOSE CONNECTION
dbms command
closing database connections 8-4
CLOSE CURSOR
dbms command
closing database cursor 28-9
Close Item property 13-2
CLOSE_ALL_CONNECTIONS
dbms command
closing database connections 8-5
Closing
screens 13-7
cmap2bin A-8
Colon preprocessing 19-28, 30-1
colon equal 30-7
colon plus 30-2
examples 30-8
substring specifier 19-30
Color properties
aliasing colors 45-26
display attributes
keywords 45-27
highlighted colors
in Windows 45-27
Panther basic colors
keywords 45-27
Color terminal
display attributes in messages 45-9
Column Click Action property 17-17
Column Click Func 17-17
Column Click Sort 17-17
Column Edits subproperties 11-7
Column Name property 33-3
in automated SQL generation 33-10, 33-33, 33-37
Column Titles property 31-13
COM components
deploying 1-6
Combo box widget
event handler in Java 21-7
Comments
in JPL 19-5
COMMIT
dbms command
committing transactions 28-10
Common library 1-13
Configuration
converting message files to binary A-28
of debugger 39-6
setting up development clients 6-1
Configuration map file
aliasing colors 45-26
colors section 45-26
converting to binary A-8
defining default fonts 45-36
making memory-resident 42-11
object specification keywords 45-32
scheme section 45-30
Connecting
to JetNet via the request broker 9-3
CONNECTION
dbms command
setting database connection 8-4
Constants in JPL 19-32
Continuation character 19-4
Continuation file
scrolling through select set 29-12
specifying
in the transaction manager 36-6
CONTINUE
dbms command
fetching next set of rows 29-11
Control flow
in JPL 19-4
Control function 44-44
example 44-87
return codes 44-45
standard argument 44-44
Control string 18-2
calling JPL 18-5, 19-22
executing function from 18-5
executing OS command from 18-8
getting information in debugger 39-18
target string in 18-6
Conversion utilities
bin2c A-2
bin2hex A-4
cmap2bin A-8
f2asc A-11
jif2asc A-18
jpl2bin A-19
m2asc A-21
msg2bin (message files to binary) A-28
s2asc (styles file to/from ASCII) A-39
Count Select property 36-6
Count Threshold property 36-6
Creating
repository 11-3
service components 12-1
Currency format 45-19
default entries in message file 45-21
fetching from database 29-16
writing to database
colon-plus processing 30-7
Cursor
changing delay state 46-9
position
after check digit function 44-40
after field validation 44-19
after group validation 44-27
displaying 26-7, 26-9
Cursor (database) 28-3
closing 8-4, 28-9
declaring 28-4, 30-11
redeclaring 28-8
using bind values 28-6, 30-11
using colon expansion 28-5
using the default 28-3

D

Data
displaying
displaying in arrays 14-6
modifying
in the transaction manager 36-7
selecting
in the transaction manager 36-3
using a database driver 29-1
with warning message 36-6
writing to a database 30-1
Data Formatting property
formatting fetched data 29-16
using in database updates 30-5
Data Watch option 39-6
sorting variables
in debugger 39-10
Database
accessing 1-3, 1-6, 27-2
designing schema 3-3
importing database to a repository 11-5
reading information from 29-1
transaction processing 28-10
using in Panther 27-1
writing information to 30-1
Database columns
aliasing to widgets 29-4
automatic mapping to widgets 29-3
importing to a repository 11-5
in automated SQL generation 33-3, 33-10, 33-33, 33-37
Database connections
closing 8-3, 8-4
declaring 8-3
setting current 8-4
setting default 8-4
Database drivers
accessing 8-2
initializing 7-2
in Windows 7-7
selecting data 29-1
setting current 8-4
setting default 8-4
writing to a database 30-1
Database engines
adding support for an engine 7-6
initializing 7-2
in Windows 7-7
setting current 7-3
setting default 7-3
viewing error messages 37-4
Database events
trace warning in debugger 39-8
Database information
importing into Panther 1-12
Database properties
for SQL generator 33-4
Database version
identify in executable 42-5
Date
JPL @date operator 19-52
Date/time format
customizing 45-12
defaults 45-13
fetching from database 29-15
for non-English applications 45-17
literal format for @date calculations 45-19
tokens 45-14
writing to database 30-9
colon-plus processing 30-6
DB Interactions window
viewing transaction tree 31-10
dbiinit.c
creating new 7-6
DBUG key (debug) 39-4
DDE
callback function 47-8
cold links
creating for Panther client 47-6
updated from Panther server 47-4
cold paste links
creating for Panther client 47-6
destroying links on Panther client 47-9
disabling Panther as server 47-5
enabling Panther as client 47-5
enabling Panther as server 47-2
executing command from Panther client 47-9
executing command on Panther server 47-10
hot links
creating for Panther client 47-6
specifying in initialization file 47-7
updated from Panther server 47-4
hot paste links
creating for Panther client 47-6
links
created on Panther server 47-2
creating for Panther client 47-6
specifying in initialization file 47-7
updated from Panther server 47-3
paste links
creating for Panther client 47-6
poking data from Panther client 47-10
poking data into Panther server 47-10
requesting link data 47-8
updating Panther client data 47-8
warm links
creating for Panther client 47-6
updated from Panther server 47-4
warm paste links
creating for Panther client 47-6
Debuggable server
in JetNet applications 39-2
Debugger 38-2
accessing 39-3
from Test mode 38-6, 38-7, 38-8
animation 39-8, 39-20
Application Data window 39-27
calling a function 39-9
calling a function on breakpoint 39-26
configuring 39-6
Data Watch window 39-26
enabling in screen editor 39-4
exiting 39-4
expert mode 39-8, 39-23
menu bar 39-8
module browsing 39-12
saving preferences 39-7
View menu 39-4
viewing control string assignments 39-18
viewing JPL 39-11
Decimal symbol
setting default 45-23
DECLARE CONNECTION
dbms command
making database connection 8-3
DECLARE CURSOR
dbms command
creating database cursor 28-5, 30-11
using bind values 28-6, 30-11
using colon expansion 28-5
Delay cursor 46-9
Delete Order property
in automated SQL generation 33-38
Delete Service property 33-5
DELETE statement
SQL generation from properties 33-38
Demand functions
example 44-69
installing
field function 44-20
group function 44-27
screen function 44-13
Deployment
directory structure D-1
DESC keyword
specifying data order 33-21
Destroying Java Objects 21-19
Dialog property 13-2
Display area
size for portability 48-2
Display attributes
keywords 45-27
portability 48-2
setting
in messages 45-8
in status line 45-9
Distinct property 33-13
Distribution
directories defined 2-1
Duplicate rows
eliminating 33-13
Dynamic label widget
event handler in Java 21-8

E

Edit menu
in debugger 39-10
Editor
invoking from JPL dialog box 19-17
using 1-15
Elements
numbering 14-6
Email 49-1
creating mail object 49-4
properties 49-1
sending 49-5
attachments 49-6
ENGINE
dbms command
setting database engine 7-3
Enterprise JavaBeans
service components for 12-5
Entry Function property
screen 17-8
Environment setup
development clients 6-1
Error function 44-37
example 44-81
return codes 44-38
standard arguments 44-38
Error handling 26-1
installing database error handler 37-9
Error hook function 26-9
Error messages
acknowledgment 45-11
disabling display of 26-2
Error messages (database) 37-1, 37-2
customized processing 37-6
default processing 37-2
engine-specific messages 37-4
error handler 37-7
exit handler 37-7
generic database driver messages 37-4
installing error handler 37-6, 37-9
transaction error handling 28-12
transaction hook functions 32-4
warning codes 37-4
Event function arguments
client authentication connection 44-28
client authentication post-connection 44-30
control 44-44
error 44-38
field 44-15
grid 44-21
group 44-26
initialization 44-42
key change 44-37
playback 44-43
record 44-43
reset 44-42
screen 44-11
tab control 44-24
timeout 44-33
timer 44-35
transaction manager 44-50
video processing 44-47
Event function return codes
transaction manager 32-3
Event function types
transaction manager 32-1
Event functions
in the transaction manager 31-15
programming for 1-16
transaction manager 32-1
Event handlers
in Java 21-4
Event stack
for transaction manager 35-7
in debugger 39-6
Events
in Panther applications 17-1
setting breakpoints on 39-21
user-initiated 17-22
Executables
building 42-1
including your C functions 20-1
renaming 42-6
EXECUTE
dbms command
executing statement 28-5
Exit
debugger 39-4
Exiting Panther 38-8
Expert mode 39-8, 39-19
Extended colors
aliasing colors 45-26
External menu 15-6

F

f2asc
generating ASCII output A-11
Fetch data properties 33-10
Fetch Directions property 36-6
Field
characteristics
internationalization 48-3
decimal symbol 45-23
displaying status of 26-8
getting current field number 14-3
getting screen's amount of 13-8
Field data
clearing all fields 23-8
clearing from array 23-8
getting length 19-52, 23-6
reading 23-5
testing
all fields for changes 23-15
for no value 23-6
for yes value 23-6
if null 23-6
writing 23-7
Field function 44-14
example of automatic function 44-65
example of demand function 44-69
passing non-standard arguments into 44-67
standard arguments 44-15
Field number
assignment 14-4
Field validation 23-14
causes 44-15
File
required in deployment 43-4
File locking A-16
Font
setting display default 45-36
Force Valid property 33-12
Foreign keys
enforcing with validation link 33-48
Form
opening 13-3
Form stack 24-2
FORMAT
dbms command
formatting result set 29-19
Formatting text
for a database 30-12
from a database 29-15
formlib
with -g option 10-5
Function keys
associating with control string 18-2
setting default behavior 18-2

G

Global JPL variable
declaring 19-26
Grid Column Click 17-17
Grid function 44-20
return codes 44-23
standard arguments 44-21
Grid widgets
event handler in Java 21-8
Group
converting to field number 14-9
getting information in debugger 39-17
getting name from field reference 14-9
getting screen's amount of 13-8
identifying members of 23-3
validation 44-26
GROUP BY clause
in automated SQL generation 33-17
Group By property 33-17
Group function 44-25
example of automatic function 44-71
return codes 44-27
standard arguments 44-26
Group widgets
event handler in Java 21-9

H

HAVING clause
in automated SQL generation 33-20
Having property
in automated SQL generation 33-20
Header file
creating A-33
sample A-34
Help function 44-32
example 44-73
return codes 44-32
Hexadecimal strings
writing to database 30-7, 30-10
Hidden property
and version columns 33-42
Hook functions
invoking 19-21

I

Icon
for application 42-8
Import
of database objects to a repository 11-5
In Delete Where property 33-41
in automated SQL generation 33-41
IN keyword
in automated SQL generation 33-16
In Update Where property 33-41
in automated SQL generation 33-41
Included JPL modules 19-5
Infinite loops
breaking out in debugger 39-4
Inherit From property
removing specification 11-10
Inherit menu option 11-10
Inheritance 1-14, 11-9
ensuring 11-2
preventing propagation 11-9
propagating to screen (binherit) A-6
source
finding 11-10
Initialization
database engines 7-2
Initialization function 44-41
example 44-82
return codes 44-42
standard argument 44-42
Insert Service property 33-5
INSERT statement
SQL generation from properties 33-32, 33-44
Insert toggle function 44-39
example 44-81
return codes 44-39
Installed function return codes
check digit 44-40
client authentication connection 44-28
control 44-45
error 44-38
grid 44-23
group 44-27
help 44-32
initialization 44-42
insert toggle 44-39
key change 44-37
playback 44-43
record 44-43
reset 44-42
screen 44-12
status line 44-46
timeout 44-33
timer 44-35
transaction manager 44-50
video processing 44-49
Installed function types
check digit 44-40
client authentication connection 44-28
client authentication post-connection 44-30
control 44-44
database driver errors 44-49
error 44-37
field 44-14
grid 44-20
group 44-25
help 44-32
initialization 44-41
insert toggle 44-39
key change 44-36
playback 44-43
prototyped 44-8
record 44-43
reset 44-41
screen 44-10
status line 44-45
tab control 44-24
timeout 44-33
timer 44-34
transaction manager 44-50
video processing 44-47
Installed functions
automatic 44-2
installing 44-4
standard arguments 44-3
Instantiating Java Objects 21-17
Interface
three-tier
between client and server 1-7
Internationalization
8-bit characters 45-45
alternate message files 45-24
currency formats 45-19
decimal symbol 45-23
keystroke filters 48-3
library functions 45-45
of application screens 45-46
range checks 48-4
yes/no values 45-24
Interrupt handler 44-41

J

Java
event handler interfaces 21-4
implementing event handlers 21-1
sample 21-23
samples C-1
setting environment variables 21-2
Java Tag property 21-3
JetNet
connecting to
via the request broker 9-3
creating service components 12-1
using with transaction manager 35-12
JIF
defining service availability 1-8
jif2asc A-18
jmain.c 42-6
Join 33-23
implementing
full outer join 33-30
inner join 33-29
left outer join 33-30
right outer join 33-31
Join Type property 33-28
JPL
choosing an editor 19-17
comments 19-5
constants 19-32
control flow 19-4
memory-resident 42-9
null statement 19-5
optimizing performance 19-56
setting breakpoint in 39-15
validation 19-8
viewing with debugger 39-11, 39-26
JPL calls
from control string 18-5, 19-22
from screen 19-21
from screen and report 19-14
from widget 19-21
inline calls 19-23
return value 19-20
search order 19-24
JPL commands
arguments 19-56
JPL expression
bitwise 19-55
numeric 19-54
numeric format 19-54
operand conversion 19-50
specifying substring in variable 19-51
string 19-54
JPL module 19-1
accessing with debugger 39-11, 39-12
compiling A-19
continuation character 19-4
include module 19-5
library modules 19-11, 19-16
line length 19-4
loading as public 17-6
memory-resident 19-13
named procedure 19-2
screen module 19-9
storing in library 19-11
types 19-8
unnamed procedure 19-2
widget validation 19-8
JPL operators 19-48
@date 19-52
@length 19-52
@sum 19-53
bitwise 19-53
concatenation 19-51
precedence 19-49
substring specifier 19-51
JPL procedure 19-1
attaching to screen and report 19-14
attaching to widget 19-16
declaring parameters 19-2
declaring return type 19-4
execution 19-4
named 19-2
returning from 19-20
unnamed 19-2
JPL text dialog box
compiling and saving 19-18
invoking local editor 19-17
JPL variable 19-24
declaring 19-25
global 19-26
expanding to literal value 19-28
resolving name ambiguity 19-38
scope and lifetime 19-27
substring specifier 19-51
watching through debugger 39-9, 39-26
jpl2bin A-19
Jterm
enabling data compression 42-12

K

K_ENTRY flag
set on field entry 44-16
set on grid entry 44-21
set on screen entry 44-11
set on tab card entry 44-25
K_EXIT flag
set on field exit 44-17
set on grid exit 44-21
set on screen exit 44-11
set on tab card exit 44-25
K_EXPOSE flag
set on screen exposure 44-11
K_KEYS bitmask 44-12, 44-17, 44-22
Key change function 44-36
example 44-79
return codes 44-37
standard argument 44-37
Key label
displaying in messages 45-10
portability 48-3
Key translation
internationalization 45-46
portability 48-3
Key translation file
making memory-resident 42-11
Keyboard
portability 48-3
Keystroke Filter property
translation support 48-3
using in database updates 30-5
using to format database values 30-9, 30-10

L

LDB 25-7
loading
multiple instances of 25-9
popping 25-11
Length property
defined in database 11-7
Library
lock on 10-9
making read-only A-17
set file locking scheme A-16
source control management 10-4
storing JPL modules 19-12
synchronize with source code management A-17
Library JPL module 19-16
Line length of JPL statement 19-4
Line styles
names of 45-34
setting in cmap file 45-34
Link widget
relationship properties 33-23
Links 31-7
in automated SQL generation 33-22
setting child table view 31-8
setting parent table view 31-8
setting the link type 31-9
validation 31-13, 33-46, 33-47
adding lookup 33-49
enforcing foreign keys 33-48
List box widget
event handler in Java 21-9
Local decimal symbol 45-23
Lock
on library/repository 10-9
Lock files A-16
Log file
debugger 39-6
writing to 39-10
Logical key
invoking control string from 18-2
Lookup specification 33-49
in Relations dialog box 33-49

M

m2asc A-21
Mail 49-1
creating mail object 49-4
properties 49-1
sending 49-5
attachments 49-6
makefile
list 42-3
makevars 42-4, 42-5
MDI frame
in Windows applications 13-6
with dockable toolbars 15-10
MDT bit 23-14
clearing for all fields 23-15
testing to find first modified field 23-15
Memory-resident
JPL modules 19-13, 42-9
screens 42-9
Menu
ASCII/binary conversion A-21
definition 15-1
deleting at runtime 15-11
deleting items at runtime 15-12
displaying as toolbar 15-1, 15-7
external reference 15-6
installing 15-3
for application 15-4
for screen 15-4
for widget 15-4
unique instances of 15-6
loading script into memory 15-2
popup for field
invoking 15-13
properties of
changing ar runtime 15-9
removing from display 15-12
scope assignment and display 15-4
testing 38-8
Menu bar
in application mode 38-2
Menu item
displaying status of 26-8
Menu Name property 15-4
Menu script
loading into memory 15-2
unloading from memory 15-12
Menu Script File property 15-2
Message
acknowledgment 26-2, 45-12
forcing 45-11
bell 45-10
creating 45-5
default display
in status line 26-1
in window 26-1
disabling display of 26-2
display attributes in 45-8, 45-9
hexadecimal codes for 45-9
displaying
background status 26-9
in window 45-12
on status line 26-7
error 26-1
forcing to status line
automatic dismissal 45-11
functions for displaying 26-4
key labels in 45-10
multiple lines in 45-12
Panther-specific 45-4
send via request broker 9-2
Message file 45-2
converting to binary (msg2bin) A-28
making memory-resident 42-11
modifying 45-2
multiple sections 45-6
size 45-6
syntax 45-4
text 45-5
translating 45-2
using alternate 45-24
Method property 36-7, 36-12
Middleware
connecting to 1-7, 9-1
Module type
specifying in debugger 39-14
Monochrome terminal 45-9
Motif
deploying application D-4
Motif resource file
specifying 43-8
splash screen 43-8
Mouse events
getting name of last clicked-on field 46-5
getting name of last clicked-on screen 46-6
getting state of buttons 46-6
msg2bin
errors A-29
msg2hdr A-33
errors A-34
sample output A-34
MSSCCI Support 10-1
MTS
creating service components 12-8
Multi-item properties
Multi-item properties
accessing in JPL 19-42
Multiple sections
in message file 45-6
Multi-user access 10-3

N

NCARD key (next card) 23-12
Null edit
colon-equal processing 30-7
writing null value to database 30-3, 30-9
Null Field property
in automated SQL generation 33-17
writing null values to database 30-3, 30-9
Null statement in JPL 19-5
Null value
writing to database 30-3, 30-9
Numbering
in arrays 14-6
Numeric data
range checking 48-4
reading from database 29-16
writing to database 30-7
Numeric expression
JPL 19-54
Numeric format
JPL 19-54

O

Object ID
for widgets 14-3
OCCUR
dbms command
setting occurrence for SELECT 29-14
Occurrence
deleting 23-8
inserting 23-8
numbering 14-6
setting the number of 14-6
ONENTRY
dbms command
calling function before dbms command 37-7
ONERROR
dbms command
installing error handler 37-7
ONEXIT
dbms command
calling function after dbms command 37-7
Opening
screens 13-3
Operands
conversion in JPL 19-50
Operating system
accessing from control string 18-8
Operator property 33-15
in automated SQL generation 33-15
Operators
JPL operators 19-48
supported in WHERE clause 33-14
Optimistic locking
property settings 33-39
Option menu widget
event handler in Java 21-10
ORDER BY clause
in automated SQL generation 33-21
Output processing
messages 26-7

P

Panther
description 1-1
description of directories 2-1
Panther basic colors
keywords 45-27
Panther executables
building 42-1
including your C functions 20-1
modifying 42-6
Panther type
character strings
fetching from database 29-15
writing to database 30-6, 30-8
converting to C type 30-4
currency formats
writing to database 30-5, 30-7
date and time formats
fetching from database 29-15
writing to database 30-5, 30-6, 30-9
hexadecimal strings
writing to database 30-7
numeric data
fetching from database 29-16
writing to database 30-7, 30-10
using to format selected data 29-15
Parameters
declaring in JPL 19-2
for binding
in DECLARE CURSOR command 28-6, 30-11
Parent object
turning inheritance on/off for specific properties 11-9
Parent property
determining parent table view 31-8
Partial command 34-6
PCARD key (previous card) 23-12
Pending keys 39-6
Percent escapes
in message file 45-8
Playback function 44-43
example 44-84
return codes 44-43
standard argument 44-43
Popup menu
invoking 15-13
Popup Menu property
screens 15-4
widgets 15-4
Portability 48-1
aliasing colors 45-26
smmach.h 48-1
Precision
in SELECT results 29-16
Preferences
saving in debugger 39-7, 39-9
setting in debugger 39-6
Primary Key property
in automated SQL generation 33-38
Primary keys
updating
with transaction manager 36-9
Programming
modifying property values 1-16
sharing data 1-21
using application events 1-16
Project
defining requirements 3-1
Project requirements 1-2
defining the project team 1-3
Properties
accessing in JPL 19-40
application properties 19-41
multi-item properties 19-42
runtime properties 19-41
substring of setting 19-42
for dockable toolbars 15-10
for screens
runtime only 13-8
getting at runtime
for menus 15-9
multi-item properties 19-42
setting at runtime
for menus 15-9
transaction manager 36-19, 36-26
traversal 36-19
value types 19-43
Prototyped function 44-8
examples 44-52
get standard arguments 44-8
valid prototypes 44-10
Public module
loading 17-6
Push button widget
event handler in Java 21-11
PVCS support 10-1

R

Radio button widget
event handler in Java 21-11
Range
checking 48-4
Read-only library A-17
Read-only screen
saving 10-10
Ready/Wait status
displaying 26-8
Receive data
reading bundle data 25-4
Record function 44-43
example 44-84
return codes 44-43
standard argument 44-43
Regenerate SQL property 36-12
Relations property 33-23, 36-5
in automated SQL generation 33-27
Report
JPL 19-14
Reports
ASCII/binary conversion A-11
overview 16-1
overview of 1-19
Repository
benefits 11-1
copying objects
for transaction manager 31-3
for application development 1-13
from a database
build with 1-11
importing database objects 11-5
lock on 10-9
making read-only A-17
screen wizard entries 11-8
set file locking scheme A-16
storing screen templates 11-5
synchronize with source code management A-17
under source control management 10-4
Request broker 9-1
Request broker event handlers
defined 17-26
Request events
in transaction manager 35-3
Reservation
releasing 10-4
Reset function 44-41
example 44-82
return codes 44-42
standard argument 44-42
Return codes
transaction event functions 32-3
Return value 19-20
declaring type in JPL 19-4
Revision control 10-9
ROLLBACK
dbms command
engine-specific behavior
rolling back transactions 28-10, 28-12
Root table view
in the transaction manager 31-8
Row Titles property 31-13
Rows
determining number fetched 29-8
retrieving multiple rows 29-8
scrolling through result set 29-12
setting maximum number 36-6
Runtime properties
accessing in JPL 19-40

S

s2asc A-39
Sample applications
Java 21-23
Samples
two-tier application
VideoBiz B-1
using Java in Panther C-1
SAVE
transaction manager command
saving database changes 32-9
Scale property
defined in database 11-7
Scale widget
event handler in Java 21-12
SCCS support 10-1
Scheme
defining in configuration map file 45-30
object names for color mapping 45-32
Screen
about 13-1
as a dialog box 13-2
ASCII/binary conversion A-11
C data structure conversion A-2
calls to JPL from 19-21
closing 13-7, 38-8
control string 18-2
creating
screen templates 11-5
deleting under source control 10-11
display defaults 13-4
overriding 13-5
entry processing 17-4
event handler in Java 21-5
events 17-2
entry 17-4
exit 17-19
exposure 17-6
functions 44-10
hexadecimal conversion A-4
identifying members of 23-3
JPL 19-14
JPL module 19-9
memory-resident 42-9
menu
attaching 15-4
naming start up 42-7
opening 13-3
as a form 13-3, 24-2
as a sibling window 24-4
as a window 13-3, 24-3
at specific size/dimension 13-5
from control string 18-3
popup menu
attaching 15-4
read-only 10-9
saving 10-10
reserving 10-3
setting properties 13-8
status line text 26-8
testing 38-4
viewing in debugger 39-16
viewport 13-4
Screen editor
accessing from within Panther 38-2
exiting 38-8
Screen entry 17-4
executing screen's unnamed procedure 17-6
Screen events 17-2
Screen exit 17-19
Screen function
return codes 44-12
standard arguments 44-11
Screen functions 44-10
Screen module 19-9
viewing in debugger 39-16
Screen properties 13-7
number of fields 13-8
number of groups 13-8
runtime only 13-8
Screen wizard
description 1-15
Screens
creating 1-15
Scrolling
specifying backward scrolling 29-12
Select Service property 33-5
SELECT statement
aliasing columns to widgets 29-4
automatic mapping of column names 29-3
changing generated SQL 36-6
concatenating result row 29-19
destination of 29-3, 29-19
aggregate functions 29-6
formatting result set 29-15
generating SQL 36-3
scrolling through result set 29-8
specifying multiple tables
in automated SQL generation 33-22
SQL generation from properties 33-7, 33-44
suppressing repeating values 29-17
transaction manager
writing hook function 32-6
unique column values 29-17
writing results
to a file 29-19
to a specific occurrence 29-8, 29-14
to word-wrapped arrays 29-8
Selection group
deselecting 23-11
getting selection data 23-9
identifying members of 14-8
selecting 23-11
testing for selection 23-9
Self-joins
in automated SQL generation 33-24
in the transaction manager 31-8
Send data 25-1
reading bundle data 25-4
writing data to bundle 25-2
Sequential link
in data fetches 36-5
setting the link type 31-9
Sequential link type
in automated SQL generation 33-26
join specification 33-23
Server executables 42-1
Server library 1-13
Server link
setting the link type 31-9
Server link type
join relationship 33-23
Server views
traversal properties 36-21
Service
debugging 39-2
Service components
ASCII/binary conversion A-11
building 1-7
creating 12-1
for EJBs 12-5
in JetNet 12-1
in MTS 12-8
in TUXEDO 12-1
Service container
debugging 39-2
Service properties
link widgets 33-47
table view 33-5
Service request
finding the transaction manager operation 36-26
via request broker 9-2
SET clause
in automated SQL generation 33-37
Set Valid property 33-12
Sibling property 24-4
Sibling window
setting for next window 24-4
Single line text widget
event handler in Java 21-13
Slice events
in transaction manager 35-3
SM_CALC_DATE
setting default format 45-19
SM_DECIMAL
setting default 45-23
smmach.h 48-1
SMMSGS
setting alternate value 45-18, 45-24
Sort Order 17-17
Sort Order Func 17-17
Sort Widgets property
in automated SQL generation 33-21
Source code
main routines
modifying 42-6
platform-dependent 48-1
Source Code menu option
in debugger 39-4
Source control management
accessing screen outside of 10-3
deleting screens under 10-11
features of 10-7
in the editor 10-7, 10-8
setting up 10-5
synchronizing library A-17
Splash screen 43-8
SQL
automated 33-1
setting properties for 33-4
constructing SQL statements 28-1
declaring cursors for 28-4
modifying automated SQL 32-1, 33-31
sending to database 27-2
viewing generated SQL 36-2
viewing generated statements 33-43
SQL generation 33-1
modifying automated SQL 33-31
Standard arguments 44-3
client authentication connection function 44-28
client authentication post-connection function 44-30
control function 44-44
error function 44-38
field function 44-15
grid function 44-21
group function 44-26
initialization function 44-42
key change function 44-37
passing into unnamed procedure 19-3
playback function 44-43
prototyped function
getting for 44-8
record function 44-43
reset function 44-42
screen function 44-11
tab control function 44-24
timeout function 44-33
timer function 44-35
types 19-21
video processing function 44-47
START
dbms command
setting starting row 29-14
Startup file 43-8
Startup screen 42-7
Status
determining in debugger 39-4
Status line
default message
overriding 26-8
message functions 26-4
message priority 26-7
message types 26-7
terminal portability 48-2
text
background 26-9
for screen 26-8
for widget 26-8
Status line function 44-45
example 44-96
return codes 44-46
STORE
dbms command
setting continuation file 29-12
String
getting length 19-52
String expression
JPL 19-54
Substring specifier 19-51
colon variables 19-30
Support routine
Database drivers 7-1
database engines 7-4
Synchronization property 36-9
System decimal
defining symbol 45-23
interpreting 45-45

T

Tab Card widget
event handler in Java 21-12
Tab control function 44-24
standard arguments 44-24
Tab controls
about 23-12
getting the number of cards 23-12
setting the card sequence 23-12
setting the topmost card 23-12
Table property
table view
in automated SQL generation 33-14
Table views 31-7
adding a virtual column 31-11
adding members to 31-11
identifying as root 31-8
limiting through commands 34-5
properties for SQL generation 33-2, 33-4, 33-14
setting child table view 31-8
setting parent table view 31-8
traversal properties 36-21
viewing properties 31-8
Tables
in automated SQL generation 33-2, 33-14, 33-36
joining multiple 33-22
storing in repository 11-5
Target string 18-6
Terminal
bell
in message 45-10
portability 48-2
status line 26-7
Test mode 38-4
exiting 38-8
menu bar 38-1
vs. application mode 38-5
Testing
overview of 1-24
Text
entry widgets
event handler in Java 21-13
formatting for a database 30-1
Text editor
invoking for JPL procedures 19-14
Three-tier applications 4-1
Three-tier architecture 1-3, 27-5
Timeout
server configuration 39-3
Timeout function 44-33
example 44-78
return codes 44-33
standard arguments 44-33
Timer function 44-34
return codes 44-35
standard arguments 44-35
Toggle button widget
event handler in Java 21-13
Toolbar 15-7
displaying 15-1
setting runtime properties 15-10
Top Screen option 38-2
Trace menu
in debugger 39-11
Transaction
error handling 28-12
processing database transactions 28-10
Transaction classes
defaults
widgets 36-15
Transaction events
adding to the stack 35-10
after an error 36-29
controlling the event stack 35-9
unsupported 32-6
Transaction manager
and debugger 39-8
before image processing 36-7
changing the transaction mode 31-14
closing a screen 36-2
commands 34-2
copying from repository 31-3
determining sequence 31-4
creating screens for 31-1
deleting data 36-10
development process for 31-2
disabling 36-3
error processing
controlling display 36-30
event functions 32-1
checking for database errors 32-4
DELETE statement 32-9
INSERT statement 32-9
SELECT statement 32-6
specifying return codes 32-3
UPDATE statement 32-9
event stack 35-7
fetching data 36-3
for update 36-8
with a maximum row count 36-6
generating SQL 1-17, 27-2
hook functions
return codes 44-50
standard arguments 44-50
in JetNet applications 35-12
initiating a transaction 17-7
intstalled event functions 44-50
opening a screen 36-2
processing at runtime 36-1
processing events 35-1
restrictions 34-2
specifying commands 31-13, 34-4
SQL generation 33-3
tree traversal 31-10
using in Panther 27-2
verifying changes 36-11
viewing generated SQL 36-2
writing event functions 31-15
Transaction manager commands 34-2
availability by mode 34-7
processing for 35-3
specifying full commands 34-6
specifying partial commands 34-6
Transaction mode 36-12
availability of commands 34-7
Transaction model 35-5
for JetNet 35-13
initializing 7-2
return codes 32-3
specifying in Windows 7-8
Transaction styles
ASCII A-39
converting to/from ASCII A-39
defaults 36-14
report
s2asc A-39
Translating 45-45
message file 45-2
substitution variables 45-16, 45-21
Traversal properties
for link widgets 36-25
for table views 36-22
for widgets 36-25
TUXEDO
creating service components 12-1
Two-tier applications 4-3
Two-tier architecture 1-2, 27-4
Type-Specifiers and Arguments 21-18

U

UNIQUE
dbms command
suppressing repeating values
suppressing repeating values 29-17
UNIX
deploying application D-4
Unnamed procedure 19-2
executing in screen JPL 17-6
getting standard arguments 19-3
Updatable property
in automated SQL generation 33-32, 33-36, 33-38
Update Order property
in automated SQL generation 33-36
Update Service property 33-5
UPDATE statement
SQL generation from properties 33-36, 33-45
Use If Null property 33-15
in automated SQL generation 33-17
Use in Insert property 33-33
expression 33-34
in automated SQL generation 33-33
Use in Select property 33-10
Use in Update property
expression 33-37
in automated SQL generation 33-37
Use in Where property 33-14
in automated SQL generation 33-14
operator specification 33-15
Utilities
bin2c A-2
bin2hex A-4
binherit A-6
cmap2bin A-8
f2asc A-11
jpl2bin A-19
m2asc A-21
msg2bin A-28

V

Validation 23-14
clearing MDT bit 23-15
field 44-15
field function invocation 44-15
MDT bit 23-14
screen 44-15
setting mdt property 17-6
setting valided property 17-6, 23-14
testing screen for modified data 23-15
validation bit 23-14
XMIT key 44-15
Validation bit 23-14
Validation Link property 33-46, 33-47
setting on a widget 31-13
valided property
setting 23-14
Variables
monitoring through debugger 39-6
watching through debugger 39-26
Version Column property 33-41
in automated SQL generation 33-42
Video file
making memory-resident 42-11
Video mapping
internationalization 45-46
Video processing function 44-47
return codes 44-49
standard argument 44-47
View menu
in debugger 39-4
Viewport 13-4
Virtual column 31-11

W

Web application architecture 1-22
WHERE clause
in automated SQL generation 33-14, 33-38, 33-41
Widget events 17-2
Widget name
case sensitivity 29-3
getting 14-3
Widget runtime properties
getting 23-6
Widgets
attaching JPL procedure to
attaching JPL procedure 19-16
calls to JPL from 19-21
copying from repository
for transaction manager 31-3
identifying 14-3
including in SQL generation 31-11
JPL validation 19-8
mapping to database columns 29-3
menu
attaching 15-4
properties for SQL generation 33-3
storing templates in repository 11-7
validation 23-14
Window
changing focus among siblings 24-5
deselecting 24-4
displaying messages in 45-12
giving focus to 24-4
opening 13-3
as sibling 24-4
setting next as sibling 24-4
Window stack 24-3
changing order 24-4
Windows
deploying application D-2
using MDI frame 13-6
Windows initialization file
specifying 43-8
splash screen 43-8
WITH CONNECTION
dbms command
setting database connection 8-4
WITH ENGINE
dbms command
setting database engine 7-3
Word wrapped text
fetching column values 29-8

X

XMIT key (transmit)
and push buttons 18-7
screen validation 44-15
XML 22-1
generating 22-3
importing 22-4
properties 22-1

Y

Yes/No
setting default values 45-24
translating 45-45