Developing Apama Applications > Dashboard Function Reference > Tabular Functions > Set Column Type
Set Column Type
Returns a copy of a specified table, with specified columns modified to use specified data types.
Arguments
The function has the following arguments:
*Table: Table from which the column is to be selected.
*Column Types: Text string that specifies column-name/type pairs. Separate pairs with spaces. Within each pair, separate column-name from type with a colon, that is, each pair has the following form:
*column-name:type
For type, supply one of the following:
*STRING
*INTEGER
*LONG
*DOUBLE
*FLOAT
*BOOLEAN
*DATE
If column-name contains a space or a colon, it must be enclosed in single quotes. Here is an example:
*apama.timestamp:DATE 'Max Value':INTEGER Active:BOOLEAN
This function returns a table.
Copyright © 2013 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.