Skip to main content

Getting Objects in a Catalog

  • Updated

Previous Topic  Next Topic

Getting Objects in a Catalog

The following are methods to get objects into a catalog:

  • getTables(String dataSourceName)
    Gets tables, views and synonyms in a connection and returns the mapping name array.
  • getTables(boolean bIncludeSystemTable)
    Gets tables, views and synonyms in a data source and returns the name array.
  • getProcedureNames(String dataSourceName)
    Gets all the stored procedures in a catalog and to return the mapping name array.
  • getSQLs(String dataSourceName)
    Gets all the SQL files in a catalog and to return the mapping name array.
  • getUDSs(String dataSourceName)
    Gets all the UDSs in a catalog and to return the mapping name array.
  • getQueries(String dataSourceName)
    Gets queries in a catalog and returns the mapping name array.
  • getNewQueryName()
    Gets a default name for a new query, which must be unique. The name for the first query in a catalog is query1. The following query is query2, then query3 and so on.
  • getSQLString(String dataSourceName, String queryName)
    Gets the sql statement text of a query or an imported SQL and returns the SQL statement string.
  • getImportedSQLString(String dataSourceName, String importedSQLName)
    Gets the original SQL statement of an imported SQL and returns the original SQL statement string.
  • getColumns(String dataSourceName, String queryName, boolean allColumns)
    Gets columns in a query and returns the table name and column real names.
  • getColumnMappingnames(String dataSourceName, String queryName)
    Gets column mapping names in a query and returns the table name and column mapping names.
  • getColumnsCanBeGroupedBy(String dataSourceName, String queryName)
    Gets the columns which can be grouped by in a query.
  • getDBFields(String dataSourceName, String qryName)
    Gets DBFields that can be used in a query and returns the mapping name array.
  • getMappingnames(String dataSourceName, String DSName)
    Gets the field mapping names in a data source and returns the table name and column mapping names.
  • getFormulae(String dataSourceName)
    Gets formulae that can be used in a catalog and returns the mapping name array.
  • getFormulaeCanBeGroupedBy(String dataSourceName, String queryName, String groupBy)
    Gets formulae that are valid to a query and returns the formula names.
  • getSummaries(String dataSourceName)
    Gets summaries that can be used in a catalog and returns the mapping name array.
  • getSummaryCanBeSortedBy(String dataSourceName, String queryName, String groupBy)
    Gets summaries that can be sorted by.
  • getParameter(String dataSourceName)
    Gets parameters in a catalog and returns the mapping name array.
  • getParameterCanBeGroupedBy(String dataSourceName)
    Gets parameters that can be grouped by.
  • getJoins(String dataSourceName, String queryName)
    Gets joins in a query and returns the join info array.

    Note: String[i][0] = Table "From" Name, String[i][1] = Column "From" Name, String[i][2] = Table "To" Name, String[i][3] = Column "To" Name

  • getAndConditions(String dataSourceName, String queryName)
    Gets AND conditions in a query and returns a condition info array.

    Note: String[i][0] = "Logic", String[i][1] = "Expression1" String[i][2] = "Operator", String[i][3] = "Expression2"

  • getQBEInfo(String dataSourceName, String queryName)
    Gets the QBE condition in a query and returns a QBE info array.

    Note: String[i][0] = column Name, String[i][j](j>=1) = condition expression of this column.

  • getNewReportName()
    Gets a default name for a new report, which must be unique. The name for the first report in a catalog is report1, after which the following reports will be named report2, report3 and so on.

Parameters

  • dataSourceName - The mapping name of the data source in the catalog.
  • queryName - The mapping name of the query.
  • qryName - The query name.
  • importedSQLName - The mapping name of the imported SQL.
  • allColumns - Selects all columns in the specified tables.
  • DSName - The data source object name, such as Query, SQL, UDS, and Procedure.
  • groupBy - The groupBy field.

Previous Topic  Next Topic

Related articles