NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-23
G
FORCE, in PROGRAMS table P-30
FOREIGN KEY table constraint S-68
Form feeds for reports P-3
Form name for reports O-9
Format
dates and times C-163
print item A-54
Formats
Enscribe files Q-4
Formatting commands
See Report writer
Formatting Julian timestamps A-55
FORTRAN S-69
FORTRAN data types, converting to
SQL C-100
FREE RESOURCES statement
and COMMIT WORK statement C-52
and ROLLBACK WORK
statement R-24
description of F-30
lock release summary L-46
FROM clause
limit on tables L-7
SELECT statement S-20
FSDATATYPE in COLUMNS table C-41
Functions
aggregate A-6
, F-32
AV G A-71
CAST C-4
CHAR_LENGTH C-18
COMPUTE_TIMESTAMP C-57
CONVERTTIMESTAMP C-109
COUNT C-125
CURRENT C-162
CURRENT_TIMESTAMP C-163
DATEFORMAT D-13
date-time D-9
DAYOFWEEK D-16
description of F-32
EXTEND E-30
JULIANTIMESTAMP J-4
LINE NUMBER L-12
MAX M-1
MIN M-3
PAGE_NUMBER P-3
POSITION P-22
scalar F-33, S-47
SETSCALE S-47
string S-78
SUBSTRING S-83
SUM S-88
TRIM T-11
UPSHIFT U-14
FUP command F-33/F-36
FUP LICENSE command F-35
G
Generalized owner G-1, S-13, S-14
Generic lock L-48
GET CATALOG OF SYSTEM
statement G-1
GET VERSION OF PROGRAM
statement G-4
GET VERSION statement G-2
GOAWAY command G-6, U-18
GRANT statement S-68
Granularity L-46
GROUP BY clause
and null values N-9
and UNION operator S-27
SELECT statement S-22, S-24
Group manager G-7, S-12
Group number S-12
Grouped rows, conditions S-21
Grouped view
description of S-24
FROM clause S-19
view creation C-160