TupleInfo (trafodion-sql 2.1.0 API)

java.lang.Object
+
- org.trafodion.sql.udr.TMUDRSerializableObject
- +
  - org.trafodion.sql.udr.TupleInfo
  +
+

+
+
Direct Known Subclasses:
+
ParameterListInfo, TableInfo
+
+
+
+
```
public class TupleInfo
+extends TMUDRSerializableObject
```
+
Common base class for parameter lists and row layouts + +
Describes a list of scalars, which could be columns of a table + or a parameter list
+

+ +

Method Summary

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Methods
Modifier and Type	Method and Description
`void`	`addCharColumn(String colName, + int length, + boolean isNullable)` + Add a fixed character output column with UTF8 charset and SYSTEM_COLLATION +
`void`	`addCharColumn(String colName, + int length, + boolean isNullable, + TypeInfo.SQLCharsetCode charset, + TypeInfo.SQLCollationCode collation)` + Add a fixed character output column. +
`void`	`addColumn(ColumnInfo column)` + Add a new column. +
`void`	`addColumnAt(ColumnInfo column, + int position)` + Add a new column at a specified position. +
`void`	`addColumns(Vector<ColumnInfo> columns)` + Add multiple columns to the table-valued output. +
`void`	`addIntColumn(String colName, + boolean isNullable)` + Add an integer output column. +
`void`	`addLongColumn(String colName, + boolean isNullable)` + Add a long output column. +
`void`	`addVarCharColumn(String colName, + int length, + boolean isNullable)` + Add a VARCHAR output column with UTF8 charset and SYSTEM_COLLATION +
`void`	`addVarCharColumn(String colName, + int length, + boolean isNullable, + TypeInfo.SQLCharsetCode charset, + TypeInfo.SQLCollationCode collation)` + Add a VARCHAR output column. +
`void`	`deleteColumn(int i)` + Delete a column of the table-valued output. +
`void`	`deleteColumn(String name)` + Delete a column with a specified column name. +
`boolean`	`getBoolean(int colNum)` + Get a boolean value of a column or parameter +
`boolean`	`getBoolean(String colName)` + Get a boolean value of a column or parameter identified by name. +
`int`	`getColNum(String colName)` + Look up a column/parameter number by name. +
`ColumnInfo`	`getColumn(int colNum)` + Get the column info for a column identified by its ordinal. +
`ColumnInfo`	`getColumn(String colName)` + Get the column info for a column identified by its name. +
`String`	`getDelimitedRow()` + Get all columns of a row as a delimited string, with '\|' as field delimiter +
`String`	`getDelimitedRow(char delim, + boolean quote, + char quoteSymbol, + int firstColumn, + int lastColumn)` + Get columns of a row as a delimited string. +
`double`	`getDouble(int colNum)` + Get a double value of a column or parameter + + This method is modeled after the JDBC interface. +
`double`	`getDouble(String colName)` + Get double value of a column/parameter identified by name. +
`int`	`getInt(int colNum)` + Get an integer value of a column or parameter +
`int`	`getInt(String colName)` + Get an integer value for a column identified by name. +
`long`	`getLong(int colNum)` + Get a long value of a column or parameter +
`long`	`getLong(String colName)` + Get a long value for a column identified by name. +
`int`	`getNumColumns()` + Get the number of columns or parameters. +
`TypeInfo.SQLTypeClassCode`	`getSQLTypeClass(int colNum)` + Get the SQL type class. +
`String`	`getString(int colNum)` + Get a string value of a column or parameter +
`String`	`getString(String colName)` + Get a string value of a column or parameter identified by name. +
`Date`	`getTime(int colNum)` + Get a datetime or interval column value as time_t +
`TypeInfo`	`getType(int colNum)` + Get the type of a column. +
`boolean`	`isAvailable(int colNum)` + Check whether a parameter is available at compile-time. +
`void`	`print()` + Print the object, for use in debugging. +
`void`	`setDouble(int colNum, + double val)` + Set an output column to a specified double value. +
`int`	`setFromDelimitedRow(String row)` + Set the result row from a string with delimited field values. +
`int`	`setFromDelimitedRow(String row, + char delim, + boolean quote, + char quoteSymbol, + int firstColumnToSet, + int lastColumnToSet, + int numDelimColsToSkip)` + Set the result row from a string with delimited field values. +
`void`	`setInt(int colNum, + int val)` + Set an output column to a specified integer value. +
`void`	`setLong(int colNum, + long val)` + Set an output column to a specified long value. +
`void`	`setNull(int colNum)` + Set an output column to a NULL value. +
`void`	`setString(int colNum, + String val)` + Set an output column to a specified string value. +
`void`	`setTime(int colNum, + Date val)` + Set a datetime or interval output column to a value specified as Date +
`boolean`	`wasNull()` + Check whether the last value returned from a getInt() etc. +

