importjava.sql.Connection;importjava.sql.DatabaseMetaData;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;publicclassMain {publicstaticvoidmain(String[] args)throwsException { Connection conn = getConnection(); DatabaseMetaData mtdt = conn.getMetaData(); System.out.println(mtdt.getProcedureTerm()); ResultSet rs = mtdt.getProcedures(conn.getCatalog(),"%", "%"); ResultSetMetaData rsmd = rs.getMetaData();intnumCols = rsmd.getColumnCount();for(inti = 1; i <= numCols; i++) {if(i > 1) System.out.print(", "); System.out.print(rsmd.getColumnLabel(i)); } System.out.println("");while(rs.next()) {for(inti = 1; i <= numCols; i++) {if(i > 1) System.out.print(", "); System.out.print(rs.getString(i)); } System.out.println(""); } conn.close(); }privatestaticConnection getConnection()throwsException { Class.forName("org.hsqldb.jdbcDriver"); String url = "jdbc:hsqldb:mem:data/tutorial";returnDriverManager.getConnection(url, "sa", ""); } }

PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, NUM_INPUT_PARAMS, NUM_OUTPUT_PARAMS, NUM_RESULT_SETS, REMARKS, PROCEDURE_TYPE, ORIGIN, SPECIFIC_NAME null, PUBLIC, ABS, 1, 0, 1, Returns the absolute value of the given`double`

value., 2, ALIAS, org.hsqldb.Library.abs(double) null, PUBLIC, ACOS, 1, 0, 1, Returns the arc cosine of an angle, in the range of 0.0 throughpi. Special case:

- If the argument is NaN or its absolute value is greater than 1, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.acos(double)
null, PUBLIC, ASCII, 1, 0, 1, Returns the Unicode code value of the leftmost character of `s`

as an `int`

. This is the same as the ASCII value if the string contains only ASCII characters., 2, ALIAS, org.hsqldb.Library.ascii(java.lang.String)
null, PUBLIC, ASIN, 1, 0, 1, Returns the arc sine of an angle, in the range of -*pi*/2 through *pi*/2. Special cases:

- If the argument is NaN or its absolute value is greater than 1, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.asin(double)
null, PUBLIC, ATAN, 1, 0, 1, Returns the arc tangent of an angle, in the range of -*pi*/2 through *pi*/2. Special cases:

- If the argument is NaN, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.atan(double)
null, PUBLIC, ATAN2, 2, 0, 1, Converts rectangular coordinates (`x`

, `y`

) to polar (r, *theta*). This method computes the phase *theta* by computing an arc tangent of `y/x`

in the range of -*pi* to *pi*. Special cases:

- If either argument is NaN, then the result is NaN.
- If the first argument is positive zero and the second argument is positive, or the first argument is positive and finite and the second argument is positive infinity, then the result is positive zero.
- If the first argument is negative zero and the second argument is positive, or the first argument is negative and finite and the second argument is positive infinity, then the result is negative zero.
- If the first argument is positive zero and the second argument is negative, or the first argument is positive and finite and the second argument is negative infinity, then the result is the
`double`

value closest to*pi*. - If the first argument is negative zero and the second argument is negative, or the first argument is negative and finite and the second argument is negative infinity, then the result is the
`double`

value closest to -*pi*. - If the first argument is positive and the second argument is positive zero or negative zero, or the first argument is positive infinity and the second argument is finite, then the result is the
`double`

value closest to*pi*/2. - If the first argument is negative and the second argument is positive zero or negative zero, or the first argument is negative infinity and the second argument is finite, then the result is the
`double`

value closest to -*pi*/2. - If both arguments are positive infinity, then the result is the
`double`

value closest to*pi*/4. - If the first argument is positive infinity and the second argument is negative infinity, then the result is the
`double`

value closest to 3**pi*/4. - If the first argument is negative infinity and the second argument is positive infinity, then the result is the
`double`

value closest to -*pi*/4. - If both arguments are negative infinity, then the result is the
`double`

value closest to -3**pi*/4.

A result must be within 2 ulps of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.atan2(double,double)
null, PUBLIC, BITAND, 2, 0, 1, Returns the bit-wise logical *and* of the given integer values., 2, ALIAS, org.hsqldb.Library.bitand(int,int)
null, PUBLIC, BITOR, 2, 0, 1, Returns the bit-wise logical *xor* of the given integer values., 2, ALIAS, org.hsqldb.Library.bitor(int,int)
null, PUBLIC, BITXOR, 2, 0, 1, null, 2, ALIAS, org.hsqldb.Library.bitxor(int,int)
null, PUBLIC, BIT_LENGTH, 1, 0, 1, Returns the number of bits in the given `String`

. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.bitLength(java.lang.String)
null, PUBLIC, CEILING, 1, 0, 1, Returns the smallest (closest to negative infinity) `double`

value that is not less than the argument and is equal to a mathematical integer. Special cases:

- If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
- If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
- If the argument value is less than zero but greater than -1.0, then the result is negative zero.

`Math.ceil(x)`

is exactly the value of `-Math.floor(-x)`

., 2, ALIAS, java.lang.Math.ceil(double)
null, PUBLIC, CHAR, 1, 0, 1, Returns the character string corresponding to the given ASCII (or Unicode) value. In some SQL CLI implementations, a `null`

is returned if the range is outside 0..255. In HSQLDB, the corresponding Unicode character is returned unchecked., 2, ALIAS, org.hsqldb.Library.character(int)
null, PUBLIC, CHARACTER_LENGTH, 1, 0, 1, Returns the number of characters in the given `String`

. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.length(java.lang.String)
null, PUBLIC, CHAR_LENGTH, 1, 0, 1, Returns the number of characters in the given `String`

. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.length(java.lang.String)
null, PUBLIC, CONCAT, 2, 0, 1, Returns a `String`

object that is the result of an *SQL-style* concatenation of the given `String`

objects.

**Note:** by *SQL-style*, it is meant:

- if both
`String`

objects are`null`

, return`null`

- if only one string is
`null`

, return the other - if both
`String`

objects are non-null, return as a`String`

object the character sequence obtained by listing, in left to right order, the characters of the first string followed by the characters of the second

- If the argument is NaN or an infinity, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.cos(double)
null, PUBLIC, COT, 1, 0, 1, Returns the cotangent of the given `double`

