1004
APPX
Appendix 14 List of Available SQL Commands for CPU Module Database Access Function
CEILING
This command obtains the smallest integer greater than or equal to the specified numeric expression.
■Application example
• To obtain the smallest integer greater than or equal to the fld1 value from table1
SELECT CEILING ("fld1") FROM "table1";
COS
This command obtains a cosine.
■Application example
• To obtain the cosine of fld1 from table1
SELECT COS ("fld1") FROM "table1";
COT
This command obtains a cotangent.
■Application example
• To obtain the cotangent of fld1 from table1
SELECT COT ("fld1") FROM "table1";
DEGREES
This command obtains degrees from radians.
■Application example
• To obtain degrees of fld1 from table1
SELECT DEGREES ("fld1") FROM "table1";
EXP
This command obtains an exponent value. (It calculates e raised to the power of [numeric expression].)
■Application example
• To obtain e raised to the power of fld1 from table1
SELECT EXP ("fld1") FROM "table1";
Syntax
CEILING ([numeric expression])
Syntax
COS ([numeric expression])
Syntax
COT ([numeric expression])
Syntax
DEGREES ([numeric expression])
Syntax
EXP ([numeric expression])
To Next Page
Loading...