+ + +
Methods inherited from class java.lang.Object
+equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

+ +
- + + +
  Method Detail
  + + + +
  - +
    getNumColumns
    +
```
public int getNumColumns()
```
    +
    Get the number of columns or parameters.
    +
    Returns:
    Number of columns/parameters.
    +
  + + + +
  - +
    getColNum
    +
```
public int getColNum(String colName)
+              throws UDRException
```
    +
    Look up a column/parameter number by name.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    Column/parameter number.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getColumn
    +
```
public ColumnInfo getColumn(int colNum)
+                     throws UDRException
```
    +
    Get the column info for a column identified by its ordinal.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    Column info.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getColumn
    +
```
public ColumnInfo getColumn(String colName)
+                     throws UDRException
```
    +
    Get the column info for a column identified by its name.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    Column info.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getType
    +
```
public TypeInfo getType(int colNum)
+                 throws UDRException
```
    +
    Get the type of a column.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    Type of the column.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getSQLTypeClass
    +
```
public TypeInfo.SQLTypeClassCode getSQLTypeClass(int colNum)
+                                          throws UDRException
```
    +
    Get the SQL type class. + Determine whether this is a numeric character, datetime or interval type.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    SQL type class enum.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getInt
    +
```
public int getInt(int colNum)
+           throws UDRException
```
    +
    Get an integer value of a column or parameter + +
    This method is modeled after the JDBC interface. + +
    Use this method at runtime. It can also be used for + actual parameters that are available at compile time.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    Integer value. + If the value was a NULL value, then 0 is returned. + The wasNull() method can be used to determine whether + a NULL value was returned.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getInt
    +
```
public int getInt(String colName)
+           throws UDRException
```
    +
    Get an integer value for a column identified by name.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    Integer value. + If the value was a NULL value, then 0 is returned. + The wasNull() method can be used to determine whether + a NULL value was returned.
    +
    Throws:
    +
    UDRException
    See Also:
    const
    +
  + + + +
  - +
    getLong
    +
```
public long getLong(int colNum)
+             throws UDRException
```
    +
    Get a long value of a column or parameter + +
    This method is modeled after the JDBC interface. + +
    Use this method at runtime. It can also be used for + actual parameters that are available at compile time.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    long value. + If the value was a NULL value, then 0 is returned. + The wasNull() method can be used to determine whether + a NULL value was returned.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getLong
    +
```
public long getLong(String colName)
+             throws UDRException
```
    +
    Get a long value for a column identified by name.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    long value.
    +
    Throws:
    +
    UDRException
    See Also:
    const
    +
  + + + +
  - +
    getDouble
    +
```
public double getDouble(int colNum)
+                 throws UDRException
```
    +
    Get a double value of a column or parameter + + This method is modeled after the JDBC interface. + + Use this method at runtime. It can also be used for + actual parameters that are available at compile time.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    double value.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getDouble
    +
