Index

F

Feb 29 Leap years
FETCH statement : syntax FETCH statement [ESQL] [SP]
fetches : blocking of - r command-line option
fetches : one row per request - r command-line option
File property Properties available for each database
FileDataSourceName connection parameter FileDataSourceName connection parameter [FileDSN]
files : dbspaces CREATE DBSPACE statement
files : location How Adaptive Server Anywhere locates files
FileVersion property Properties available for each database
FIPS : conformance SQL_FLAGGER_ERROR_LEVEL option
FIRE_TRIGGERS option Transact-SQLcompatibility options
FIRE_TRIGGERS option
FIXED file format INPUT_FORMAT option [ISQL
OUTPUT_FORMAT option [ISQL
float as double FLOAT_AS_DOUBLE option
FLOAT data type : about FLOAT data type [Numeric]
FLOAT_AS_DOUBLE option FLOAT_AS_DOUBLE option
FLOOR function FLOOR function [Numeric]
FOR statement : syntax FOR statement
foreign keys : and integrity Adaptive Server Anywhere SQL features
foreign keys : in the system tables SYSFKCOL system table
SYSFOREIGNKEY system table
foreign keys : integrity constraints CREATE TABLE statement
foreign keys : role names CREATE TABLE statement
foreign keys : system views SYSFOREIGNKEYS system view
foreign keys : unnamed CREATE TABLE statement
foreign table : in the system tables SYSFOREIGNKEY system table
format : input file INPUT_FORMAT option [ISQL
FoxPro file format INPUT_FORMAT option [ISQL
OUTPUT_FORMAT option [ISQL
FreeWriteCurr property Properties available for the server
FreeWritePush property Properties available for the server
FROM clause : SELECT statement SELECT statement
FROM clause : syntax FROM clause
FullCompare property Connection properties
Properties available for the server
functions CHAPTER 8. SQL Functions
functions : ABS function ABS function [Numeric]
functions : ACOS function ACOS function [Numeric]
functions : aggregate Aggregate functions
functions : ARGN function ARGN function [Miscellaneous]
functions : ASCII function ASCII function [String]
functions : ASIN function ASIN function [Numeric]
functions : ATAN function ATAN function [Numeric]
functions : ATAN2 function ATAN2 function [Numeric]
functions : AVG function AVG function [Aggregate]
functions : BYTE_LENGTH function BYTE_LENGTH function [String]
functions : BYTE_SUBSTR function BYTE_SUBSTR function [String]
functions : CAST function CAST function [Data type conversion]
functions : CEILING function CEILING function [Numeric]
functions : CHAR function CHAR function [String]
functions : CHARINDEX function CHARINDEX function [String]
functions : CHAR_LENGTH function CHAR_LENGTH function [String]
functions : COALESCE function COALESCE function [Miscellaneous]
functions : col_length Adaptive Server Enterprise function Connection properties
functions : col_name Adaptive Server Enterprise function Connection properties
functions : CONNECTION_PROPERTY function CONNECTION_PROPERTY function [System]
functions : CONVERT function CONVERT function [Data type conversion]
functions : COS function COS function [Numeric]
functions : COT function COT function [Numeric]
functions : COUNT function COUNT function [Aggregate]
functions : creating CREATE FUNCTION statement
functions : curunreservedpgs Adaptive Server Enterprise function Connection properties
functions : data type conversion Data type conversion functions
functions : datalength Adaptive Server Enterprise function Connection properties
functions : DATALENGTH function DATALENGTH function [System]
DATALENGTH function [System]
functions : data_pgs Adaptive Server Enterprise function Connection properties
functions : date and time Date and time functions
functions : DATE function DATE function [Date and time]
functions : DATEADD function DATEADD function [Date and time-TSQL]
functions : DATEDIFF function DATEDIFF function [Date and time-TSQL]
functions : DATEFORMAT function DATEFORMAT function [Date and time]
functions : DATENAME function DATENAME function [Date and time-TSQL]
functions : DATEPART function DATEPART function [Date and time-TSQL]
functions : DATETIME function DATETIME function [Date and time]
functions : DAY function DAY function [Date and time]
functions : DAYNAME function DAYNAME function [Date and time]
functions : DAYS function DAYS function [Date and time]
functions : db_id Adaptive Server Enterprise function Connection properties
functions : DB_ID function DB_ID function [System]
functions : db_name Adaptive Server Enterprise function Connection properties
functions : DB_NAME function DB_NAME function [System]
functions : DB_PROPERTY function DB_PROPERTY function [System]
functions : DEGREES function DEGREES function [Numeric]
functions : DIFFERENCE function DIFFERENCE function [String]
functions : DOW function DOW function [Date and time]
functions : dropping DROP statement
functions : ESTIMATE function ESTIMATE function [Miscellaneous]
functions : ESTIMATE_SOURCE function ESTIMATE_SOURCE function [Miscellaneous]
functions : EXP function EXP function [Numeric]
functions : EXPERIENCE_ESTIMATE function EXPERIENCE_ESTIMATE function [Miscellaneous]
functions : FLOOR function FLOOR function [Numeric]
functions : GETDATE function GETDATE function [Date and time-TSQL]
functions : HEXTOINT function HEXTOINT function [Data type conversion]
functions : host_id Adaptive Server Enterprise function Connection properties
functions : host_name Adaptive Server Enterprise function Connection properties
functions : HOUR function HOUR function [Date and time]
functions : HOURS function HOURS function [Date and time]
functions : IFNULL function IFNULL function [Miscellaneous]
functions : image Text and image functions
functions : index_col Adaptive Server Enterprise function Connection properties
functions : INDEX_ESTIMATE function INDEX_ESTIMATE function [Miscellaneous]
functions : INSERTSTR function INSERTSTR function [String]
functions : INTTOHEX function INTTOHEX function [Data type conversion]
functions : ISNULL function ISNULL function [Miscellaneous]
functions : LCASE function LCASE function [String]
functions : lct_admin Adaptive Server Enterprise function Connection properties
functions : LEFT function LEFT function [String]
functions : LENGTH function LENGTH function[String]
functions : LIST function LIST function [Aggregate]
functions : LOCATE function LOCATE function [String]
functions : LOG function LOG function [Numeric]
functions : LOG10 function LOG10 function [Numeric]
functions : LOWER function LOWER function [String]
functions : LTRIM function LTRIM function [String]
functions : MAX function MAX function [Aggregate]
functions : MIN function MIN function [Aggregate]
functions : MINUTE function MINUTE function [Date and time]
functions : MINUTES function MINUTES function [Date and time]
functions : miscellaneous Miscellaneous functions
functions : MOD function MOD function [Numeric]
functions : MONTH function MONTH function [Date and time]
functions : MONTHNAME function MONTHNAME function [Date and time]
functions : MONTHS function MONTHS function [Date and time]
functions : NEXT_CONNECTION function NEXT_CONNECTION function [System]
functions : NEXT_DATABASE function NEXT_DATABASE function [System]
functions : NOW function NOW function [Date and time]
functions : NULLIF function NULLIF function [Miscellaneous]
functions : NUMBER function NUMBER function [Miscellaneous]
functions : numeric Numeric functions
functions : object_id Adaptive Server Enterprise function Connection properties
functions : object_name Adaptive Server Enterprise function Connection properties
functions : PATINDEX function PATINDEX function [String]
functions : PI function PI function [Numeric]
functions : PLAN function PLAN function [Miscellaneous]
functions : POWER function POWER function [Numeric]
functions : proc_role Adaptive Server Enterprise function Connection properties
functions : PROPERTY function PROPERTY function [System]
functions : PROPERTY_DESCRIPTION function PROPERTY_DESCRIPTION function [System]
functions : PROPERTY_NAME function PROPERTY_NAME function [System]
functions : PROPERTY_NUMBER function PROPERTY_NUMBER function [System]
functions : QUARTER function QUARTER function [Date and time]
functions : RADIANS function RADIANS function [Numeric]
functions : RAND function RAND function [Numeric]
functions : REMAINDER function REMAINDER function [Numeric]
functions : REPEAT function REPEAT function [String]
functions : REPLICATE function REPLICATE function [String]
functions : reserved_pgs Adaptive Server Enterprise function Connection properties
functions : RIGHT function RIGHT function [String]
functions : ROUND function ROUND function [Numeric]
functions : rowcnt Adaptive Server Enterprise function Connection properties
functions : RTRIM function RTRIM function [String]
functions : SECOND function SECOND function [Date and time]
functions : SECONDS function SECONDS function [Date and time]
functions : show_role Adaptive Server Enterprise function Connection properties
functions : SIGN function SIGN function [Numeric]
functions : SIMILAR function SIMILAR function [String]
functions : SIN function SIN function [Numeric]
functions : SOUNDEX function SOUNDEX function [String]
functions : SPACE function SPACE function [Miscellaneous]
functions : SQRT function SQRT function [Miscellaneous]
functions : STR function STR function [String]
functions : string String functions
functions : STRING function STRING function [String]
functions : STUFF function STUFF function [String]
functions : SUBSTR function SUBSTR function [String]
functions : SUM function SUM function [Aggregate]
functions : suser_id Adaptive Server Enterprise function Connection properties
functions : suser_name Adaptive Server Enterprise function Connection properties
functions : system Connection properties
functions : TAN function TAN function [Numeric]
functions : text Text and image functions
functions : TEXTPTR function TEXTPTR function [String]
functions : TODAY function TODAY function [Date and time]
functions : TRACEBACK function TRACEBACK function [Miscellaneous]
functions : Transact-SQL Connection properties
functions : TRIM function TRIM function [String]
functions : TRUNCATE function "TRUNCATE" function [Numeric]
functions : TRUNCNUM function TRUNCNUM function [Numeric]
functions : tsequal Adaptive Server Enterprise function Connection properties
functions : UCASE function UCASE function [String]
functions : UPPER function UPPER function [String]
functions : used_pgs Adaptive Server Enterprise function Connection properties
functions : user-defined CREATE FUNCTION statement
RETURN statement
functions : user_id Adaptive Server Enterprise function Connection properties
functions : user_name Adaptive Server Enterprise function Connection properties
functions : valid_name Adaptive Server Enterprise function Connection properties
functions : valid_user Adaptive Server Enterprise function Connection properties
functions : WEEKS function WEEKS function [Date and time]
functions : YEARS function YEARS function [Date and time]
functions : YMD function YMD function [Date and time]
functions system System functions
functions, numeric : ATAN ATAN function [Numeric]