value expressed in radians., 2, ALIAS, org.hsqldb.Library.cot(double)
null, PUBLIC, CURDATE, 1, 0, 1, null, 2, ALIAS, org.hsqldb.Library.curdate(java.sql.Connection)
null, PUBLIC, CURTIME, 1, 0, 1, null, 2, ALIAS, org.hsqldb.Library.curtime(java.sql.Connection)
null, PUBLIC, DATABASE, 1, 0, 1, Returns the name of the database corresponding to this connection., 2, ALIAS, org.hsqldb.Library.database(java.sql.Connection)
null, PUBLIC, DATEDIFF, 3, 0, 1, Returns the number of date and time boundaries crossed between two specified datetime values., 2, ALIAS, org.hsqldb.Library.datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)
null, PUBLIC, DAY, 1, 0, 1, Returns the day of the month from the given date value, as an integer value in the range of 1-31., 2, ALIAS, org.hsqldb.Library.dayofmonth(java.sql.Date)
null, PUBLIC, DAYNAME, 1, 0, 1, Returns a character string containing the name of the day (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday ) for the day portion of the given `java.sql.Date`

., 2, ALIAS, org.hsqldb.Library.dayname(java.sql.Date)
null, PUBLIC, DAYOFMONTH, 1, 0, 1, Returns the day of the month from the given date value, as an integer value in the range of 1-31., 2, ALIAS, org.hsqldb.Library.dayofmonth(java.sql.Date)
null, PUBLIC, DAYOFWEEK, 1, 0, 1, Returns the day of the week from the given date value, as an integer value in the range 1-7, where 1 represents Sunday., 2, ALIAS, org.hsqldb.Library.dayofweek(java.sql.Date)
null, PUBLIC, DAYOFYEAR, 1, 0, 1, Returns the day of the year from the given date value, as an integer value in the range 1-366., 2, ALIAS, org.hsqldb.Library.dayofyear(java.sql.Date)
null, PUBLIC, DEGREES, 1, 0, 1, Converts an angle measured in radians to an approximately equivalent angle measured in degrees. The conversion from radians to degrees is generally inexact; users should *not* expect `cos(toRadians(90.0))`

to exactly equal `0.0`

., 2, ALIAS, java.lang.Math.toDegrees(double)
null, PUBLIC, DIFFERENCE, 2, 0, 1, Returns a count of the characters that do not match when comparing the 4 digit numeric SOUNDEX character sequences for the given `String`

objects. If either `String`

object is `null`

, zero is returned., 2, ALIAS, org.hsqldb.Library.difference(java.lang.String,java.lang.String)
null, PUBLIC, EXP, 1, 0, 1, Returns Euler's number *e* raised to the power of a `double`

value. Special cases:

- If the argument is NaN, the result is NaN.
- If the argument is positive infinity, then the result is positive infinity.
- If the argument is negative infinity, then the result is positive zero.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.exp(double)
null, PUBLIC, FLOOR, 1, 0, 1, Returns the largest (closest to positive infinity) `double`

value that is not greater than the argument and is equal to a mathematical integer. Special cases:

- If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
- If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.

`String`

of hexidecimal digit characters to a raw binary value, represented as a `String`

. The given `String`

object must consist of a sequence of 4 digit hexidecimal character substrings.

If its length is not evenly divisible by 4, `null`

is returned. If any any of its 4 character subsequences cannot be parsed as a 4 digit, base 16 value, then a NumberFormatException is thrown. This conversion has the effect of reducing the character count 4:1., 2, ALIAS, org.hsqldb.Library.hexToRaw(java.lang.String)
null, PUBLIC, HOUR, 1, 0, 1, Returns the hour from the given time value, as an integer value in the range of 0-23., 2, ALIAS, org.hsqldb.Library.hour(java.sql.Time)
null, PUBLIC, IDENTITY, 0, 0, 1, Retrieves the last auto-generated integer indentity value used by this connection. As of 1.7.1 this is a dummy function. The return value is supplied directly by Function.java, 2, ALIAS, org.hsqldb.Library.identity()
null, PUBLIC, INSERT, 4, 0, 1, Returns a character sequence which is the result of writing the first `length`

number of characters from the second given `String`

over the first string. The start position in the first string where the characters are overwritten is given by `start`

.

**Note:** In order of precedence, boundry conditions are handled as follows:

- if either supplied
`String`

is null, then the other is returned; the check starts with the first given`String`

. - if
`start`

is less than one,`s1`

is returned - if
`length`

is less than or equal to zero,`s1`

is returned - if the length of
`s2`

is zero,`s1`

is returned - if
`start`

is greater than the length of`s1`

,`s1`

is returned - if
`length`

is such that, taken together with`start`

, the indicated interval extends beyond the end of`s1`

, then the insertion is performed precisely as if upon a copy of`s1`

extended in length to just include the indicated interval

`String`

, with all upper case characters converted to lower case. This uses the default Java String conversion., 2, ALIAS, org.hsqldb.Library.lcase(java.lang.String)
null, PUBLIC, LEFT, 2, 0, 1, Returns the leftmost `count`

characters from the given `String`

. **Note:** boundry conditions are handled in the following order of precedence:

- if
`s`

is`null`

, then`null`

is returned - if
`count`

is less than 1, then a zero-length`String`

is returned - if
`count`

is greater than the length of`s`

, then a copy of`s`

is returned

`String`

. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.length(java.lang.String)
null, PUBLIC, LOCATE, 3, 0, 1, Returns the starting position of the first occurrence of the given `search`

`String`

object within the given `String`

object, `s`

. The search for the first occurrence of `search`

begins with the first character position in `s`

, unless the optional argument, `start`

, is specified (non-null). If `start`

is specified, the search begins with the character position indicated by the value of `start`

, where the first character position in `s`

is indicated by the value 1. If `search`

is not found within `s`

