The RENCOLS function renames selected column names of a current table to new column names in a new table. Unchanged columns are copied as is. The columns to be renamed are specified in pairs of old column name and new column name. The total length of the column name list cannot exceed 200 characters.
The RENCOLS function has the following syntax:
OI ASOTEAPI RENCOLS TABLE(from_table_name) TARGET(to_table_name)
COLUMNS(fromcol tocol fromcol tocol…) SSMPROT(YES|NO)
The SSMPROT keyword determines whether the potentially destructive operation is performed on an active System State Manager resource table or the SSM directory table. A value of NO unconditionally allows the operation. A value of YES prohibits the requested operation against any active SSM table. The default is NO except for the DELETE, DROPCOLS, and RENAME operations.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|