```
public double getDouble(String colName)
+                 throws UDRException
```
    +
    Get double value of a column/parameter identified by name.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    double value.
    +
    Throws:
    +
    UDRException
    See Also:
    const
    +
  + + + +
  - +
    getString
    +
```
public String getString(int colNum)
+                 throws UDRException
```
    +
    Get a string value of a column or parameter + +
    This method is modeled after the JDBC interface. + +
    Use this method at runtime. It can also be used for + actual parameters that are available at compile time.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    String value. + If the value was a NULL value, an empty string + is returned. The wasNull() method can be used to + determine whether a NULL value was returned.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getString
    +
```
public String getString(String colName)
+                 throws UDRException
```
    +
    Get a string value of a column or parameter identified by name. + +
    This method is modeled after the JDBC interface. + +
    Use this method at runtime. It cannot be used for + actual parameters that are available at compile time, use + getString(int colNum) instead, since actual parameters are not named.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    String value. + If the value was a NULL value, an empty string + is returned. The wasNull() method can be used to + determine whether a NULL value was returned.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getBoolean
    +
```
public boolean getBoolean(int colNum)
+                   throws UDRException
```
    +
    Get a boolean value of a column or parameter + +
    This method is modeled after the JDBC interface. + It can be used on boolean, numeric and character columns. + Numeric columns need to have a value of 0 (false) or 1 (true), + character columns need to have a value of "0" (false) or "1" (true). + +
    Use this method at runtime. It can also be used for + actual parameters that are available at compile time.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    Boolean value. + If the value was a NULL value, false + is returned. The wasNull() method can be used to + determine whether a NULL value was returned.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getBoolean
    +
```
public boolean getBoolean(String colName)
+                   throws UDRException
```
    +
    Get a boolean value of a column or parameter identified by name. + +
    This method is modeled after the JDBC interface. + It can be used on boolean, numeric and character columns. + Numeric columns need to have a value of 0 (false) or 1 (true), + character columns need to have a value of "0" (false) or "1" (true). + +
    Use this method at runtime. It cannot be used for + actual parameters that are available at compile time, use + getString(int colNum) instead, since actual parameters are not named.
    +
    Parameters:
    colName - Name of an existing column.
    +
    Returns:
    Boolean value. + If the value was a NULL value, false + is returned. The wasNull() method can be used to + determine whether a NULL value was returned.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getTime
    +
```
public Date getTime(int colNum)
+             throws UDRException
```
    +
    Get a datetime or interval column value as time_t + +
    This method can be used to convert column values with + a datetime type or a day-second interval type to the + POSIX type time_t. Note that this may result in the loss + of fractional seconds. + +
    Use this method at runtime. It can also be used for + actual parameters that are available at compile time.
    +
    Parameters:
    colNum - Column number.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    isAvailable
    +
```
public boolean isAvailable(int colNum)
+                    throws UDRException
```
    +
    Check whether a parameter is available at compile-time. + +
    Use this method to check in the compiler interfaces whether + an actual parameter is a constant value that can be read + at compile time. If this method returns true, the value + can be accessed with the getInt(), getString() etc. methods.
    +
    Parameters:
    colNum - Column number.
    +
    Returns:
    true if the parameter value is available.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    getDelimitedRow
    +
```
public String getDelimitedRow(char delim,
+                     boolean quote,
+                     char quoteSymbol,
+                     int firstColumn,
+                     int lastColumn)
+                       throws UDRException
```
    +
    Get columns of a row as a delimited string. + +
    This method is useful to interface with tools that take a delimited + record format. It is also useful for printing rows
    +
    Parameters:
    delim - US ASCII field delimiter to use.
    quote - Whether to quote character field values that contain + the delimiter symbol or a quote symbol. Quote symbols + will be duplicated to escape them.
    quoteSymbol - US ASCII quote character to use, if quote is true.
    firstColumn - First column to read.
    lastColumn - Last column to read (inclusive) or -1 to read until + the last column in the row.
    +
    Returns:
    String String in which the result delimited row + will be returned.
    +
    Throws:
    +
    UDRException
    See Also:
    Only use this method at runtime. + +
    Note: This method may return a string that contains multiple + character sets, if columns with different character sets + are involved. Using this method with UCS-2 columns is not + recommended.
    +
  + + + +
  - +
    getDelimitedRow
    +