, the value 0 is returned., 2, ALIAS, org.hsqldb.Library.locate(java.lang.String,java.lang.String,java.lang.Integer)
null, PUBLIC, LOG, 1, 0, 1, Returns the natural logarithm (base `double`

value. Special cases: - If the argument is NaN or less than zero, then the result is NaN.
- If the argument is positive infinity, then the result is positive infinity.
- If the argument is positive zero or negative zero, then the result is negative infinity.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.log(double)
null, PUBLIC, LOG10, 1, 0, 1, Returns the base 10 logarithm of the given `double`

value., 2, ALIAS, org.hsqldb.Library.log10(double)
null, PUBLIC, LOWER, 1, 0, 1, Returns a copy of the given `String`

, with all upper case characters converted to lower case. This uses the default Java String conversion., 2, ALIAS, org.hsqldb.Library.lcase(java.lang.String)
null, PUBLIC, LTRIM, 1, 0, 1, Returns the characters of the given `String`

, with the leading spaces removed. Characters such as TAB are not removed., 2, ALIAS, org.hsqldb.Library.ltrim(java.lang.String)
null, PUBLIC, MINUTE, 1, 0, 1, Returns the minute from the given time value, as integer value in the range of 0-59., 2, ALIAS, org.hsqldb.Library.minute(java.sql.Time)
null, PUBLIC, MOD, 2, 0, 1, Returns the remainder (modulus) of the first given integer divided by the second.

, 2, ALIAS, org.hsqldb.Library.mod(int,int) null, PUBLIC, MONTH, 1, 0, 1, Returns the month from the given date value, as an integer value in the range of 1-12 or 0-11.

If the sql_month database property is set `true`

, then the range is 1-12, else 0-11, 2, ALIAS, org.hsqldb.Library.month(java.sql.Date)
null, PUBLIC, MONTHNAME, 1, 0, 1, Returns a character string containing the name of month (January, February, March, April, May, June, July, August, September, October, November, December) for the month portion of the given date value., 2, ALIAS, org.hsqldb.Library.monthname(java.sql.Date)
null, PUBLIC, NOW, 1, 0, 1, null, 2, ALIAS, org.hsqldb.Library.now(java.sql.Connection)
null, PUBLIC, OCTET_LENGTH, 1, 0, 1, Returns the number of bytes in the given `String`

. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.octetLength(java.lang.String)
null, PUBLIC, PI, 0, 0, 1, Returns the constant value, pi., 2, ALIAS, org.hsqldb.Library.pi()
null, PUBLIC, POWER, 2, 0, 1, Returns of value of the first argument raised to the power of the second argument. Special cases:

- If the second argument is positive or negative zero, then the result is 1.0.
- If the second argument is 1.0, then the result is the same as the first argument.
- If the second argument is NaN, then the result is NaN.
- If the first argument is NaN and the second argument is nonzero, then the result is NaN.
- If the absolute value of the first argument is greater than 1 and the second argument is positive infinity, or the absolute value of the first argument is less than 1 and the second argument is negative infinity, then the result is positive infinity.
- If the absolute value of the first argument is greater than 1 and the second argument is negative infinity, or the absolute value of the first argument is less than 1 and the second argument is positive infinity, then the result is positive zero.
- If the absolute value of the first argument equals 1 and the second argument is infinite, then the result is NaN.
- If the first argument is positive zero and the second argument is greater than zero, or the first argument is positive infinity and the second argument is less than zero, then the result is positive zero.
- If the first argument is positive zero and the second argument is less than zero, or the first argument is positive infinity and the second argument is greater than zero, then the result is positive infinity.
- If the first argument is negative zero and the second argument is greater than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is less than zero but not a finite odd integer, then the result is positive zero.
- If the first argument is negative zero and the second argument is a positive finite odd integer, or the first argument is negative infinity and the second argument is a negative finite odd integer, then the result is negative zero.
- If the first argument is negative zero and the second argument is less than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is greater than zero but not a finite odd integer, then the result is positive infinity.
- If the first argument is negative zero and the second argument is a negative finite odd integer, or the first argument is negative infinity and the second argument is a positive finite odd integer, then the result is negative infinity.
- If the first argument is less than zero and the second argument is a finite even integer, then the result is equal to the result of raising the absolute value of the first argument to the power of the second argument.
- If the first argument is less than zero and the second argument is a finite odd integer, then the result is equal to the negative of the result of raising the absolute value of the first argument to the power of the second argument.
- If the first argument is finite and less than zero and the second argument is finite and not an integer, then the result is NaN.
- If both arguments are integers, then the result is exactly equal to the mathematical result of raising the first argument to the power of the second argument if that result can in fact be represented exactly as a double value.

(In the foregoing descriptions, a floating-point value is considered to be an integer if and only if it is a fixed point of the method {@link #ceil `ceil`} or, equivalently, a fixed point of the method {@link #floor `floor`}. A value is a fixed point of a one-argument method if and only if the result of applying the method to the value is equal to the value.)

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.pow(double,double)
null, PUBLIC, QUARTER, 1, 0, 1, Returns the quarter of the year in the given date value, as an integer value in the range of 1-4., 2, ALIAS, org.hsqldb.Library.quarter(java.sql.Date)
null, PUBLIC, RADIANS, 1, 0, 1, Converts an angle measured in degrees to an approximately equivalent angle measured in radians. The conversion from degrees to radians is generally inexact., 2, ALIAS, java.lang.Math.toRadians(double)
null, PUBLIC, RAND, 0, 0, 1, Returns a `double`

value with a positive sign, greater than or equal to `0.0`

and less than `1.0`

. Returned values are chosen pseudorandomly with (approximately) uniform distribution from that range.

When this method is first called, it creates a single new pseudorandom-number generator, exactly as if by the expression

This new pseudorandom-number generator is used thereafter for all calls to this method and is used nowhere else.new java.util.Random

This method is properly synchronized to allow correct use by more than one thread. However, if many threads need to generate pseudorandom numbers at a great rate, it may reduce contention for each thread to have its own pseudorandom-number generator., 2, ALIAS, java.lang.Math.random()
null, PUBLIC, RAWTOHEX, 1, 0, 1, Converts a raw binary value, as represented by the given `String`

, to the equivalent `String`

of hexidecimal digit characters.

This conversion has the effect of expanding the character count 1:4., 2, ALIAS, org.hsqldb.Library.rawToHex(java.lang.String)
null, PUBLIC, REPEAT, 2, 0, 1, Returns a `String`

composed of the given `String`

, repeated `count`

times., 2, ALIAS, org.hsqldb.Library.repeat(java.lang.String,java.lang.Integer)
null, PUBLIC, REPLACE, 3, 0, 1, Replaces all occurrences of `replace`

in `s`

with the `String`

object: `with`

, 2, ALIAS, org.hsqldb.Library.replace(java.lang.String,java.lang.String,java.lang.String)
null, PUBLIC, RIGHT, 2, 0, 1, Returns the rightmost `count`

characters of the given `String`

, `s`

. **Note:** boundry conditions are handled in the following order of precedence:

- if
`s`

is`null`

,`null`

is returned - if
`count`

is less than one, a zero-length`String`

is returned - if
`count`

is greater than the length of`s`

, a copy of`s`

is returned

`double`

value, rounded to the given `int`

places right of the decimal point. If the supplied rounding place value is negative, rounding is performed to the left of the decimal point, using its magnitude (absolute value)., 2, ALIAS, org.hsqldb.Library.round(double,int)
null, PUBLIC, ROUNDMAGIC, 1, 0, 1, Retrieves a `double`

value. This method provides special handling for numbers close to zero and performs rounding only for numbers within a specific range, returning precisely the given value if it does not lie in this range. Special handling includes:

- input in the interval -0.0000000000001..0.0000000000001 returns 0.0
- input outside the interval -1000000000000..1000000000000 returns input unchanged
- input is converted to String form
- input with a
`String`

form length greater than 16 returns input unchaged -
`String`

form with last four characters of '...000x' where x != '.' is converted to '...0000' -
`String`

form with last four characters of '...9999' is converted to '...999999' - the
`java.lang.Double.doubleValue`

of the`String`

form is returned

`String`

, with trailing spaces removed., 2, ALIAS, org.hsqldb.Library.rtrim(java.lang.String)
null, PUBLIC, SECOND, 1, 0, 1, Returns the second of the given time value, as an integer value in the range of 0-59., 2, ALIAS, org.hsqldb.Library.second(java.sql.Time)
null, PUBLIC, SIGN, 1, 0, 1, Returns an indicator of the sign of the given `double`

value. If the value is less than zero, -1 is returned. If the value equals zero, 0 is returned. If the value is greater than zero, 1 is returned., 2, ALIAS, org.hsqldb.Library.sign(double)
null, PUBLIC, SIN, 1, 0, 1, Returns the trigonometric sine of an angle. Special cases: - If the argument is NaN or an infinity, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.sin(double)
null, PUBLIC, SOUNDEX, 1, 0, 1, Returns a four character code representing the sound of the given `String`

. Non-ASCCI characters in the input `String`

are ignored.

This method was rewritten for HSQLDB by fredt@users to comply with the description at http://www.nara.gov/genealogy/coding.html.

, 2, ALIAS, org.hsqldb.Library.soundex(java.lang.String)
null, PUBLIC, SPACE, 1, 0, 1, Returns a `String`

consisting of `count`

spaces, or `null`

if `count`

is less than zero.

, 2, ALIAS, org.hsqldb.Library.space(int)
null, PUBLIC, SQRT, 1, 0, 1, Returns the correctly rounded positive square root of a `double`

value. Special cases:

- If the argument is NaN or less than zero, then the result is NaN.
- If the argument is positive infinity, then the result is positive infinity.
- If the argument is positive zero or negative zero, then the result is the same as the argument.

`double`

value closest to the true mathematical square root of the argument value., 2, ALIAS, java.lang.Math.sqrt(double)
null, PUBLIC, SUBSTR, 3, 0, 1, Returns the characters from the given `String`

, staring at the indicated one-based `start`

position and extending the (optional) indicated `length`

. If `length`

is not specified (is `null`

), the remainder of `s`

is implied., 2, ALIAS, org.hsqldb.Library.substring(java.lang.String,int,java.lang.Integer)
null, PUBLIC, SUBSTRING, 3, 0, 1, Returns the characters from the given `String`

, staring at the indicated one-based `start`

position and extending the (optional) indicated `length`

. If `length`

is not specified (is `null`

), the remainder of `s`

is implied., 2, ALIAS, org.hsqldb.Library.substring(java.lang.String,int,java.lang.Integer)
null, PUBLIC, TAN, 1, 0, 1, Returns the trigonometric tangent of an angle. Special cases: - If the argument is NaN or an infinity, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.tan(double)
null, PUBLIC, TO_CHAR, 2, 0, 1, null, 2, ALIAS, org.hsqldb.Library.to_char(java.util.Date,java.lang.String)
null, PUBLIC, TRUNCATE, 2, 0, 1, Returns the given `double`

value, truncated to the given `int`

places right of the decimal point. If the given place value is negative, the given `double`

value is truncated to the left of the decimal point, using the magnitude (aboslute value) of the place value., 2, ALIAS, org.hsqldb.Library.truncate(double,int)
null, PUBLIC, UCASE, 1, 0, 1, Returns a copy of the given `String`

, with all lower case characters converted to upper case using the default Java method., 2, ALIAS, org.hsqldb.Library.ucase(java.lang.String)
null, PUBLIC, UPPER, 1, 0, 1, Returns a copy of the given `String`

, with all lower case characters converted to upper case using the default Java method., 2, ALIAS, org.hsqldb.Library.ucase(java.lang.String)
null, PUBLIC, USER, 1, 0, 1, Returns the user's authorization name (the user's name as known to this database)., 2, ALIAS, org.hsqldb.Library.user(java.sql.Connection)
null, PUBLIC, WEEK, 1, 0, 1, Returns the week of the year from the given date value, as an integer value in the range of 1-53., 2, ALIAS, org.hsqldb.Library.week(java.sql.Date)
null, PUBLIC, YEAR, 1, 0, 1, Returns the year from the given date value, as an integer value in the range of 1-9999., 2, ALIAS, org.hsqldb.Library.year(java.sql.Date)
null, PUBLIC, java.lang.Math.IEEEremainder, 2, 0, 1, Computes the remainder operation on two arguments as prescribed by the IEEE 754 standard. The remainder value is mathematically equal to `f1 - f2`

× *n*, where *n* is the mathematical integer closest to the exact mathematical value of the quotient `f1/f2`

, and if two mathematical integers are equally close to `f1/f2`

, then *n* is the integer that is even. If the remainder is zero, its sign is the same as the sign of the first argument. Special cases:

- If either argument is NaN, or the first argument is infinite, or the second argument is positive zero or negative zero, then the result is NaN.
- If the first argument is finite and the second argument is infinite, then the result is the same as the first argument.

`double`

value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned. Special cases: - If the argument is positive zero or negative zero, the result is positive zero.
- If the argument is infinite, the result is positive infinity.
- If the argument is NaN, the result is NaN.

`Double.longBitsToDouble((Double.doubleToLongBits(a)<<1)>>>1)`

, 2, BUILTIN ROUTINE, java.lang.Math.abs(double)
null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of a `float`

value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned. Special cases:

- If the argument is positive zero or negative zero, the result is positive zero.
- If the argument is infinite, the result is positive infinity.
- If the argument is NaN, the result is NaN.

Float.intBitsToFloat(0x7fffffff & Float.floatToIntBits(a)), 2, BUILTIN ROUTINE, java.lang.Math.abs(float) null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of an

`int`

value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned. Note that if the argument is equal to the value of `Integer.MIN_VALUE`

, the most negative representable `int`

value, the result is that same value, which is negative., 2, BUILTIN ROUTINE, java.lang.Math.abs(int)
null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of a `long`

value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned.

Note that if the argument is equal to the value of `Long.MIN_VALUE`

, the most negative representable `long`

value, the result is that same value, which is negative., 2, BUILTIN ROUTINE, java.lang.Math.abs(long)
null, PUBLIC, java.lang.Math.acos, 1, 0, 1, Returns the arc cosine of an angle, in the range of 0.0 through *pi*. Special case:

- If the argument is NaN or its absolute value is greater than 1, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.acos(double)
null, PUBLIC, java.lang.Math.asin, 1, 0, 1, Returns the arc sine of an angle, in the range of -*pi*/2 through *pi*/2. Special cases:

- If the argument is NaN or its absolute value is greater than 1, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.asin(double)
null, PUBLIC, java.lang.Math.atan, 1, 0, 1, Returns the arc tangent of an angle, in the range of -*pi*/2 through *pi*/2. Special cases:

- If the argument is NaN, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.atan(double)
null, PUBLIC, java.lang.Math.atan2, 2, 0, 1, Converts rectangular coordinates (`x`

, `y`

) to polar (r, *theta*). This method computes the phase *theta* by computing an arc tangent of `y/x`

in the range of -*pi* to *pi*. Special cases:

- If either argument is NaN, then the result is NaN.
- If the first argument is positive zero and the second argument is positive, or the first argument is positive and finite and the second argument is positive infinity, then the result is positive zero.
- If the first argument is negative zero and the second argument is positive, or the first argument is negative and finite and the second argument is positive infinity, then the result is negative zero.
- If the first argument is positive zero and the second argument is negative, or the first argument is positive and finite and the second argument is negative infinity, then the result is the
`double`

value closest to*pi*. - If the first argument is negative zero and the second argument is negative, or the first argument is negative and finite and the second argument is negative infinity, then the result is the
`double`

value closest to -*pi*. - If the first argument is positive and the second argument is positive zero or negative zero, or the first argument is positive infinity and the second argument is finite, then the result is the
`double`

value closest to*pi*/2. - If the first argument is negative and the second argument is positive zero or negative zero, or the first argument is negative infinity and the second argument is finite, then the result is the
`double`

value closest to -*pi*/2. - If both arguments are positive infinity, then the result is the
`double`

value closest to*pi*/4. - If the first argument is positive infinity and the second argument is negative infinity, then the result is the
`double`

value closest to 3**pi*/4. - If the first argument is negative infinity and the second argument is positive infinity, then the result is the
`double`

value closest to -*pi*/4. - If both arguments are negative infinity, then the result is the
`double`

value closest to -3**pi*/4.

A result must be within 2 ulps of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.atan2(double,double)
null, PUBLIC, java.lang.Math.cbrt, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.cbrt(double)
null, PUBLIC, java.lang.Math.ceil, 1, 0, 1, Returns the smallest (closest to negative infinity) `double`

value that is not less than the argument and is equal to a mathematical integer. Special cases:

- If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
- If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
- If the argument value is less than zero but greater than -1.0, then the result is negative zero.

`Math.ceil(x)`

is exactly the value of `-Math.floor(-x)`

., 2, BUILTIN ROUTINE, java.lang.Math.ceil(double)
null, PUBLIC, java.lang.Math.cos, 1, 0, 1, Returns the trigonometric cosine of an angle. Special cases: - If the argument is NaN or an infinity, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.cos(double)
null, PUBLIC, java.lang.Math.cosh, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.cosh(double)
null, PUBLIC, java.lang.Math.exp, 1, 0, 1, Returns Euler's number *e* raised to the power of a `double`

value. Special cases:

- If the argument is NaN, the result is NaN.
- If the argument is positive infinity, then the result is positive infinity.
- If the argument is negative infinity, then the result is positive zero.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.exp(double)
null, PUBLIC, java.lang.Math.expm1, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.expm1(double)
null, PUBLIC, java.lang.Math.floor, 1, 0, 1, Returns the largest (closest to positive infinity) `double`

value that is not greater than the argument and is equal to a mathematical integer. Special cases:

`double`

value. Special cases: - If the argument is NaN or less than zero, then the result is NaN.
- If the argument is positive infinity, then the result is positive infinity.
- If the argument is positive zero or negative zero, then the result is negative infinity.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.log(double)
null, PUBLIC, java.lang.Math.log10, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.log10(double)
null, PUBLIC, java.lang.Math.log1p, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.log1p(double)
null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two `double`

values. That is, the result is the argument closer to positive infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other negative zero, the result is positive zero., 2, BUILTIN ROUTINE, java.lang.Math.max(double,double)
null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two `float`

values. That is, the result is the argument closer to positive infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other negative zero, the result is positive zero., 2, BUILTIN ROUTINE, java.lang.Math.max(float,float)
null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two `int`

values. That is, the result is the argument closer to the value of `Integer.MAX_VALUE`

. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.max(int,int)
null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two `long`

values. That is, the result is the argument closer to the value of `Long.MAX_VALUE`

. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.max(long,long)
null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two `double`

values. That is, the result is the value closer to negative infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other is negative zero, the result is negative zero., 2, BUILTIN ROUTINE, java.lang.Math.min(double,double)
null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two `float`

values. That is, the result is the value closer to negative infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other is negative zero, the result is negative zero., 2, BUILTIN ROUTINE, java.lang.Math.min(float,float)
null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two `int`

values. That is, the result the argument closer to the value of `Integer.MIN_VALUE`

. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.min(int,int)
null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two `long`

values. That is, the result is the argument closer to the value of `Long.MIN_VALUE`

. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.min(long,long)
null, PUBLIC, java.lang.Math.pow, 2, 0, 1, Returns of value of the first argument raised to the power of the second argument. Special cases:

- If the second argument is positive or negative zero, then the result is 1.0.
- If the second argument is 1.0, then the result is the same as the first argument.
- If the second argument is NaN, then the result is NaN.
- If the first argument is NaN and the second argument is nonzero, then the result is NaN.
- If the absolute value of the first argument is greater than 1 and the second argument is positive infinity, or the absolute value of the first argument is less than 1 and the second argument is negative infinity, then the result is positive infinity.
- If the absolute value of the first argument is greater than 1 and the second argument is negative infinity, or the absolute value of the first argument is less than 1 and the second argument is positive infinity, then the result is positive zero.
- If the absolute value of the first argument equals 1 and the second argument is infinite, then the result is NaN.
- If the first argument is positive zero and the second argument is greater than zero, or the first argument is positive infinity and the second argument is less than zero, then the result is positive zero.
- If the first argument is positive zero and the second argument is less than zero, or the first argument is positive infinity and the second argument is greater than zero, then the result is positive infinity.
- If the first argument is negative zero and the second argument is greater than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is less than zero but not a finite odd integer, then the result is positive zero.
- If the first argument is negative zero and the second argument is a positive finite odd integer, or the first argument is negative infinity and the second argument is a negative finite odd integer, then the result is negative zero.
- If the first argument is negative zero and the second argument is less than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is greater than zero but not a finite odd integer, then the result is positive infinity.
- If the first argument is negative zero and the second argument is a negative finite odd integer, or the first argument is negative infinity and the second argument is a positive finite odd integer, then the result is negative infinity.
- If the first argument is less than zero and the second argument is a finite even integer, then the result is equal to the result of raising the absolute value of the first argument to the power of the second argument.
- If the first argument is less than zero and the second argument is a finite odd integer, then the result is equal to the negative of the result of raising the absolute value of the first argument to the power of the second argument.
- If the first argument is finite and less than zero and the second argument is finite and not an integer, then the result is NaN.
- If both arguments are integers, then the result is exactly equal to the mathematical result of raising the first argument to the power of the second argument if that result can in fact be represented exactly as a double value.

(In the foregoing descriptions, a floating-point value is considered to be an integer if and only if it is a fixed point of the method {@link #ceil `ceil`} or, equivalently, a fixed point of the method {@link #floor `floor`}. A value is a fixed point of a one-argument method if and only if the result of applying the method to the value is equal to the value.)

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.pow(double,double)
null, PUBLIC, java.lang.Math.random, 0, 0, 1, Returns a `double`

value with a positive sign, greater than or equal to `0.0`

and less than `1.0`

. Returned values are chosen pseudorandomly with (approximately) uniform distribution from that range.

When this method is first called, it creates a single new pseudorandom-number generator, exactly as if by the expression

This new pseudorandom-number generator is used thereafter for all calls to this method and is used nowhere else.new java.util.Random

This method is properly synchronized to allow correct use by more than one thread. However, if many threads need to generate pseudorandom numbers at a great rate, it may reduce contention for each thread to have its own pseudorandom-number generator., 2, BUILTIN ROUTINE, java.lang.Math.random()
null, PUBLIC, java.lang.Math.rint, 1, 0, 1, Returns the `double`

value that is closest in value to the argument and is equal to a mathematical integer. If two `double`

values that are mathematical integers are equally close, the result is the integer value that is even. Special cases:

`long`

to the argument. The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type `long`

. In other words, the result is equal to the value of the expression: (long)Math.floor(a + 0.5d)

Special cases:

- If the argument is NaN, the result is 0.
- If the argument is negative infinity or any value less than or equal to the value of
`Long.MIN_VALUE`

, the result is equal to the value of`Long.MIN_VALUE`

. - If the argument is positive infinity or any value greater than or equal to the value of
`Long.MAX_VALUE`

, the result is equal to the value of`Long.MAX_VALUE`

.

`int`

to the argument. The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type `int`

. In other words, the result is equal to the value of the expression: (int)Math.floor(a + 0.5f)

Special cases:

- If the argument is NaN, the result is 0.
- If the argument is negative infinity or any value less than or equal to the value of
`Integer.MIN_VALUE`

, the result is equal to the value of`Integer.MIN_VALUE`

. - If the argument is positive infinity or any value greater than or equal to the value of
`Integer.MAX_VALUE`

, the result is equal to the value of`Integer.MAX_VALUE`

.

- If the argument is NaN or an infinity, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.sin(double)
null, PUBLIC, java.lang.Math.sinh, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.sinh(double)
null, PUBLIC, java.lang.Math.sqrt, 1, 0, 1, Returns the correctly rounded positive square root of a `double`

value. Special cases:

- If the argument is NaN or less than zero, then the result is NaN.
- If the argument is positive infinity, then the result is positive infinity.
- If the argument is positive zero or negative zero, then the result is the same as the argument.

`double`

value closest to the true mathematical square root of the argument value., 2, BUILTIN ROUTINE, java.lang.Math.sqrt(double)
null, PUBLIC, java.lang.Math.tan, 1, 0, 1, Returns the trigonometric tangent of an angle. Special cases: - If the argument is NaN or an infinity, then the result is NaN.
- If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.tan(double)
null, PUBLIC, java.lang.Math.tanh, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.tanh(double)
null, PUBLIC, java.lang.Math.toDegrees, 1, 0, 1, Converts an angle measured in radians to an approximately equivalent angle measured in degrees. The conversion from radians to degrees is generally inexact; users should *not* expect `cos(toRadians(90.0))`

to exactly equal `0.0`

., 2, BUILTIN ROUTINE, java.lang.Math.toDegrees(double)
null, PUBLIC, java.lang.Math.toRadians, 1, 0, 1, Converts an angle measured in degrees to an approximately equivalent angle measured in radians. The conversion from degrees to radians is generally inexact., 2, BUILTIN ROUTINE, java.lang.Math.toRadians(double)
null, PUBLIC, java.lang.Math.ulp, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.ulp(double)
null, PUBLIC, java.lang.Math.ulp, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.ulp(float)
null, PUBLIC, org.hsqldb.Library.abs, 1, 0, 1, Returns the absolute value of the given `double`

value., 2, BUILTIN ROUTINE, org.hsqldb.Library.abs(double)
null, PUBLIC, org.hsqldb.Library.ascii, 1, 0, 1, Returns the Unicode code value of the leftmost character of `s`

as an `int`

. This is the same as the ASCII value if the string contains only ASCII characters., 2, BUILTIN ROUTINE, org.hsqldb.Library.ascii(java.lang.String)
null, PUBLIC, org.hsqldb.Library.bitLength, 1, 0, 1, Returns the number of bits in the given `String`

. This includes trailing blanks., 2, BUILTIN ROUTINE, org.hsqldb.Library.bitLength(java.lang.String)
null, PUBLIC, org.hsqldb.Library.bitand, 2, 0, 1, Returns the bit-wise logical *and* of the given integer values., 2, BUILTIN ROUTINE, org.hsqldb.Library.bitand(int,int)
null, PUBLIC, org.hsqldb.Library.bitor, 2, 0, 1, Returns the bit-wise logical *xor* of the given integer values., 2, BUILTIN ROUTINE, org.hsqldb.Library.bitor(int,int)
null, PUBLIC, org.hsqldb.Library.bitxor, 2, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.bitxor(int,int)
null, PUBLIC, org.hsqldb.Library.character, 1, 0, 1, Returns the character string corresponding to the given ASCII (or Unicode) value. **Note:**

In some SQL CLI implementations, a `null`

is returned if the range is outside 0..255. In HSQLDB, the corresponding Unicode character is returned unchecked., 2, BUILTIN ROUTINE, org.hsqldb.Library.character(int)
null, PUBLIC, org.hsqldb.Library.concat, 2, 0, 1, Returns a `String`

object that is the result of an *SQL-style* concatenation of the given `String`

objects.

**Note:** by *SQL-style*, it is meant:

- if both
`String`

objects are`null`

, return`null`

- if only one string is
`null`

, return the other - if both
`String`

objects are non-null, return as a`String`

object the character sequence obtained by listing, in left to right order, the characters of the first string followed by the characters of the second

`double`

value expressed in radians., 2, BUILTIN ROUTINE, org.hsqldb.Library.cot(double)
null, PUBLIC, org.hsqldb.Library.curdate, 1, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.curdate(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.curtime, 1, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.curtime(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.database, 1, 0, 1, Returns the name of the database corresponding to this connection., 2, BUILTIN ROUTINE, org.hsqldb.Library.database(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.datediff, 3, 0, 1, Returns the number of date and time boundaries crossed between two specified datetime values., 2, BUILTIN ROUTINE, org.hsqldb.Library.datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)
null, PUBLIC, org.hsqldb.Library.dayname, 1, 0, 1, Returns a character string containing the name of the day (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday ) for the day portion of the given `java.sql.Date`

., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayname(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.dayofmonth, 1, 0, 1, Returns the day of the month from the given date value, as an integer value in the range of 1-31., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayofmonth(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.dayofweek, 1, 0, 1, Returns the day of the week from the given date value, as an integer value in the range 1-7, where 1 represents Sunday., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayofweek(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.dayofyear, 1, 0, 1, Returns the day of the year from the given date value, as an integer value in the range 1-366., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayofyear(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.difference, 2, 0, 1, Returns a count of the characters that do not match when comparing the 4 digit numeric SOUNDEX character sequences for the given `String`

objects. If either `String`

object is `null`

, zero is returned., 2, BUILTIN ROUTINE, org.hsqldb.Library.difference(java.lang.String,java.lang.String)
null, PUBLIC, org.hsqldb.Library.getAutoCommit, 1, 0, 1, Retrieves the autocommit status of this connection. , 2, BUILTIN ROUTINE, org.hsqldb.Library.getAutoCommit(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.getDatabaseMajorVersion, 0, 0, 1, Retrieves the major version number of this database.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseMajorVersion() null, PUBLIC, org.hsqldb.Library.getDatabaseMinorVersion, 0, 0, 1, Retrieves the major version number of this database.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseMinorVersion() null, PUBLIC, org.hsqldb.Library.getDatabaseProductName, 0, 0, 1, Retrieves the name of this database product.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseProductName() null, PUBLIC, org.hsqldb.Library.getDatabaseProductVersion, 0, 0, 1, Retrieves the version number of this database product.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseProductVersion()
null, PUBLIC, org.hsqldb.Library.hexToRaw, 1, 0, 1, Converts a `String`

of hexidecimal digit characters to a raw binary value, represented as a `String`

.

The given `String`

object must consist of a sequence of 4 digit hexidecimal character substrings.

If its length is not evenly divisible by 4, `null`

is returned. If any any of its 4 character subsequences cannot be parsed as a 4 digit, base 16 value, then a NumberFormatException is thrown. This conversion has the effect of reducing the character count 4:1., 2, BUILTIN ROUTINE, org.hsqldb.Library.hexToRaw(java.lang.String)
null, PUBLIC, org.hsqldb.Library.hour, 1, 0, 1, Returns the hour from the given time value, as an integer value in the range of 0-23., 2, BUILTIN ROUTINE, org.hsqldb.Library.hour(java.sql.Time)
null, PUBLIC, org.hsqldb.Library.identity, 0, 0, 1, Retrieves the last auto-generated integer indentity value used by this connection. As of 1.7.1 this is a dummy function. The return value is supplied directly by Function.java, 2, BUILTIN ROUTINE, org.hsqldb.Library.identity()
null, PUBLIC, org.hsqldb.Library.insert, 4, 0, 1, Returns a character sequence which is the result of writing the first `length`

number of characters from the second given `String`

over the first string. The start position in the first string where the characters are overwritten is given by `start`

.

**Note:** In order of precedence, boundry conditions are handled as follows:

- if either supplied
`String`

is null, then the other is returned; the check starts with the first given`String`

. - if
`start`

is less than one,`s1`

is returned - if
`length`

is less than or equal to zero,`s1`

is returned - if the length of
`s2`

is zero,`s1`

is returned - if
`start`

is greater than the length of`s1`

,`s1`

is returned - if
`length`

is such that, taken together with`start`

, the indicated interval extends beyond the end of`s1`

, then the insertion is performed precisely as if upon a copy of`s1`

extended in length to just include the indicated interval

, 2, BUILTIN ROUTINE, org.hsqldb.Library.isReadOnlyConnection(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.isReadOnlyDatabase, 1, 0, 1, Retrieves whether this database is in read-only mode.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.isReadOnlyDatabase(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.isReadOnlyDatabaseFiles, 1, 0, 1, Retrieves whether the files of this database are in read-only mode., 2, BUILTIN ROUTINE, org.hsqldb.Library.isReadOnlyDatabaseFiles(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.lcase, 1, 0, 1, Returns a copy of the given `String`

, with all upper case characters converted to lower case. This uses the default Java String conversion., 2, BUILTIN ROUTINE, org.hsqldb.Library.lcase(java.lang.String)
null, PUBLIC, org.hsqldb.Library.left, 2, 0, 1, Returns the leftmost `count`

characters from the given `String`

.

**Note:** boundry conditions are handled in the following order of precedence:

- if
`s`

is`null`

, then`null`

is returned - if
`count`

is less than 1, then a zero-length`String`

is returned - if
`count`

is greater than the length of`s`

, then a copy of`s`

is returned

`String`

. This includes trailing blanks., 2, BUILTIN ROUTINE, org.hsqldb.Library.length(java.lang.String)
null, PUBLIC, org.hsqldb.Library.locate, 3, 0, 1, Returns the starting position of the first occurrence of the given `search`

`String`

object within the given `String`

object, `s`

. The search for the first occurrence of `search`

begins with the first character position in `s`

, unless the optional argument, `start`

, is specified (non-null). If `start`

is specified, the search begins with the character position indicated by the value of `start`

, where the first character position in `s`

is indicated by the value 1. If `search`

is not found within `s`

, the value 0 is returned., 2, BUILTIN ROUTINE, org.hsqldb.Library.locate(java.lang.String,java.lang.String,java.lang.Integer)
null, PUBLIC, org.hsqldb.Library.log10, 1, 0, 1, Returns the base 10 logarithm of the given `double`

value., 2, BUILTIN ROUTINE, org.hsqldb.Library.log10(double)
null, PUBLIC, org.hsqldb.Library.ltrim, 1, 0, 1, Returns the characters of the given `String`

, with the leading spaces removed. Characters such as TAB are not removed., 2, BUILTIN ROUTINE, org.hsqldb.Library.ltrim(java.lang.String)
null, PUBLIC, org.hsqldb.Library.minute, 1, 0, 1, Returns the minute from the given time value, as integer value in the range of 0-59., 2, BUILTIN ROUTINE, org.hsqldb.Library.minute(java.sql.Time)
null, PUBLIC, org.hsqldb.Library.mod, 2, 0, 1, Returns the remainder (modulus) of the first given integer divided by the second. , 2, BUILTIN ROUTINE, org.hsqldb.Library.mod(int,int) null, PUBLIC, org.hsqldb.Library.month, 1, 0, 1, Returns the month from the given date value, as an integer value in the range of 1-12 or 0-11.

If the sql_month database property is set `true`

, then the range is 1-12, else 0-11, 2, BUILTIN ROUTINE, org.hsqldb.Library.month(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.monthname, 1, 0, 1, Returns a character string containing the name of month (January, February, March, April, May, June, July, August, September, October, November, December) for the month portion of the given date value., 2, BUILTIN ROUTINE, org.hsqldb.Library.monthname(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.now, 1, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.now(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.octetLength, 1, 0, 1, Returns the number of bytes in the given `String`

. This includes trailing blanks., 2, BUILTIN ROUTINE, org.hsqldb.Library.octetLength(java.lang.String)
null, PUBLIC, org.hsqldb.Library.pi, 0, 0, 1, Returns the constant value, pi., 2, BUILTIN ROUTINE, org.hsqldb.Library.pi()
null, PUBLIC, org.hsqldb.Library.position, 2, 0, 1, Returns the starting position of the first occurrence of the given `search`

`String`

object within the given `String`

object, `s`

., 2, BUILTIN ROUTINE, org.hsqldb.Library.position(java.lang.String,java.lang.String)
null, PUBLIC, org.hsqldb.Library.quarter, 1, 0, 1, Returns the quarter of the year in the given date value, as an integer value in the range of 1-4., 2, BUILTIN ROUTINE, org.hsqldb.Library.quarter(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.rand, 1, 0, 1, Returns the next pseudorandom, uniformly distributed `double`

value between 0.0 and 1.0 from a single, system-wide random number generator's sequence, optionally re-seeding (and thus resetting) the generator sequence. If the seed value is `null`

, then the underlying random number generator retrieves the next value in its current sequence, else the seed alters the state of the generator object so as to be in exactly the same state as if it had just been created with the seed value., 2, BUILTIN ROUTINE, org.hsqldb.Library.rand(java.lang.Integer)
null, PUBLIC, org.hsqldb.Library.rawToHex, 1, 0, 1, Converts a raw binary value, as represented by the given `String`

, to the equivalent `String`

of hexidecimal digit characters.

This conversion has the effect of expanding the character count 1:4., 2, BUILTIN ROUTINE, org.hsqldb.Library.rawToHex(java.lang.String)
null, PUBLIC, org.hsqldb.Library.repeat, 2, 0, 1, Returns a `String`

composed of the given `String`

, repeated `count`

times., 2, BUILTIN ROUTINE, org.hsqldb.Library.repeat(java.lang.String,java.lang.Integer)
null, PUBLIC, org.hsqldb.Library.replace, 3, 0, 1, Replaces all occurrences of `replace`

in `s`

with the `String`

object: `with`

, 2, BUILTIN ROUTINE, org.hsqldb.Library.replace(java.lang.String,java.lang.String,java.lang.String)
null, PUBLIC, org.hsqldb.Library.right, 2, 0, 1, Returns the rightmost `count`

characters of the given `String`

, `s`

. **Note:** boundry conditions are handled in the following order of precedence:

- if
`s`

is`null`

,`null`

is returned - if
`count`

is less than one, a zero-length`String`

is returned - if
`count`

is greater than the length of`s`

, a copy of`s`

is returned

`double`

value, rounded to the given `int`

places right of the decimal point. If the supplied rounding place value is negative, rounding is performed to the left of the decimal point, using its magnitude (absolute value)., 2, BUILTIN ROUTINE, org.hsqldb.Library.round(double,int)
null, PUBLIC, org.hsqldb.Library.roundMagic, 1, 0, 1, Retrieves a `double`

value. This method provides special handling for numbers close to zero and performs rounding only for numbers within a specific range, returning precisely the given value if it does not lie in this range. Special handling includes:

- input in the interval -0.0000000000001..0.0000000000001 returns 0.0
- input outside the interval -1000000000000..1000000000000 returns input unchanged
- input is converted to String form
- input with a
`String`

form length greater than 16 returns input unchaged -
`String`

form with last four characters of '...000x' where x != '.' is converted to '...0000' -
`String`

form with last four characters of '...9999' is converted to '...999999' - the
`java.lang.Double.doubleValue`

of the`String`

form is returned

`String`

, with trailing spaces removed., 2, BUILTIN ROUTINE, org.hsqldb.Library.rtrim(java.lang.String)
null, PUBLIC, org.hsqldb.Library.second, 1, 0, 1, Returns the second of the given time value, as an integer value in the range of 0-59., 2, BUILTIN ROUTINE, org.hsqldb.Library.second(java.sql.Time)
null, PUBLIC, org.hsqldb.Library.sign, 1, 0, 1, Returns an indicator of the sign of the given `double`

value. If the value is less than zero, -1 is returned. If the value equals zero, 0 is returned. If the value is greater than zero, 1 is returned., 2, BUILTIN ROUTINE, org.hsqldb.Library.sign(double)
null, PUBLIC, org.hsqldb.Library.soundex, 1, 0, 1, Returns a four character code representing the sound of the given `String`

. Non-ASCCI characters in the input `String`

are ignored. This method was rewritten for HSQLDB by fredt@users to comply with the description at http://www.nara.gov/genealogy/coding.html.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.soundex(java.lang.String)
null, PUBLIC, org.hsqldb.Library.space, 1, 0, 1, Returns a `String`

consisting of `count`

spaces, or `null`

if `count`

is less than zero.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.space(int)
null, PUBLIC, org.hsqldb.Library.substring, 3, 0, 1, Returns the characters from the given `String`

, staring at the indicated one-based `start`

position and extending the (optional) indicated `length`

. If `length`

is not specified (is `null`

), the remainder of `s`

is implied., 2, BUILTIN ROUTINE, org.hsqldb.Library.substring(java.lang.String,int,java.lang.Integer)
null, PUBLIC, org.hsqldb.Library.to_char, 2, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.to_char(java.util.Date,java.lang.String)
null, PUBLIC, org.hsqldb.Library.trim, 4, 0, 1, Retrieves a character sequence derived from `s`

with the leading, trailing or both leading and trailing occurances of `trimstr`

removed, 2, BUILTIN ROUTINE, org.hsqldb.Library.trim(java.lang.String,java.lang.String,boolean,boolean)
null, PUBLIC, org.hsqldb.Library.truncate, 2, 0, 1, Returns the given `double`

value, truncated to the given `int`

places right of the decimal point. If the given place value is negative, the given `double`

value is truncated to the left of the decimal point, using the magnitude (aboslute value) of the place value., 2, BUILTIN ROUTINE, org.hsqldb.Library.truncate(double,int)
null, PUBLIC, org.hsqldb.Library.ucase, 1, 0, 1, Returns a copy of the given `String`

, with all lower case characters converted to upper case using the default Java method., 2, BUILTIN ROUTINE, org.hsqldb.Library.ucase(java.lang.String)
null, PUBLIC, org.hsqldb.Library.user, 1, 0, 1, Returns the user's authorization name (the user's name as known to this database)., 2, BUILTIN ROUTINE, org.hsqldb.Library.user(java.sql.Connection)
null, PUBLIC, org.hsqldb.Library.week, 1, 0, 1, Returns the week of the year from the given date value, as an integer value in the range of 1-53., 2, BUILTIN ROUTINE, org.hsqldb.Library.week(java.sql.Date)
null, PUBLIC, org.hsqldb.Library.year, 1, 0, 1, Returns the year from the given date value, as an integer value in the range of 1-9999., 2, BUILTIN ROUTINE, org.hsqldb.Library.year(java.sql.Date)