---------------------------- CICS VT: Update column ---------------------------- Command ===> ________________________________________________ Scroll ===> CSR_ Column selected: ITEM_DATE_FIRST_SHIP + Copybook field length ==> 5 Current column length ==> 9,0 Current column type ==> DEC Enter new column length ==> _____ (if DEC specify x,y) Enter new column type ==> ____ (CHAR,DEC,INT,SINT,BINT,DATE,TIME,TIMS) Specify picture / FBE ==> _________________ (example HH.XX.SS.NNNNNN) (or MMDDYY) (or EXITx=exit name) Parameters ==> __________________________ Optional user parameters Press: Enter to confirm PF3 to exit PF1 for help
The column length and data type can be changed using the update column facility. The supported column types are displayed on the screen. If you specify a new data type of DATE, TIME, or TIMS, you are forced to define the appropriate picture string. This is shown in Figure 2:
---------------------------- CICS VT: Update column ---------------------------- Command ===> ________________________________________________ Scroll ===> CSR_ Column selected: ITEM_DATE_FIRST_SHIP + Copybook field length ==> 5 Current column length ==> 9,0 Current column type ==> DEC Enter new column length ==> _____ (if DEC specify x,y) Enter new column type ==> DATE (CHAR,DEC,INT,SINT,BINT,DATE,TIME,TIMS) Specify picture / FBE ==> CCYYMMDD_________ (example HH.XX.SS.NNNNNN) (or MMDDYY) (or EXITx=exit name) Parameters ==> __________________________ Optional user parameters Press: Enter to confirm PF3 to exit PF1 for help
See the CICS VT Reengineering and Customization Guide for information about defining picture strings.
CICS® VT allows you to change the length of a column. You should carefully consider the potential effects of changing a column length to avoid adverse results. For example, if you specify a DB2® column length that exceeds the copybook field length, data retrieved from DB2 will potentially be truncated. This could be particularly significant if the data is numeric.
You can specify an FBE and add optional user parameters. These are described in Mapping fields .