com.esri.sde.sdk.client
Class SeDBMSInfo

java.lang.Object
  com.esri.sde.sdk.client.SeDBMSInfo

public class SeDBMSInfo
extends java.lang.Object

Stores RDBMS related information.

Field Summary

boolean	canAddColumn Underlying RDBMS can add columns to a table.
boolean	canDropColumn Underlying RDBMS can drop column from a table.
boolean	canOwnerPrefixTable Underlying RDBMS allows owner to prefixe the tablename.
boolean	canRename Underlying RDBMS can rename tables.
int	dbmsId Identifies the underlying RDBMS id.
boolean	isCaseSensitive Underlying RDBMS is case sensitive.
boolean	isCaseSensitiveInComparison Underlying RDBMS is case sensitive for comparisons.
boolean	isPasswordCaseSensitive Underlying RDBMS is case sensitive for password.
boolean	isUserCaseSensitive Underlying RDBMS is case sensitive for user.
static int	SE_DBMS_FUNCTION_ABS Id of the function that will return the absolute value of x.
static int	SE_DBMS_FUNCTION_ACOS Id of the function that will return the arccosine of x.
static int	SE_DBMS_FUNCTION_ASCII Id of the function that will return decimal representation of a string.
static int	SE_DBMS_FUNCTION_ASIN Id of the function that will return the arcsine of x.
static int	SE_DBMS_FUNCTION_ATAN Id of the function that will return the arctangent of x.
static int	SE_DBMS_FUNCTION_AVG Id of the function that will return the average value of n.
static int	SE_DBMS_FUNCTION_BITLEN Id of the function that will return the string length in bits.
static int	SE_DBMS_FUNCTION_CAST Id of the function that converts one data type to another one.
static int	SE_DBMS_FUNCTION_CEIL Id of the function that will return smallest integer >= n.
static int	SE_DBMS_FUNCTION_CHR Id of the function that will return the character of the binary equivalent.
static int	SE_DBMS_FUNCTION_COALSCE Id of the function that will return the first NOT_NULL value.
static int	SE_DBMS_FUNCTION_CONCAT Id of the function that will concatenate string1 with string2.
static int	SE_DBMS_FUNCTION_CONVERT Id of the convert function.
static int	SE_DBMS_FUNCTION_COS Id of the function that will return cosine of x.
static int	SE_DBMS_FUNCTION_COSH Id of the function that will return hyperbolic cosine of x.
static int	SE_DBMS_FUNCTION_COUNT Id of the function that will return the number of rows in the query.
static int	SE_DBMS_FUNCTION_EXTRACT Id of the function that will return a numeric value of a date.
static int	SE_DBMS_FUNCTION_FLOOR Id of the function that will return largest integer <= n.
static int	SE_DBMS_FUNCTION_HEX Id of the function that will return the hexadecimal representation of a number.
static int	SE_DBMS_FUNCTION_LENGTH Id of the function that will return length in char.
static int	SE_DBMS_FUNCTION_LENGTHB Id of the function that will return length in bytes.
static int	SE_DBMS_FUNCTION_LN Id of the function that will return natural logarithm.
static int	SE_DBMS_FUNCTION_LOG Id of the function that will return logarithm of base n.
static int	SE_DBMS_FUNCTION_LOG10 Id of the function that will return logarithm of base 10.
static int	SE_DBMS_FUNCTION_LOWERCASE Id of the function that converts string to lower case.
static int	SE_DBMS_FUNCTION_LTRIM Id of the function that will remove spaces from the left.
static int	SE_DBMS_FUNCTION_MAX Id of the function that will return the maximum value of expression.
static int	SE_DBMS_FUNCTION_MIN Id of the function that will return the minimum value of expression.
static int	SE_DBMS_FUNCTION_MOD Id of the function that will return the remainder.
static int	SE_DBMS_FUNCTION_POSITION Id of the function that will return a numeric value that indicates the starting position of the search string in the source string.
static int	SE_DBMS_FUNCTION_POWER Id of the function that will return the n power of m.
static int	SE_DBMS_FUNCTION_ROUND Id of the function that will round a real nember to specified decimal digits.
static int	SE_DBMS_FUNCTION_RTRIM Id of the function that will remove trailing from the right.
static int	SE_DBMS_FUNCTION_SIGN Id of the function that will return -1 for negative, 0 for zero and 1 for positive.
static int	SE_DBMS_FUNCTION_SIN Id of the function that will return sine of x.
static int	SE_DBMS_FUNCTION_SINH Id of the function that will return hyperbolic sine of x.
static int	SE_DBMS_FUNCTION_SOUNDEX Id of the function that will return a string containing the phonetic representation of string2.
static int	SE_DBMS_FUNCTION_STDDEV Id of the function that will calculate the standard deviation.
static int	SE_DBMS_FUNCTION_SUBSTR Id of the function that will return a portion of a string.
static int	SE_DBMS_FUNCTION_SUBSTRB Id of the function that will return a portion of bytes.
static int	SE_DBMS_FUNCTION_SUM Id of the function that will return the sum of values of n numbers.
static int	SE_DBMS_FUNCTION_TAN Id of the function that will return tangent of x.
static int	SE_DBMS_FUNCTION_TANH Id of the function that will return hyperbolic tangent of x.
static int	SE_DBMS_FUNCTION_TRANSLATE Id of the function that will return string with each char in 'from' string replaced by its corresponding char in 'to' string.
static int	SE_DBMS_FUNCTION_TRIM Id of the function that will strip the leading, trailing * or both from the string.
static int	SE_DBMS_FUNCTION_TRUNC Id of the function that will truncate n to m decimal place.
static int	SE_DBMS_FUNCTION_UPPERCASE Id of the function that converts string to upper case.
static int	SE_DBMS_FUNCTION_USER Id of the function that will return the current user name
static int	SE_DBMS_FUNCTION_VARIANCE Id of the function that will calculate the variance.
static int	SE_DBMS_IS_ARCINFO Underlying RDBMS is arcinfo.
static int	SE_DBMS_IS_ARCSERVER Underlying RDBMS is arcserver.
static int	SE_DBMS_IS_DB2 Underlying RDBMS is DB2.
static int	SE_DBMS_IS_DB2_EXT Underlying RDBMS is DB2 extended server.
static int	SE_DBMS_IS_DB2ZOS Underlying RDBMS is DB2ZOS.
static int	SE_DBMS_IS_INFORMIX Underlying RDBMS is informix.
static int	SE_DBMS_IS_IUS Underlying RDBMS is informix universal server.
static int	SE_DBMS_IS_JET Underlying RDBMS is jet.
static int	SE_DBMS_IS_ORACLE Underlying RDBMS is oracle.
static int	SE_DBMS_IS_OTHER Underlying RDBMS is other.
static int	SE_DBMS_IS_POSTGRESQL Underlying RDBMS is PostgreSQL.
static int	SE_DBMS_IS_SQLSERVER Underlying RDBMS is microsoft sqlserver.
static int	SE_DBMS_IS_SYBASE Underlying RDBMS is sybase.
static int	SE_DBMS_IS_UNKNOWN Underlying RDBMS is unknown.
boolean	supportDelimitedIdentifier Underlying RDBMS supports delimited identifiers.

