STScI Logo

tchcol tables



tchcol -- Change column description.


tchcol table oldname newname newfmt newunits


This task may be used to change the name of a column, the display format, or the units. To change more than one column the task must be called more than once. Only those items (name, units, format) that are not null will be changed. The word "default" may be used to set the print format or the units to their default values.


table [file name template]
Names of tables to be modified. The same change(s) will be made to all tables.

Note that the tables are modified in-place.

oldname = "" [string]
Name of column to be changed. If the column is not found, a message will be printed, and the current table will not be changed.
newname = "" [string]
New column name or a null string ("").

If this is null or blank, the column name will not be changed.

newfmt = "" [string]
New value for print format, or "default" or "".

If this is null or blank, the display format will not be changed. If newfmt = "default" the print format will be set to the default for the column data type. Type "help ttools opt=sysdoc" for more information about print formats.

newunits = "" [string]
New value for units, or "default" or "".

If this is null or blank the units will not be changed. If newunits = "default" the units will be set to null. There is no way (with this task) to set the units to the value "default"!

(verbose = yes) [boolean]
Print the names of tables as the task progresses?

If verbose=yes then the table names are printed, and for each item that is changed, a message is printed giving the old and new values.


In table, change column name "chi" to "CHI" and set the units to degrees. The display format is not changed.

tt> tchcol m87pol chi CHI "" degrees

In the same table, set the units of column "P" to null. The name and format are not changed.

tt> tchcol m87pol P "" "" default



This task was written by J.C. Hsu and was modified by Phil Hodge.


Source Code · Search Form · STSDAS