How do I Alter or Create a Table with a Column Name > 18 Characters in RC/UPDATE for DB2 for z/OS?

Document ID : KB000025353
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

How do I Alter or Create a Table with a Column Name > 18 Characters in RC/UPDATE for DB2 for z/OS?

Answer: 

There are two methods available for defining a column name greater than 18 characters in a table using RC/Update:

1. When adding a column to the table from the CA - Table Alter/Create screen, type EXPAND on the command line and place the cursor on the column name field and press ENTER. The Expanded Edit/View screen will display and allow a column name to be entered up to 30 characters. Press PF3 to return to the CA - Table Alter screen.

2. When adding a column to the table from the CA - Table Alter/Create screen, begin typing the column name and then press PF11. The cursor's position will be moved to the left edge of the column name field, along with the character that was positioned under the cursor. This will allow additional characters to be typed in order to complete the name, to a maximum of 30 characters. Press PF10 to return to the beginning of the column name.