Method Summary

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

dbmsId

public int dbmsId

Identifies the underlying RDBMS id.

canRename

public boolean canRename

Underlying RDBMS can rename tables.

canAddColumn

public boolean canAddColumn

Underlying RDBMS can add columns to a table.

canDropColumn

public boolean canDropColumn

Underlying RDBMS can drop column from a table.

canOwnerPrefixTable

public boolean canOwnerPrefixTable

Underlying RDBMS allows owner to prefixe the tablename.

isCaseSensitive

public boolean isCaseSensitive

Underlying RDBMS is case sensitive.

supportDelimitedIdentifier

public boolean supportDelimitedIdentifier

Underlying RDBMS supports delimited identifiers.

isCaseSensitiveInComparison

public boolean isCaseSensitiveInComparison

Underlying RDBMS is case sensitive for comparisons.

isUserCaseSensitive

public boolean isUserCaseSensitive

Underlying RDBMS is case sensitive for user.

isPasswordCaseSensitive

public boolean isPasswordCaseSensitive

Underlying RDBMS is case sensitive for password.

SE_DBMS_IS_UNKNOWN

public static final int SE_DBMS_IS_UNKNOWN

Underlying RDBMS is unknown.

See Also:

Constant Field Values

SE_DBMS_IS_OTHER

