Index
A
-A command line flag 558
abs() function 58, 569
acos() function 569
Add command 49, 605
Adobe PDF files 129
After (On-Break option qualifier) 142
After qualifier 142
aggregate function 18
Alter-Color-Map 641
Alter-Connection 614
Alter-Locale command 359, 647
Alter-Printer command 201, 253, 624
Alter-Report 9, 125, 620
Always (On-Break option qualifier) 138
ANSI SQL 12
API Aware process 450, 451
Application Run Control record 383
Application server 402
argument file 281
arithmetic commands 49
array() function 582
Array-Add command 182, 644
Array-Divide command 182, 644
Array-Multiply command 183, 644
arrays 176
Array-Subtract command 183, 644
ascii() function 582
asin() function 569
Ask command 67, 68, 278, 281, 618
asynchronous mode 286
atan() function 569
AVG (SQL function) 19
B
batch mode 284
Batch-Mode (Input command argument) 281
Before (On-Break option qualifier) 142
Before-Toc operand 318
Begin-Document command 220, 592
Begin-Execute 57, 615
Begin-Footing command 588
Begin-Heading 125
command 588
Begin-Procedure command 74, 77, 589
Begin-Program command 33, 587
Begin-Select command 80, 590
Begin-Setup command 589
Begin-SQL command 96, 591
binary search 192
Bold qualifier 115
Boolean operator 17
BQD 9
Break command 136, 607, 608
break handling commands 136
Brio Direct Data Objects 6
Brio Insight 4
Brio Query Data 9
Brio Report Activator 4
Brio Report Builder 5
Brio Report Viewer 4
bubble sort 188
built-in function 58, 120, 365, 568
-BURST 320
-BURST command line flag 558
bursting 319
C
-C command line flag 353
Call command 645
Call System command 284, 288, 363, 645
Call System Using command 286
calling SQR from other programs 293
Cartesian product 23
ceil() function 570
Center (Print command argument) 115
CGI script 343
Change (On-Break option qualifier) 138
Change/Top-Page (On-Break option qualifier) 138
chr() function 582
Clear-Array command 181, 643
Close command 259, 597
closing a file 259
Columns command 124, 629
comands
Alter-Connection 614
command line flags
-A 558
-BURST 558
-C 353
-DEBUG 350, 559
-E 354
-EH_APPLETS 560
-EH_BQD 560
-EH_BROWSER 560
-EH_CSV 560, 561
-EH_CSVONLY 561
-EH_FULLHTML 561
-EH_ICONS 561
-EH_IMAGES 561
-EH_KEEP 561
-EH_LANGUAGE 561
-EH_PDF 130, 562
-EH_SCALE 562
-EH_XML 562
-EH_ZIP 562
-F 280
-I 280
-KEEP 212, 279, 563
-LOCK 563
-LOOPS 530, 590
-NOLIS 212, 214, 563
-O 280
-PRINTER 217, 564
-RS 283, 564
-RT 283
-S 353
-Tnn 353
-XCB 565
-XI 566
-XLFF 566
-XNAV 566
-XTOC 566
-ZIF 278, 280, 566
-ZIV 212, 215, 566
-ZRF 567
commands
Add 49, 605
Alter-Color-Map 641
Alter-Locale 359, 647
Alter-Printer 201, 253, 624
Alter-Report 125
Array-Add 182, 644
Array-Divide 182, 644
Array-Multiply 183, 644
Array-Subtract 183, 644
Ask 67, 68, 278, 281, 618
Begin-Document 220, 592
Begin-Execute 57
Begin-Footing 588
Begin-Heading 125, 588
Begin-Procedure 74, 77, 589
Begin-Program 33, 587
Begin-Select 80, 590
Begin-Setup 589
Begin-SQL 96, 591
Break 261, 607, 608
Call 645
Call System 284, 288, 363, 645
Call System Using 286
Clear-Array 181, 643
Close 259, 597
Columns 124, 629
Commit 609
Concat 53
Connect 609
Create-Array 177, 179, 186, 240, 642
Create-Color-Palette 628
Date-Time 598
Declare-Chart 239, 241, 626
Declare-Color-Map 640
Declare-Connection 613
Declare-Image 248, 628
Declare-Layout 199, 269, 625
Declare-Printer 199, 623
Declare-Procedure 622
Declare-Report 198, 619
Declare-Toc 314, 318, 639
Declare-Variable 599
Display 349, 646
Divide 49, 605
Do 74, 606
Else 106, 606
Encode 52, 603
End-Document 220, 592
End-Evaluate 607
End-Footing 588
End-Heading 588
End-If 106, 606
End-Procedure 74, 589
End-Program 33, 587
End-Select 80, 590
End-Setup 589
End-SQL 96, 591
End-While 108, 608
Evaluate 106, 224, 607
command line flags (continued)
Execute 283, 612
Exists 539
Exit-Select 610
Extract 52, 602
Find 602
Get 181, 187, 643
Get-Color 641
Goto 609
Graphic 251, 632
Graphic Box 253
Graphic Horz-Line 253
Graphic Vert-Line 253
If 105, 606
Input 164, 278, 281, 617
Last-Page 631
Let 54, 179, 181, 182, 187, 601
Load-Lookup 89, 611
Lookup 90, 612
Lowercase 51, 603
Mbtosbs 604
Move 49, 50, 600
Multiply 49, 605
New Column 124
New-Page 153, 156, 265, 269, 630
New-Report 621
Next-Column 124, 629
Next-Listing 122, 631
No-Formfeed 635
Open 257, 595
Page-Number 630
Page-Size 632
Position 121, 225, 632
Print 112, 116, 142, 216, 265, 269, 633
Print-Bar-Code 249, 250, 637
Print-Chart 238, 239, 241, 635
Print-Direct 638
Printer-DeInit 639
Printer-Init 639
Print-Image 248, 638
Put 179, 240, 644
Read 259, 596
Rollback 610
Sbtombs 605
Set-Color 642
Set-Delay-Print 126
Show 349, 646
Stop 100, 371, 649
Subtract 49, 605
Toc-Entry 318, 640
Unstring 53, 604
Uppercase 51, 603
Use 612
Use-Column 124, 125, 630
Use-Printer-Type 201, 625
Use-Procedure 623
Use-Report 201, 621
While 108, 608
Write 263, 265, 597
Commit command 609
compiler directives 592?595
compile-time variables 162
Component 415
Concat command 53
cond() function 583
Connect command 609
cos() function 569
cosh() function 570
COUNT (SQL function) 19
Create-Array command 177, 179, 186, 240, 642
Create-Color-Palette 628
CSV file 268, 314
CSV output 268
current data row 524
#current-column predefined variable 44
$current-date predefined variable 45
#current-line predefined variable 44
D
Data Manipulation Language. See DML
database-independent 365
database-specific functions 364
date format masks 118
date functions 59, 574?575
date intervals 541
Date keyword 121
date literals 43
date variables 42, 43, 47
dateadd() function 61, 574
datediff() function 60, 574
datenow() function 59, 575
Date-Time command 598
datetostr() function 60, 365, 575
DDL 99
DDO 6
DDO Kernel 4
#Debug compiler directive 350, 593
-DEBUG command line flag 350, 559
debugging techniques 348
decimal number 43
Declare-Chart command 239, 241, 626
Declare-Color-Map 640
Declare-Connection 613
Declare-Image command 248, 628
Declare-Layout command 199, 269, 625
Declare-Printer command 199, 623
Declare-Procedure command 622
Declare-Report command 198, 619
Declare-Toc 315, 318
Declare-Toc command 314, 639
Declare-Variable command 599
default locale 359
default value 26
#Define compiler directive 164, 595
deg() function 570
Delay (Print command argument) 9
DELETE (SQL operator) 25, 26
delete() function 58, 286, 573
demand paging 320
Destination page 440
detecting end of file 260
Display command 349, 646
Divide command 49, 605
DML 25, 98, 99
Do command 74, 606
document marker 43, 224
Document paragraph 220, 221
dynamic query variables 166, 169
E
-E command line flag 354
e10() function 571
Edit argument 116
edit() function 62, 576
effective date 524
Effective Sequence 525
effective-dated records 524
effective-dated rows 524
effective-dated table 524
-EH_APPLETS 560
-EH_BQD 560
-EH_BROWSER 560
-EH_CSV 268, 560, 561
-EH_CSVONLY 561
-EH_FULLHTML 561
-EH_ICONS 561
-EH_IMAGES 561
-EH_KEEP 561
-EH_LANGUAGE 561
-EH_PDF 130, 562
-EH_SCALE 562
-EH_XML 562
-EH_ZIP 562
EH-CSVONLY 268
#Else compiler directive 593
Else command 106, 606
Employment table 551
Encode 603
Encode command 52
End-Document command 220, 592
End-Evaluate command 607
End-Execute 615
#end-file predefined variable 44, 260, 261
End-Footing command 588
End-Heading command 588
#End-If compiler directive 593, 594
End-If command 106, 606
End-Of-File condition 260, 261
End-Procedure command 74, 589
End-Program command 33, 587
End-Select command 80, 590
End-Setup command 589
End-SQL command 96, 591
End-While command 108, 608
Entry argument 319
error conditions 370
error-handling 462
procedure 371
routines 97
Evaluate command 106, 224, 607
Execute command 612
Exists command 539
exists() function 58, 286, 573
Exit-Select command 610
exp() function 571
explicit printing 85
Extract command 52, 602
Extufunc.c 301, 302
F
-F command line flag 280
file handle 258
file number 258, 263
file-related functions 58, 573?574
files 257
Fill (Print command argument) 115
Find command 602
Fixed_Nolf argument 258
flat files 257
floating point number 43
floor() function 570
Footing 112, 125, 202
Footing section 73
Footing-Size 125
For-Append argument 257, 263, 265
foreign key 13, 28
Formfeed=No (Declare-Layout command argument) 269
For-Output argument 265
For-Reading argument 258, 259
For-Reports argument 199
For-Writing argument 258, 263
funcitons
to_char() 580
function prototype 299
functions
abs() 569
acos() 569
array() 582
ascii() 582
asin() 569
atan() 569
functions (continued)
ceil() 570
chr() 582
cond() 583
cos() 569
cosh() 570
dateadd() 574
datediff() 574
datenow() 575
datetostr() 575
deg() 570
delete() 573
e10() 571
edit() 576
exists() 573
exp() 571
floor() 570
getenv() 583
instr() 576
instrb() 576
isblank() 577
isnull() 577
length() 577
lengthb() 578
log() 571
log10() 571
lower() 578
lpad() 578
ltrim() 579
mod() 571
nvl() 583
power() 572
rad() 570
range() 584
rename() 573
replace() 579
roman() 579
round() 572
rpad() 578
rtrim() 579
sign() 572
sin() 569
sinh() 570
sqrt() 573
strtodate() 575
substr() 580
substrb() 580
tan() 569
tanh() 570
to_multi_byte() 581
to_number() 581
to_single_byte() 581
translate() 581
trunc() 572
upper() 578
wrapdepth() 584
future data rows 524
G
Get command 181, 187, 643
Get-Color 641
getenv() function 285, 364, 583
GIF 323
global
procedures 75, 369
variables 43
Goto command 609
Graphic Box command 253
Graphic command 251, 632
Graphic Horz-Line command 253
Graphic Vert-Line command 253
GROUP BY clause 19
H
hard-coded 362
HAVING clause 19, 20
Heading 112, 125, 202
Heading section 71
Heading-Size 125
historical data rows 524
HTML 311
fill-out form 343
format 311
hypertext anchor 341
hypertext link 335, 336
tabular procedure 325
HTML Frameset 323
format 312
HTML output 319
Html_Caption procedure 331
Html_Caption_End procedure 331
Html_Hn procedure 333
Html_Hn_End procedure 333
Html_Img procedure 331
Html_On procedure 325
Html_Set_Body_Attributes procedure 322
Html_Set_Head_Tags procedure 322, 323
Html_Table procedure 331
Html_Table_End procedure 331
Html_Td procedure 332
Html_Td_End procedure 332
Html_Th procedure 331
Html_Th_End procedure 331
Html_Tr procedure 331
Html_Tr_End procedure 331
hypertext link 311, 335
anchors 311
I
-I command line flag 280
#If compiler directive 593
If command 105, 606
#Ifdef compiler directive 352, 594
#Ifndef compiler directive 352, 594
implementing security 516?522
implicit printing 85, 113
#Include compiler directive 164, 592
include file 164
Initiated 454, 456
Inline Bind Variables 296
Input command 164, 278, 281, 617
input parameters 472
input/output operations 257
INSERT (SQL statement) 25
instr() 576
instrb() function 576
integer 43
Internet 311
enabling 310
intranet 311
isblank() function 577
isnull() function 577
J
Job definition 509
job streams 378, 492, 502
Job table 552
JPEG 323
K
-KEEP command line flag 212, 279, 563
keyword 9
keyword Delay of the Print command 126
L
Last-Page command 631
length() function 61, 577
lengthb() function 578
Let command 54, 179, 181, 182, 187, 601
Level (On-Break option qualifier) 140, 142
LIKE operator 17
list variables 48, 57
Load-Lookup command 89, 611
local procedure 75, 76, 369
local variables 43
-LOCK command line flag 563
Log Client Request 435
log file 37
log() function 571
log10() function 571
Long Description 434
Lookup command 90, 612
-LOOPS command line flag 530, 590
lower() function 62, 578
Lowercase command 51, 603
lpad() function 578
ltrim() function 61, 579
M
MAX (SQL function) 19
MAX aggregate function 20
Mbtosbs command 604
menu 419
Menu Item 420
Message Log 392
META 323
MIN (SQL function) 19
miscellaneous functions 63
mod() function 571
Money keyword 121
Move command 49, 50, 600
multiple breaks 140
multiple-occurrence 181
multiple-occurrence field 178
multiple-report program 198
Multiply command 49, 605
N
Name operand 125
nested breaks 140, 141
nested query 22
Never (On-Break option qualifier) 138
New-Page command 153, 156, 265, 269, 630
New-Report command 621
Next-Column command 124, 629
Next-Listing command 122, 631
No-Formfeed command 635
-NOLIS command line flag 212, 214, 563
NOT NULL column 26
Notification page 442
Nowait argument 286
NULL value 26
Number keyword 121
numeric format masks 117
numeric functions 58, 569?573
numeric literals 43
numeric variables 42
nvl() function 583
O
-O command line flag 280
OLAP 9
On-Break option 137, 141, 142
On-Error 97, 371
Open command 257, 595
Operator Id 451
Operid 383
Order tab 409
orphan rows 540
OUTPUT-FILE-MODE environmental variable 280
P
Page Designer tab 409
#page-count predefined variable 45
Page-Number command 630
Page-Size command 632
Panel Transfers 442
PDF file 314
PeopleCode 294, 295
script 296
PeopleSoft 12, 378
API 379
fields 380
menus 381
panel groups 381
panels 380
Process Definitions 381
Process Scheduler 289, 378
records 380
PeopleSoft Internet architecture (PIA) 402
PeopleSoft Java servlets 402
PeopleSoft Security 421
PeopleSoft Security views 519
PeopleSoft Web server 402
PeopleTools Run Control 383
permission list 421, 438
Personal SQR 4
platform-independent 362
Position command 121, 225, 632
position controlling technique 244
power() function 572
PRCSAPI.sqc 451
PRCSDEF.sqc 451
precompiled SQR program 282
predefined variables 44
#current-column 44
#current-line 44
#end-file 44, 260, 261
#page-count 45
#return-status 45
#sql-count 45, 99
#sql-status 45
#sqr-max-columns 47
#sqr-max-lines 46
#sqr-pid 45
#sqr-toc-level 47
#sqr-toc-page 47
$current-date 45
$sql-error 45, 98
$sqr-database 45, 365
$sqr-dbcs 45
$sqr-encoding 46
$sqr-encoding-console 46
$sqr-encoding-database 46
$sqr-encoding-file-input 46
$sqr-encoding-file-output 46
$sqr-encoding-report-output 46
$sqr-encoding-source 46
$sqr-hostname 46
$sqr-locale 45, 359
$sqr-platform 45, 266, 364
$sqr-program 46
$sqr-report 46
$sqr-toc-text 47
$sqr-ver 46
$username 46
primary key 13, 28
Print command 112, 116, 142, 265, 269, 633
On-Break option qualifier 137
Print=Never (On-Break option qualifier) 143, 150
Print-Bar-Code command 249, 250, 637
Print-Chart command 238, 239, 241, 635
Print-Direct command 638
?PRINTER
EH 314
PD 129
-PRINTER command line flag 217, 564
HT 311
Printer-DeInit command 639
Printer-Init command 639
Printer-Type 198
Print-Image command 248, 638
prior rows 533
Priority 434
Procedure section 38, 74
Process Definition 432, 434
Process Definition Options page 436
Process Detail page 390, 447
Process Groups 438
Process Instance 451
Process Monitor 379, 461
process recurrences 492
Process Request Parameters 391, 392
Process Request table 296, 451
Process Scheduler 293, 379, 384
Process Security Groups 437
processes 378
Processing 454, 456
program log 36
Program section 33, 69
program sectioning 587?592
Put command 179, 240, 644
Q
queued 456
R
rad() function 570
range() function 584
Read command 259, 596
read status 261
reading
binary data 262
date fields 262
from a file 259
text data 262
Recurrence definition 493
Recurrence Name 437
referential integrity 28, 540
relational database 12
model 12
relational operator 17
rename() function 58, 286, 573
replace() 10
replace() function 579
report argument 35
report file 37
report flag 35
#return-status predefined variable 45
Role 438, 421
Rollback command 610
roman() function 579
round() function 572
row number 178
row-level security 517
rpad() function 578
-RS command line flag 283, 564
-RT command line flag 283
rtrim() function 61, 579
run control 383
Run Control ID 383,
384, 451
Run Control page 383
Run Control panel 406, 410
Run Control record 384, 404
Run Location 436
run-time variables 160
S
-S command line flag 353
SAP 9
Save (On-Break option qualifier) 143, 147, 149
Sbtombs command 605
security access 421
SELECT (SQL statement) 14
nested 22
qualified 15
unqualified 14
SELECT DISTINCT (SQL statement) 16
Select paragraph 80
sequential files 257
sequential search 191
Server Name 436
Set-Color 642
Set-Delay-Print 126
SETENV.sqc 451
Setenv.sqc 363
Set-Generations 617
Set-Levels 617
Set-Members 616
Setup section 69
Show command 349, 646
sign() function 572
sin() function 569
sinh() function 570
Skip argument 100, 371
Skiplines (On-Break option qualifier) 139
sort files 273
SPF files 212
SPF output 214
SQC file 363, 451, 482
SQL 12, 14
SQL paragraph 96, 100
#sql-count predefined variable 45, 99
$sql-error predefined variable 45, 98
#sql-status predefined variable 45
SQR xxv
API 293
architecture 4
array 176
bind variables 160
columns 42
command line 379
command line arguments 281
command line flags 278, 557
Dialog Box 34
Execute command 283
literals 43
locale 358
logical expression 103
page description 66
Portable Files 212
Print command 216
Printer 212
procedure 38
runtime 435
variables 42
Viewer 212, 214
SQR command flag 314
-EH_CSV 268
EH-CSVONLY 268
SQR commands
Alter-Report 620
Begin-Execute 615
End-Execute 615
Set-Generations 617
Set-Levels 617
Set-Members 616
SQR Execute 4
SQR function
replace() 10, 579
SQR Print 4
SQR Report Builder 4, 5
SQR Report Viewer 4
SQR Server 4
SQR Workbench 4
SQR.ini 280, 358
SQR_DB_DATE_FORMAT (environmental variable) 366
$sqr-database predefined variable 45, 365
$sqr-dbcs predefined variable 45
$sqr-encoding predefined variable 46
$sqr-locale predefined variable 45, 359
SQRP 217
#sqr-pid predefined variable 45
$sqr-platform predefined variable 45, 266, 364
$sqr-program predefined variable 46
$sqr-report predefined variable 46
SQRT 283
sqrt() function 573
$sqr-ver predefined variable 46
SQRW 278
SQRWP 217
SQRWT 283
SQT 435
programs 283
status 259
Status (Open command argument) 258, 261, 264, 266, 371
STDAPI 451, 454
Stop command 100, 371, 649
String 53, 604
string
functions 61, 576?582
literals 43
manipulation commands 51
variables 42
strtodate() function 59, 263, 575
Structured Query Language. See SQL
Structured Query Report Writer xxv, 33
substitution variables 114, 162, 593
substr() function 580
substrb() function 580
Subtract command 49, 605
Success 456
SUM (SQL function) 19
synchronous mode 286
T
table join 23
table name aliases 23
table of contents 315
tan() function 569
tanh() function 570
text format masks 116
-Tnn command line flag 353
to_char() function 62, 580
to_multi_byte() function 581
to_number() function 62, 581
to_single_byte() function 581
Toc-Entry 315, 318
Toc-Entry command 642
top row 532
top-down approach 368
translate() function 581
trunc() function 572
Type=HT 312
type=Vary 258
U
Ucall.c 297
Ufunc.c 297, 301
Underline 115
Unicode 9
UNIX 259
Unstring command 53, 604
UPDATE (SQL statement) 25, 27
upper() function 62, 578
Uppercase command 51, 603
Use command 612
Use-Column command 124, 125, 630
Use-Printer-Type command 201, 625
Use-Procedure command 623
user function 297, 299
User Profile 421
Use-Report command 201, 621
USERFUNCS array 300
$username predefined variable 46
W
Wait argument 286
Warn argument 100, 371
WHERE clause 15, 17
While command 108, 608
wildcard 18
Windows 259
Word documents 302
Wrap argument 115
wrapdepth() function 584
Write command 263, 265, 597
writing to a file 263
X
-XCB command line flag 565
-XI 566
-XLFF 566
-XNAV command line flag 566
-XTOC command line flag 566
Z
-ZIF command line flag 278, 280, 566
-ZIV command line flag 212, 215, 566
-ZRF 567