```
public String getDelimitedRow()
+                       throws UDRException
```
    +
    Get all columns of a row as a delimited string, with '|' as field delimiter + +
    This method is useful to interface with tools that take a delimited + record format. It is also useful for printing rows
    +
    Returns:
    String String in which the result delimited row + will be returned.
    +
    Throws:
    +
    UDRException
    See Also:
    Only use this method at runtime. + +
    Note: This method may return a string that contains multiple + character sets, if columns with different character sets + are involved. Using this method with UCS-2 columns is not + recommended.
    +
  + + + +
  - +
    wasNull
    +
```
public boolean wasNull()
```
    +
    Check whether the last value returned from a getInt() etc. method was NULL. + +
    This method is modeled after the JDBC interface.
    +
    Returns:
    true if the last value returned from a getInt(), getString() + etc. method was a NULL value, false otherwise.
    +
  + + + +
  - +
    setInt
    +
```
public void setInt(int colNum,
+          int val)
+            throws UDRException
```
    +
    Set an output column to a specified integer value. + +
    Use this method at runtime.
    +
    Parameters:
    colNum - Index/ordinal of the column to set.
    val - The new integer value for the column to set.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    setLong
    +
```
public void setLong(int colNum,
+           long val)
+             throws UDRException
```
    +
    Set an output column to a specified long value. + +
    Use this method at runtime.
    +
    Parameters:
    colNum - Index/ordinal of the column to set.
    val - The new long value for the column to set.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    setDouble
    +
```
public void setDouble(int colNum,
+             double val)
+               throws UDRException
```
    +
    Set an output column to a specified double value. + +
    Use this method at runtime.
    +
    Parameters:
    colNum - Index/ordinal of the column to set.
    val - The new double value for the column to set.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    setString
    +
```
public void setString(int colNum,
+             String val)
+               throws UDRException
```
    +
    Set an output column to a specified string value. + +
    Use this method at runtime.
    +
    Parameters:
    colNum - Index/ordinal of the column to set.
    val - The new string value for the column to set.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    setTime
    +
```
public void setTime(int colNum,
+           Date val)
+             throws UDRException
```
    +
    Set a datetime or interval output column to a value specified as Date + +
    This method cannot be used with year-month intervals or data types that + are not datetime or interval types. It is not possible to set fractional + seconds with this method. + +
    Use this method at runtime.
    +
    Parameters:
    colNum - Index/ordinal of the column to set.
    val - The new Date value for the column to set.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    setFromDelimitedRow
    +
```
public int setFromDelimitedRow(String row,
+                      char delim,
+                      boolean quote,
+                      char quoteSymbol,
+                      int firstColumnToSet,
+                      int lastColumnToSet,
+                      int numDelimColsToSkip)
+                        throws UDRException
```
    +
    Set the result row from a string with delimited field values. + +
    This method can be used to read delimited text files and + conveniently produce a result table from them. For example, + if the following string is passed in as row:
    +
    Parameters:
    row - A string with delimited field values to read.
    delim - Delimiter between field values. Use a US ASCII symbol + as the delimiter.
    quote - true if the method should assume that text fields + use quotes to quote special symbols like delimiters + that are embedded within fields, and that quote symbols + embedded in text fields will be doubled.
    quoteSymbol - US ASCII Quote symbol used to quote text. Meaningful + only if quote is set to true.
    firstColumnToSet - First column in the output table to be set + from the delimited row (0-based).
    lastColumnToSet - Last column in the output table to be set + (inclusive) or -1 to indicate to set all + remaining columns of the table.
    numDelimColsToSkip - Number of fields to skip in the delimited + row before using the values to set output + columns.
    +
    Returns:
    Number of character read from row. Can be used + to process text that is not yet consumed.
    +
    Throws:
    +
    UDRException
    See Also:
    getDelimitedRow(char,boolean,char,int,int)
    +
  + + + +
  - +
    setFromDelimitedRow
    +