public static final int SE_DBMS_IS_OTHER

Underlying RDBMS is other.

See Also:

Constant Field Values

SE_DBMS_IS_ORACLE

public static final int SE_DBMS_IS_ORACLE

Underlying RDBMS is oracle.

See Also:

Constant Field Values

SE_DBMS_IS_INFORMIX

public static final int SE_DBMS_IS_INFORMIX

Underlying RDBMS is informix.

See Also:

Constant Field Values

SE_DBMS_IS_SYBASE

public static final int SE_DBMS_IS_SYBASE

Underlying RDBMS is sybase.

See Also:

Constant Field Values

SE_DBMS_IS_DB2

public static final int SE_DBMS_IS_DB2

Underlying RDBMS is DB2.

See Also:

Constant Field Values

SE_DBMS_IS_SQLSERVER

public static final int SE_DBMS_IS_SQLSERVER

Underlying RDBMS is microsoft sqlserver.

See Also:

Constant Field Values

SE_DBMS_IS_ARCINFO

public static final int SE_DBMS_IS_ARCINFO

Underlying RDBMS is arcinfo.

See Also:

Constant Field Values

SE_DBMS_IS_IUS

public static final int SE_DBMS_IS_IUS

Underlying RDBMS is informix universal server.

See Also:

Constant Field Values

SE_DBMS_IS_DB2_EXT

public static final int SE_DBMS_IS_DB2_EXT

Underlying RDBMS is DB2 extended server.

See Also:

Constant Field Values

SE_DBMS_IS_ARCSERVER

public static final int SE_DBMS_IS_ARCSERVER

Underlying RDBMS is arcserver.

See Also:

Constant Field Values

SE_DBMS_IS_JET

public static final int SE_DBMS_IS_JET

Underlying RDBMS is jet.

See Also:

Constant Field Values

SE_DBMS_IS_POSTGRESQL

public static final int SE_DBMS_IS_POSTGRESQL

Underlying RDBMS is PostgreSQL.

See Also:

Constant Field Values

SE_DBMS_IS_DB2ZOS

public static final int SE_DBMS_IS_DB2ZOS

Underlying RDBMS is DB2ZOS.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_UPPERCASE

public static final int SE_DBMS_FUNCTION_UPPERCASE

Id of the function that converts string to upper case.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LOWERCASE

public static final int SE_DBMS_FUNCTION_LOWERCASE

Id of the function that converts string to lower case.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_CONCAT

public static final int SE_DBMS_FUNCTION_CONCAT

Id of the function that will concatenate string1 with string2.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_ASCII

public static final int SE_DBMS_FUNCTION_ASCII

Id of the function that will return decimal representation of a string.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LENGTH

public static final int SE_DBMS_FUNCTION_LENGTH

Id of the function that will return length in char.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LENGTHB

public static final int SE_DBMS_FUNCTION_LENGTHB

Id of the function that will return length in bytes.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_CHR

public static final int SE_DBMS_FUNCTION_CHR

Id of the function that will return the character of the binary equivalent.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LTRIM

public static final int SE_DBMS_FUNCTION_LTRIM

Id of the function that will remove spaces from the left.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_RTRIM

public static final int SE_DBMS_FUNCTION_RTRIM

Id of the function that will remove trailing from the right.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SUBSTR

public static final int SE_DBMS_FUNCTION_SUBSTR

Id of the function that will return a portion of a string.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SUBSTRB

public static final int SE_DBMS_FUNCTION_SUBSTRB

Id of the function that will return a portion of bytes.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SOUNDEX

public static final int SE_DBMS_FUNCTION_SOUNDEX

Id of the function that will return a string containing the phonetic representation of string2.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_TRANSLATE

public static final int SE_DBMS_FUNCTION_TRANSLATE

Id of the function that will return string with each char in 'from' string replaced by its corresponding char in 'to' string.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_TRIM

public static final int SE_DBMS_FUNCTION_TRIM

Id of the function that will strip the leading, trailing * or both from the string.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_CEIL

