com.esri.arcgis.geoprocessing.tools.datamanagementtools
Class MakeQueryTable

java.lang.Object
  com.esri.arcgis.geoprocessing.AbstractGPTool
      com.esri.arcgis.geoprocessing.tools.datamanagementtools.MakeQueryTable

All Implemented Interfaces:

GPTool

public class MakeQueryTable
extends AbstractGPTool

The Make Query Table tool applies an SQL The Make Query Table tool is contained in the Data Management Tools tool box.

Software restrictions: none

Usage tips:

• All input feature classes or tables must be from the same input workspace;
• If a Shape column is added to the field list, the result is a layer; otherwise, it is a table view.
• If the output result is a layer, it may be persisted to a layer file using the Save To Layer File; tool or to a feature class; using the Copy Features; tool.
• The order of the fields in the field list indicates the order the fields will appear in the output layer or table view.
• The tool allows you to provide a key field option and key fields list. This information defines how rows are uniquely identified and is used to add a dynamically generated ObjectID column to the data. Without an ObjectID column, selections will not be supported.
• The key fields list lets you choose several columns if the combination of these columns is needed to define unique values.
• If an SQL expression is used but returns nothing, the output feature class will be empty.
• Feature classes can be joined, but the fields list must contain at most one field of type geometry. If you add more than one geometry column, the tool will error when you click OK.
• For details on the syntax for the Expression parameter, see Building an SQL Expression; or SQL Reference;
• The Fields and Key Fields parameters' Add Field button is used only in ModelBuilder. In ModelBuilder, where the preceding tool has not been run, or its derived data does not exist, the Fields and Key Fields parameters may not be populated with field names. The Add Field button allows you to add expected field(s) so you can complete the Make Query Table dialog and continue to build your model.
• When input tables are from a file geodatabase, tables generally join in the order listed in the Input Tables parameter. For example, if Table1 is listed before Table2, Table2 will be joined by getting a row from Table1, then getting matching rows from Table2. However, if this would result in querying Table2 on an un-indexed field, and reversing the order would result in querying Table1 on a indexed field, the order will be reversed in an attempt to maximize performance. This is the sole query optimization logic at work when you're using file geodatabase data with this tool. In general, joins in file geodatabases perform best when they are one-to-many and one-to-one.
• Examples of using the Make Query Table tool;
• The following environment settings affect this tool: workspace; scratch workspace; Extent; M Domain; Configuration keyword; Coordinate system; Output has M values; Output spatial grid; Output has Z values; Default Z value; Output XY domain; , and Output Z domain;

Field Summary

Fields inherited from class com.esri.arcgis.geoprocessing.AbstractGPTool

vals

Constructor Summary

MakeQueryTable()
Creates the Make Query Table tool with defaults.

MakeQueryTable(Object inTable, Object outTable, String inKeyFieldOption)
Creates the Make Query Table tool with the required parameters.

Method Summary

Object	getInField() Returns the Fields parameter of this tool .
Object	getInKeyField() Returns the Key Fields parameter of this tool .
String	getInKeyFieldOption() Returns the Key Field Options parameter of this tool .
Object	getInTable() Returns the Input Tables parameter of this tool .
Object	getOutTable() Returns the Table Name parameter of this tool .
String	getToolboxAlias() Returns the alias of the tool box containing this tool.
String	getToolboxName() Returns the name of the tool box containing this tool.
String	getToolName() Returns the name of this tool.
Object	getWhereClause() Returns the Expression parameter of this tool .
void	setInField(Object inField) Sets the Fields parameter of this tool .
void	setInKeyField(Object inKeyField) Sets the Key Fields parameter of this tool .
void	setInKeyFieldOption(String inKeyFieldOption) Sets the Key Field Options parameter of this tool .
void	setInTable(Object inTable) Sets the Input Tables parameter of this tool .
void	setOutTable(Object outTable) Sets the Table Name parameter of this tool .
void	setWhereClause(Object whereClause) Sets the Expression parameter of this tool .

Methods inherited from class com.esri.arcgis.geoprocessing.AbstractGPTool

getParameterValues, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

MakeQueryTable

public MakeQueryTable()

Creates the Make Query Table tool with defaults.

Initializes the array of tool parameters with the default values specified when the tool was created.

MakeQueryTable

public MakeQueryTable(Object inTable,
                      Object outTable,
                      String inKeyFieldOption)

Creates the Make Query Table tool with the required parameters.

Initializes the array of tool parameters with the values as specified for the required parameters and with the default values for the other parameters.

Parameters:

inTable - Table View | Raster Layer, the input table can be from an ArcSDE geodatabase, a file geodatabase, a personal geodatabase or an OLE DB connection.

outTable - Table View | Raster Layer, the name of the layer or table view that will be created by the tool.

inKeyFieldOption - String, indicates how an ObjectID field will be generated, if at all, for the query. The default is USE_KEY_FIELDS.

Method Detail

getInTable

public Object getInTable()

Returns the Input Tables parameter of this tool . This parameter is Table View | Raster Layer, the input table can be from an ArcSDE geodatabase, a file geodatabase, a personal geodatabase or an OLE DB connection. This is a required parameter.

Returns:

the Input Tables

setInTable

public void setInTable(Object inTable)

Sets the Input Tables parameter of this tool . This parameter is Table View | Raster Layer, the input table can be from an ArcSDE geodatabase, a file geodatabase, a personal geodatabase or an OLE DB connection. This is a required parameter.

Parameters:

inTable - Table View | Raster Layer, the input table can be from an ArcSDE geodatabase, a file geodatabase, a personal geodatabase or an OLE DB connection.

getOutTable

public Object getOutTable()

Returns the Table Name parameter of this tool . This parameter is Table View | Raster Layer, the name of the layer or table view that will be created by the tool. This is a required parameter.

Returns:

the Table Name

setOutTable

public void setOutTable(Object outTable)

Sets the Table Name parameter of this tool . This parameter is Table View | Raster Layer, the name of the layer or table view that will be created by the tool. This is a required parameter.

Parameters:

outTable - Table View | Raster Layer, the name of the layer or table view that will be created by the tool.

getInKeyFieldOption

public String getInKeyFieldOption()

Returns the Key Field Options parameter of this tool . This parameter is String, indicates how an ObjectID field will be generated, if at all, for the query. The default is USE_KEY_FIELDS. This is a required parameter.

Returns:

the Key Field Options

setInKeyFieldOption

public void setInKeyFieldOption(String inKeyFieldOption)

Sets the Key Field Options parameter of this tool . This parameter is String, indicates how an ObjectID field will be generated, if at all, for the query. The default is USE_KEY_FIELDS. This is a required parameter.

Parameters:

inKeyFieldOption - String, indicates how an ObjectID field will be generated, if at all, for the query. The default is USE_KEY_FIELDS.

getInKeyField

public Object getInKeyField()

Returns the Key Fields parameter of this tool . This parameter is Field, the Add Field button, which is used only in ModelBuilder, allows you to add expected field(s) so you can complete the dialog and continue to build your model. This is an optional parameter.

Returns:

the Key Fields

setInKeyField

public void setInKeyField(Object inKeyField)

Sets the Key Fields parameter of this tool . This parameter is Field, the Add Field button, which is used only in ModelBuilder, allows you to add expected field(s) so you can complete the dialog and continue to build your model. This is an optional parameter.

Parameters:

inKeyField - Field, the Add Field button, which is used only in ModelBuilder, allows you to add expected field(s) so you can complete the dialog and continue to build your model.

getInField

public Object getInField()

Returns the Fields parameter of this tool . This parameter is String, the fields to include in the layer or table view. If an alias is set for a field, this is the name that appears. If no fields are specified, all fields from all tables are included. This is an optional parameter.

Returns:

the Fields

setInField

public void setInField(Object inField)

Sets the Fields parameter of this tool . This parameter is String, the fields to include in the layer or table view. If an alias is set for a field, this is the name that appears. If no fields are specified, all fields from all tables are included. This is an optional parameter.

Parameters:

inField - String, the fields to include in the layer or table view. If an alias is set for a field, this is the name that appears. If no fields are specified, all fields from all tables are included.

getWhereClause

public Object getWhereClause()

Returns the Expression parameter of this tool . This parameter is SQL Expression, for more information on SQL syntax and how it differs between data sources, see This is an optional parameter.

Returns:

the Expression

setWhereClause

public void setWhereClause(Object whereClause)

Sets the Expression parameter of this tool . This parameter is SQL Expression, for more information on SQL syntax and how it differs between data sources, see This is an optional parameter.

Parameters:

whereClause - SQL Expression, for more information on SQL syntax and how it differs between data sources, see

getToolName

public String getToolName()

Returns the name of this tool.

Returns:

the tool name

getToolboxName

public String getToolboxName()

Returns the name of the tool box containing this tool.

Returns:

the tool box name

getToolboxAlias

public String getToolboxAlias()

Returns the alias of the tool box containing this tool.

Returns:

the tool box alias