```
public int setFromDelimitedRow(String row)
+                        throws UDRException
```
    +
    Set the result row from a string with delimited field values. + +
    Calls other version of setFromDelimitedRow with these arguments
    +
    Parameters:
    row - A string with delimited field values to read.
    +
    Returns:
    Number of character read from row. Can be used + to process text that is not yet consumed.
    +
    Throws:
    +
    UDRException
    See Also:
    getDelimitedRow( )
    +
  + + + +
  - +
    setNull
    +
```
public void setNull(int colNum)
+             throws UDRException
```
    +
    Set an output column to a NULL value. + +
    Use this method at runtime.
    +
    Parameters:
    colNum - Index/ordinal of the column to set to NULL.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addColumn
    +
```
public void addColumn(ColumnInfo column)
```
    +
    Add a new column. + + Only use this method from within the following method: +
    - UDR::describeParamsAndColumns() +
    +
    Parameters:
    column - Info of the new column to add.
    +
  + + + +
  - +
    addIntColumn
    +
```
public void addIntColumn(String colName,
+                boolean isNullable)
+                  throws UDRException
```
    +
    Add an integer output column. + +
    The new column is added at the end. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    colName - Name of the column to add. Use UPPER CASE letters, + digits and underscore, otherwise you will need to + use delimited column names with matching case in + Trafodion.
    isNullable - true if the added column should be nullable, + false if the added column should have the NOT NULL + constraint.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addLongColumn
    +
```
public void addLongColumn(String colName,
+                 boolean isNullable)
+                   throws UDRException
```
    +
    Add a long output column. + +
    The new column is added at the end. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    colName - Name of the column to add. Use UPPER CASE letters, + digits and underscore, otherwise you will need to + use delimited column names with matching case in + Trafodion.
    isNullable - true if the added column should be nullable, + false if the added column should have the NOT NULL + constraint.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addCharColumn
    +
```
public void addCharColumn(String colName,
+                 int length,
+                 boolean isNullable,
+                 TypeInfo.SQLCharsetCode charset,
+                 TypeInfo.SQLCollationCode collation)
+                   throws UDRException
```
    +
    Add a fixed character output column. + +
    The new column is added at the end. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    colName - Name of the column to add. Use UPPER CASE letters, + digits and underscore, otherwise you will need to + use delimited column names with matching case in + Trafodion.
    length - Length of the new character column. + For single-byte and variable byte character sets, + the length is specified in bytes. For UTF-8, this + is equivalent to CHAR(length BYTES) in SQL. For UCS2, + the length is in UCS2 16-bit characters.
    isNullable - true if the added column should be nullable, + false if the added column should have the NOT NULL + constraint.
    charset - Character set of the new column.
    collation - Collation of the new column.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addCharColumn
    +
```
public void addCharColumn(String colName,
+                 int length,
+                 boolean isNullable)
+                   throws UDRException
```
    +
    Add a fixed character output column with UTF8 charset and SYSTEM_COLLATION + +
    The new column is added at the end. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    colName - Name of the column to add. Use UPPER CASE letters, + digits and underscore, otherwise you will need to + use delimited column names with matching case in + Trafodion.
    length - Length of the new character column. + For single-byte and variable byte character sets, + the length is specified in bytes. For UTF-8, this + is equivalent to CHAR(length BYTES) in SQL. For UCS2, + the length is in UCS2 16-bit characters.
    isNullable - true if the added column should be nullable, + false if the added column should have the NOT NULL + constraint.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addVarCharColumn
    +