public static final int SE_DBMS_FUNCTION_CEIL

Id of the function that will return smallest integer >= n.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_FLOOR

public static final int SE_DBMS_FUNCTION_FLOOR

Id of the function that will return largest integer <= n.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_ROUND

public static final int SE_DBMS_FUNCTION_ROUND

Id of the function that will round a real nember to specified decimal digits.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LN

public static final int SE_DBMS_FUNCTION_LN

Id of the function that will return natural logarithm.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LOG10

public static final int SE_DBMS_FUNCTION_LOG10

Id of the function that will return logarithm of base 10.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_LOG

public static final int SE_DBMS_FUNCTION_LOG

Id of the function that will return logarithm of base n.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_MOD

public static final int SE_DBMS_FUNCTION_MOD

Id of the function that will return the remainder.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_POWER

public static final int SE_DBMS_FUNCTION_POWER

Id of the function that will return the n power of m.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SIGN

public static final int SE_DBMS_FUNCTION_SIGN

Id of the function that will return -1 for negative, 0 for zero and 1 for positive.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_TRUNC

public static final int SE_DBMS_FUNCTION_TRUNC

Id of the function that will truncate n to m decimal place.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SINH

public static final int SE_DBMS_FUNCTION_SINH

Id of the function that will return hyperbolic sine of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_COSH

public static final int SE_DBMS_FUNCTION_COSH

Id of the function that will return hyperbolic cosine of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_TANH

public static final int SE_DBMS_FUNCTION_TANH

Id of the function that will return hyperbolic tangent of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_ASIN

public static final int SE_DBMS_FUNCTION_ASIN

Id of the function that will return the arcsine of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_ACOS

public static final int SE_DBMS_FUNCTION_ACOS

Id of the function that will return the arccosine of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_ATAN

public static final int SE_DBMS_FUNCTION_ATAN

Id of the function that will return the arctangent of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_HEX

public static final int SE_DBMS_FUNCTION_HEX

Id of the function that will return the hexadecimal representation of a number.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SIN

public static final int SE_DBMS_FUNCTION_SIN

Id of the function that will return sine of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_COS

public static final int SE_DBMS_FUNCTION_COS

Id of the function that will return cosine of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_TAN

public static final int SE_DBMS_FUNCTION_TAN

Id of the function that will return tangent of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_EXTRACT

public static final int SE_DBMS_FUNCTION_EXTRACT

Id of the function that will return a numeric value of a date.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_BITLEN

public static final int SE_DBMS_FUNCTION_BITLEN

Id of the function that will return the string length in bits.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_POSITION

public static final int SE_DBMS_FUNCTION_POSITION

Id of the function that will return a numeric value that indicates the starting position of the search string in the source string.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_ABS

public static final int SE_DBMS_FUNCTION_ABS

Id of the function that will return the absolute value of x.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_VARIANCE

public static final int SE_DBMS_FUNCTION_VARIANCE

Id of the function that will calculate the variance.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_STDDEV

public static final int SE_DBMS_FUNCTION_STDDEV

Id of the function that will calculate the standard deviation.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_AVG

public static final int SE_DBMS_FUNCTION_AVG

Id of the function that will return the average value of n.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_COUNT

public static final int SE_DBMS_FUNCTION_COUNT

Id of the function that will return the number of rows in the query.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_MAX

public static final int SE_DBMS_FUNCTION_MAX

Id of the function that will return the maximum value of expression.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_MIN

public static final int SE_DBMS_FUNCTION_MIN

Id of the function that will return the minimum value of expression.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_SUM

public static final int SE_DBMS_FUNCTION_SUM

Id of the function that will return the sum of values of n numbers.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_COALSCE

public static final int SE_DBMS_FUNCTION_COALSCE

Id of the function that will return the first NOT_NULL value.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_CONVERT

public static final int SE_DBMS_FUNCTION_CONVERT

Id of the convert function.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_CAST

public static final int SE_DBMS_FUNCTION_CAST

Id of the function that converts one data type to another one.

See Also:

Constant Field Values

SE_DBMS_FUNCTION_USER

public static final int SE_DBMS_FUNCTION_USER

Id of the function that will return the current user name

See Also:

Constant Field Values