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