Previous Topic: TRANSFER Function—Copy Matching Column NamesNext Topic: UCPKCOPY Function—Add Upper Case to Primary Keys

Relational Data Framework Reference › Relational Table Editor Batch API Functions › UCCCOPY Function—Add Upper Case to Copied Rows

UCCCOPY Function—Add Upper Case to Copied Rows

The UCCCOPY function copies the structure and rows of a table to a new table and adds the UPPER CASE attribute to all character-type columns in the new table.

UCCCOPY has the following syntax:

OI ASOTEAPI UCCCOPY TABLE(from_table_name) TARGET(to_table_name) 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.