CICS VSAM Transparency for z/OS, Version 1.2


Updating a column

Specify U on the command line to update a column. The following screen is displayed:
Figure 1. Update column screen
  
---------------------------- 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:

Figure 2. Update column screen with sample values
 
---------------------------- 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 .





Last updated: December 6, 2013 20:43:18

Information Information

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///topics/cvtug_update_column.html