Ensure Columns
Returns a copy of a specified table, modified where necessary to guarantee that given columns columns have specified types.
Arguments
The function has the following arguments:
Table: The specified table.
Column Name(s): Text string that specifies the columns to be modified if necessary. Supply a single column name or a semicolon-separated list of column names.
Column Type(s): Text string that specifies the types. Supply a single name or a semicolon-separated list of names. The
nth element of
Column Type(s) is the type to be gauranteed for the column specified by the
nth element of
Column Name(s).
Values: Semicolon-separated list of values to substitute when a value must be modified. The
nth element of
Values is used for the column named by the
nth element of
Column Name(s).
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.