How to Select Language During Creating DCLGEN

This is one of the best practical question for DB2 developers. While working on PL/I programs there is a scenario, for a table, you need to create DCLGEN. Then, you need to change language setting. But how to do it. The default is for COBOL. The solution is, go to DB2I panel and change the setting as below

DB2I DEFAULTS PANEL 1                               
COMMAND ===>                                                                   
                                                                               
Change defaults as desired:                                                    
                                                                               
 1  DB2 NAME ............. ===> DB2A      (Subsystem identifier)               
 2  DB2 CONNECTION RETRIES ===> 0         (How many retries for DB2 connection)
 3  APPLICATION LANGUAGE   ===> PL/I    (ASM, C, CPP, IBMCOB, FORTRAN, PLI)  
 4  LINES/PAGE OF LISTING  ===> 60        (A number from 5 to 999)             
 5  MESSAGE LEVEL ........ ===> I         (Information, Warning, Error, Severe)
 6  SQL STRING DELIMITER   ===> DEFAULT   (DEFAULT, ' or ")                    
 7  DECIMAL POINT ........ ===> .         (. or ,)                             
 8  STOP IF RETURN CODE >= ===> 8         (Lowest terminating return code)     
 9  NUMBER OF ROWS ....... ===> 20        (For ISPF Tables)                    
10  AS USER                ===>           (Userid to associate with the trusted
                                           connection)                         
                                                                               
 F1=HELP      F2=SPLIT     F3=END       F4=RETURN    F5=RFIND     F6=RCHANGE   
 F7=UP        F8=DOWN      F9=SWAP     F10=LEFT     F11=RIGHT    F12=RETRIEVE  
Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.