com.simba.dsi.dataengine.utilities
Class MetadataConstants

java.lang.Object
  extended by com.simba.dsi.dataengine.utilities.MetadataConstants

public class MetadataConstants
extends java.lang.Object

MetadataConstants provides a set of constants to be used as entries for some columns in catalog function result sets. The columns that use these entries are listed in IDataEngine.


Field Summary
static short AUTO_UNIQUE
          Indicates that the type for the associated row is auto-incrementing.
static short CASE_INSENSITIVE
          Indicates that the type for the associated row is case insensitive.
static short CASE_SENSITIVE
          Indicates that the type for the associated row is case sensitive.
static short DUPLICATES_ALLOWED
          Indicates that duplicates are permitted for an index.
static short DUPLICATES_DISALLOWED
          Indicates that duplicates are not permitted for an index.
static short INDEX_CLUSTERED
          Indicates that the statistics of the associated row are clustered index statistics.
static short INDEX_HASHED
          Indicates that the statistics of the associated row are hashed index statistics.
static short INDEX_OTHER
          Indicates that the statistics of the associated row are a different type of index statistics.
static short INITIALLY_DEFFERRED
          Indicates that the constraint is initially deferrable.
static short INITIALLY_IMMEDIATE
          Indicates that the constraint is not deferrable.
static short NOT_AUTO_UNIQUE
          Indicates that the type for the associated row is not auto-incrementing.
static short NOT_DEFFERRABLE
          Indicates that the it is unknown whether the constraint is deferrable.
static short NULLABLE_FALSE
          Indicates that the column may hold NULL values.
static short NULLABLE_TRUE
          Indicates that the column may hold NULL values.
static short NULLABLE_UNKNOWN
          Indicates that it is not known whether or not the column may hold NULL values.
static short PC_NON_PSEUDO
          Indicates that the column is not a pseudo column.
static short PC_PSEUDO
          Indicates that the column is a pseudo column.
static short PC_UNKNOWN
          Indicates that is unknown if the column is a pseudo column.
static short PCT_IN_PARAM
          Indicates that the procedure column is an IN parameter.
static short PCT_INOUT_PARAM
          Indicates that the procedure column is an INOUT parameter.
static short PCT_OUT_PARAM
          Indicates that the procedure column is an OUT parameter.
static short PCT_RESULT_COLUMN
          Indicates that the procedure column is a ResultSet column.
static short PCT_RETURN_VALUE
          Indicates that the procedure column is a return value.
static short PCT_UNKNOWN
          Indicates that the procedure column type is unknown.
static short PRECISION_SCALE_FIXED
          Indicates that the type for the associated row has a fixed precision and scale.
static short PRECISION_SCALE_NOT_FIXED
          Indicates that the type for the associated row does not have a fixed precision and scale.
static short PT_FUNCTION
          Indicates that the type of the procedure for the associated row is a function.
static short PT_PROCEDURE
          Indicates that the type of the procedure for the associated row is a stored procedure.
static short PT_UNKNOWN
          Indicates that the type of the procedure for the associated row is unknown.
static short SCOPE_CURROW
          Indicates that the row ID is only valid while positioned on that row.
static short SCOPE_SESSION
          Indicates that the row ID is valid for the duration of the current session.
static short SCOPE_TRANSACTION
          Indicates that the row ID is valid for the duration of the current transaction.
static short SEARCHABLE_ALL
          Indicates that the column may be used in a WHERE clause with any comparison operator.
static short SEARCHABLE_PRED_BASIC
          Indicates that the column may be used in a WHERE clause with all of the comparison operators except LIKE.
static short SEARCHABLE_PRED_CHAR
          Indicates that the column may be used in a WHERE clause only with the LIKE operator.
static short SEARCHABLE_PRED_NONE
          Indicates that the column may not be used in a WHERE clause.
static short SIGNED_TYPE
          Indicates that the type for the associated row is signed.
static short TABLE_STAT
          Indicates that the statistics of the associated row are table statistics.
static short UDT_STANDARD_SQL_TYPE
          Indicates that the data type is a standard SQL data type.
static short UNSIGNED_TYPE
          Indicates that the type for the associated row is unsigned.
 
Constructor Summary
MetadataConstants()
           
 
Method Summary
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

INITIALLY_DEFFERRED

public static final short INITIALLY_DEFFERRED
Indicates that the constraint is initially deferrable.

See Also:
Constant Field Values

INITIALLY_IMMEDIATE

public static final short INITIALLY_IMMEDIATE
Indicates that the constraint is not deferrable.

See Also:
Constant Field Values

NOT_DEFFERRABLE

public static final short NOT_DEFFERRABLE
Indicates that the it is unknown whether the constraint is deferrable.

See Also:
Constant Field Values

NULLABLE_FALSE

public static final short NULLABLE_FALSE
Indicates that the column may hold NULL values.

See Also:
Constant Field Values

NULLABLE_TRUE

public static final short NULLABLE_TRUE
Indicates that the column may hold NULL values.

See Also:
Constant Field Values

NULLABLE_UNKNOWN

public static final short NULLABLE_UNKNOWN
Indicates that it is not known whether or not the column may hold NULL values.

See Also:
Constant Field Values

SCOPE_CURROW

public static final short SCOPE_CURROW
Indicates that the row ID is only valid while positioned on that row.

See Also:
Constant Field Values

SCOPE_TRANSACTION

public static final short SCOPE_TRANSACTION
Indicates that the row ID is valid for the duration of the current transaction.