```
public void addVarCharColumn(String colName,
+                    int length,
+                    boolean isNullable,
+                    TypeInfo.SQLCharsetCode charset,
+                    TypeInfo.SQLCollationCode collation)
+                      throws UDRException
```
    +
    Add a VARCHAR output column. + +
    The new column is added at the end. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    colName - Name of the column to add. Use UPPER CASE letters, + digits and underscore, otherwise you will need to + use delimited column names with matching case in + Trafodion.
    length - Length of the new character column. + For single-byte and variable byte character sets, + the length is specified in bytes. For UTF-8, this + is equivalent to CHAR(length BYTES) in SQL. For UCS2, + the length is in UCS2 16-bit characters.
    isNullable - true if the added column should be nullable, + false if the added column should have the NOT NULL + constraint.
    charset - Character set of the new column.
    collation - Collation of the new column.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addVarCharColumn
    +
```
public void addVarCharColumn(String colName,
+                    int length,
+                    boolean isNullable)
+                      throws UDRException
```
    +
    Add a VARCHAR output column with UTF8 charset and SYSTEM_COLLATION + +
    The new column is added at the end. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    colName - Name of the column to add. Use UPPER CASE letters, + digits and underscore, otherwise you will need to + use delimited column names with matching case in + Trafodion.
    length - Length of the new character column. + For single-byte and variable byte character sets, + the length is specified in bytes. For UTF-8, this + is equivalent to CHAR(length BYTES) in SQL. For UCS2, + the length is in UCS2 16-bit characters.
    isNullable - true if the added column should be nullable, + false if the added column should have the NOT NULL + constraint.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    addColumns
    +
```
public void addColumns(Vector<ColumnInfo> columns)
```
    +
    Add multiple columns to the table-valued output. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    columns - Vector of ColumnInfo objects describing the columns to add.
    +
  + + + +
  - +
    addColumnAt
    +
```
public void addColumnAt(ColumnInfo column,
+               int position)
```
    +
    Add a new column at a specified position. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    column - ColumnInfo object describing the new column.
    position - Position/ordinal number of the new column. + All existing columns with ordinal numbers + greater or equal to position will be shifted by one.
    +
  + + + +
  - +
    deleteColumn
    +
```
public void deleteColumn(int i)
+                  throws UDRException
```
    +
    Delete a column of the table-valued output. + +
    Only use this method from within the + UDR#describeParamsAndColumns() method.
    +
    Parameters:
    i - Position/ordinal (0-based) of column to be deleted.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    deleteColumn
    +
```
public void deleteColumn(String name)
+                  throws UDRException
```
    +
    Delete a column with a specified column name. + +
    The first column that matches the specified column name + will be deleted.
    +
    Parameters:
    name - Name of the column to be deleted.
    +
    Throws:
    +
    UDRException
    +
  + + + +
  - +
    print
    +
```
public void print()
+           throws UDRException
```
    +
    Print the object, for use in debugging.
    +
    Throws:
    +
    UDRException
    See Also:
    UDR.debugLoop(), +UDRInvocationInfo.DebugFlags.PRINT_INVOCATION_INFO_AT_RUN_TIME
    +
  +
+

Class TupleInfo

Method Summary

Methods inherited from class java.lang.Object

Method Detail

getNumColumns

getColNum

getColumn

getColumn

getType

getSQLTypeClass

getInt

getInt

getLong

getLong

getDouble

getDouble

getString

getString

getBoolean

getBoolean

getTime

isAvailable

getDelimitedRow

getDelimitedRow

wasNull

setInt

setLong

setDouble

setString

setTime

setFromDelimitedRow

setFromDelimitedRow

setNull

addColumn

addIntColumn

addLongColumn

addCharColumn

addCharColumn

addVarCharColumn

addVarCharColumn

addColumns

addColumnAt

deleteColumn

deleteColumn

print