| 
 | ||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.eclipse.datatools.sqltools.sqlbuilder.model.FunctionHelper
org.eclipse.datatools.sqltools.sqlbuilder.model.FunctionHelperDB2
public class FunctionHelperDB2
This class describes the functions supported by DB2. It provides services to get lists of function names in various categories, plus function signature information for functions.
| Field Summary | |
|---|---|
| static java.lang.String | CAT_LABEL_DATALINK_FUNCTIONSDatalink functions category label. | 
| static java.lang.String | CAT_LABEL_DB2_FUNCTIONSMiscellaneous special DB2 functions category label. | 
| static java.lang.String | CAT_LABEL_MMDB_EXTENDER_FUNCTIONSMulti-Media Database Extender category functions. | 
| static java.lang.String | CAT_LABEL_MQ_EXTENDER_FUNCTIONSMessage Queue (MQSeries) Extender functions category label. | 
| static java.lang.String | CAT_LABEL_SQLXML_FUNCTIONSXML functions category label. | 
| static java.lang.String | CAT_LABEL_TEXT_EXTENDER_FUNCTIONSText Extender category functions. | 
| Fields inherited from class org.eclipse.datatools.sqltools.sqlbuilder.model.FunctionHelper | 
|---|
| ALL_LOCATION_BOTTOM, ALL_LOCATION_OMITTED, ALL_LOCATION_SORTED, ALL_LOCATION_TOP, CAT_LABEL_AGGREGATE_FUNCTIONS, CAT_LABEL_ALL_FUNCTIONS, CAT_LABEL_CONVERSION_FUNCTIONS, CAT_LABEL_DATETIME_FUNCTIONS, CAT_LABEL_NUMERIC_FUNCTIONS, CAT_LABEL_SCALAR_FUNCTIONS, CAT_LABEL_SPECIAL_REGISTERS, CAT_LABEL_STRING_FUNCTIONS, CAT_LABEL_USER_DEFINED_FUNCTIONS | 
| Constructor Summary | |
|---|---|
| FunctionHelperDB2(Database db)Constructs and instance of this class with an association to the given database. | |
| Method Summary | |
|---|---|
|  java.util.List | getBuiltinFunctionCategories()Gets a list of labels for the built-in function categories supported by the a ssociated database. | 
|  java.util.List | getDatalinkFunctionNames()Gets a list of names of the Datalink functions supported by the database. | 
|  java.util.List | getDB2FunctionNames()Gets a list of names of the special DB2 functions supported by the database. | 
|  java.util.List | getFunctionNames(java.lang.String category)Gets a list of function names supported by the associated database in the given function category. | 
|  java.util.List | getMMDBExtenderFunctionNames()Gets a list of the names of the MMDB Extender function supported by the database. | 
|  java.util.List | getMQExtenderFunctionNames()Gets a list of names of the MQSeries functions supported by the database. | 
|  java.util.List | getSQLXMLFunctionNames()Gets a list of the names of the SQL/XML function supported by the database. | 
|  java.util.List | getTextExtenderFunctionNames()Gets a list of the names of the Text Extender function supported by the database. | 
| Methods inherited from class org.eclipse.datatools.sqltools.sqlbuilder.model.FunctionHelper | 
|---|
| getAggregateFunctionNames, getAllBuiltinFunctionNames, getConversionFunctionNames, getDatabase, getDatetimeFunctionNames, getFunctionCategories, getFunctionSignatures, getInstance, getIsFunctionAllowingStar, getNumericFunctionNames, getScalarFunctionNames, getSpecialRegisterNames, getStringFunctionNames, getUserDefinedFunctionNames | 
| Methods inherited from class java.lang.Object | 
|---|
| equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait | 
| Field Detail | 
|---|
public static final java.lang.String CAT_LABEL_DATALINK_FUNCTIONS
public static final java.lang.String CAT_LABEL_DB2_FUNCTIONS
public static final java.lang.String CAT_LABEL_MMDB_EXTENDER_FUNCTIONS
public static final java.lang.String CAT_LABEL_MQ_EXTENDER_FUNCTIONS
public static final java.lang.String CAT_LABEL_SQLXML_FUNCTIONS
public static final java.lang.String CAT_LABEL_TEXT_EXTENDER_FUNCTIONS
| Constructor Detail | 
|---|
public FunctionHelperDB2(Database db)
db - the Database for which function help is needed| Method Detail | 
|---|
public java.util.List getBuiltinFunctionCategories()
public java.util.List getFunctionNames(java.lang.String category)
getFunctionNames in class FunctionHelpercategory - the function category for which functions are needed
public java.util.List getDatalinkFunctionNames()
public java.util.List getDB2FunctionNames()
public java.util.List getMMDBExtenderFunctionNames()
public java.util.List getMQExtenderFunctionNames()
public java.util.List getSQLXMLFunctionNames()
public java.util.List getTextExtenderFunctionNames()
| 
 | ||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||