See Also:
Constant Field Values

SCOPE_SESSION

public static final short SCOPE_SESSION
Indicates that the row ID is valid for the duration of the current session.

See Also:
Constant Field Values

PC_UNKNOWN

public static final short PC_UNKNOWN
Indicates that is unknown if the column is a pseudo column.

See Also:
Constant Field Values

PC_NON_PSEUDO

public static final short PC_NON_PSEUDO
Indicates that the column is not a pseudo column.

See Also:
Constant Field Values

PC_PSEUDO

public static final short PC_PSEUDO
Indicates that the column is a pseudo column.

See Also:
Constant Field Values

DUPLICATES_ALLOWED

public static final short DUPLICATES_ALLOWED
Indicates that duplicates are permitted for an index.

See Also:
Constant Field Values

DUPLICATES_DISALLOWED

public static final short DUPLICATES_DISALLOWED
Indicates that duplicates are not permitted for an index.

See Also:
Constant Field Values

TABLE_STAT

public static final short TABLE_STAT
Indicates that the statistics of the associated row are table statistics.

See Also:
Constant Field Values

INDEX_CLUSTERED

public static final short INDEX_CLUSTERED
Indicates that the statistics of the associated row are clustered index statistics.

See Also:
Constant Field Values

INDEX_HASHED

public static final short INDEX_HASHED
Indicates that the statistics of the associated row are hashed index statistics.

See Also:
Constant Field Values

INDEX_OTHER

public static final short INDEX_OTHER
Indicates that the statistics of the associated row are a different type of index statistics.

See Also:
Constant Field Values

PT_UNKNOWN

public static final short PT_UNKNOWN
Indicates that the type of the procedure for the associated row is unknown.

See Also:
Constant Field Values

PT_PROCEDURE

public static final short PT_PROCEDURE
Indicates that the type of the procedure for the associated row is a stored procedure.

See Also:
Constant Field Values

PT_FUNCTION

public static final short PT_FUNCTION
Indicates that the type of the procedure for the associated row is a function.

See Also:
Constant Field Values

PCT_IN_PARAM

public static final short PCT_IN_PARAM
Indicates that the procedure column is an IN parameter.

See Also:
Constant Field Values

PCT_INOUT_PARAM

public static final short PCT_INOUT_PARAM
Indicates that the procedure column is an INOUT parameter.

See Also:
Constant Field Values

PCT_OUT_PARAM

public static final short PCT_OUT_PARAM
Indicates that the procedure column is an OUT parameter.

See Also:
Constant Field Values

PCT_RESULT_COLUMN

public static final short PCT_RESULT_COLUMN
Indicates that the procedure column is a ResultSet column.

See Also:
Constant Field Values

PCT_RETURN_VALUE

public static final short PCT_RETURN_VALUE
Indicates that the procedure column is a return value.

See Also:
Constant Field Values

PCT_UNKNOWN

public static final short PCT_UNKNOWN
Indicates that the procedure column type is unknown.

See Also:
Constant Field Values

CASE_SENSITIVE

public static final short CASE_SENSITIVE
Indicates that the type for the associated row is case sensitive.

See Also:
Constant Field Values

CASE_INSENSITIVE

public static final short CASE_INSENSITIVE
Indicates that the type for the associated row is case insensitive.

See Also:
Constant Field Values

SEARCHABLE_PRED_NONE

public static final short SEARCHABLE_PRED_NONE
Indicates that the column may not be used in a WHERE clause.

See Also:
Constant Field Values

SEARCHABLE_PRED_BASIC

public static final short SEARCHABLE_PRED_BASIC
Indicates that the column may be used in a WHERE clause with all of the comparison operators except LIKE.

See Also:
Constant Field Values

SEARCHABLE_PRED_CHAR

public static final short SEARCHABLE_PRED_CHAR
Indicates that the column may be used in a WHERE clause only with the LIKE operator.

See Also:
Constant Field Values

SEARCHABLE_ALL

public static final short SEARCHABLE_ALL
Indicates that the column may be used in a WHERE clause with any comparison operator.

See Also:
Constant Field Values

UNSIGNED_TYPE

public static final short UNSIGNED_TYPE
Indicates that the type for the associated row is unsigned.

See Also:
Constant Field Values

SIGNED_TYPE

public static final short SIGNED_TYPE
Indicates that the type for the associated row is signed.

See Also:
Constant Field Values

PRECISION_SCALE_FIXED

public static final short PRECISION_SCALE_FIXED
Indicates that the type for the associated row has a fixed precision and scale.

See Also:
Constant Field Values

PRECISION_SCALE_NOT_FIXED

public static final short PRECISION_SCALE_NOT_FIXED
Indicates that the type for the associated row does not have a fixed precision and scale.

See Also:
Constant Field Values

AUTO_UNIQUE

public static final short AUTO_UNIQUE
Indicates that the type for the associated row is auto-incrementing.

See Also:
Constant Field Values

NOT_AUTO_UNIQUE

public static final short NOT_AUTO_UNIQUE
Indicates that the type for the associated row is not auto-incrementing.

See Also:
Constant Field Values

UDT_STANDARD_SQL_TYPE

public static final short UDT_STANDARD_SQL_TYPE
Indicates that the data type is a standard SQL data type.

See Also:
Constant Field Values
Constructor Detail

MetadataConstants

public MetadataConstants()


Copyright © 2006-2014 Simba Technologies Incorporated. All Rights Reserved.