CICS MAP – adding a new field Step by step Procedure using SDF II: SELECT AN SDF II FUNCTION 1 PANEL EDITOR Create or modify a panel 2 PANEL GROUP EDITOR Create or modify a panel group 3 PARTITION SET EDITOR Create or modify a partition set 4 AID TABLE EDITOR Create or modify an
SQLDA USE in Dynamic SQL: Db2 uses the SQL Descriptor Area(SQLDA) to communicate the dynamic SQL information to the application program. It contains the various information like type of SQL, length, pointer to the actual data & number of columns etc. which are very useful for better coding. To get this information into SQLDA after
Sometimes we may face a requirement to check the file is empty or not, if it is empty stop the process other wise proceed with further steps using JCL. Here are some of the commonly used methods to check whether a Physical Sequential (PS) or VSAM File is empty or not. 1. By Using IDCAMS
Multi row Fetch Overview in COBOl Db2 program WITH EXAMPLE: Cobol Db2 multi row fetch concept will be used to retrieve multiple rows with a single fetch statement as opposed with a normal cursor which fetches only single record at a time. The multi-row fetch capability was introduced to DB2 z/OS in Version 8. This
COBOL Index and Subscript – Performance considerations Index and Subscript in COBOL are the very important concepts. Both are used to reference an array or table element in COBOL programs. By knowing the basic differences between the two, one can code the programs efficiently in performance point of view. 1. Index –> Represents the displacement
How to code Dynamic SQL(DS) in a COBOL DB2 Program Dynamic SQL is prepared and executed at the run time as opposed to embedding it in the host language program as in a static one. Using dynamic SQL in the application programs has proved many advantages. For ex: In some cases the businesses requirement demands
Exception handling It is one of the core concept in CICS coding. Programmer should have knowledge on exception handling methods for effective use of these methods while developing any program. This topic gives various types of exception handling and usage of each one in detail. By default CICS manages the exceptions internally and ends programs
File aid is having two types one which is used for File operations and second one is used for DB2 (file aid for DB2). Here we are going to discuss about the file aid for files. Fileaid is a very useful tool in the mainframes, it can be used to browse (PS, VSAM), EDIT the
Useful QMF Commands Below are commonly used QMF commands for quick reference 1. Connect: To connect to different database other than the default one(e.g.; if the default is DSNS and u want to connect to DB2T) Then issue the command Connect to DB2T in the QMF main panel. 2. Import : This is to import
Cursor positioning in CICS is an important aspect in the screen and program design. At the time of screen (MAP) design the initial cursor location must be specified as per the requirement. This is the Static Cursor positioning. This can be changed dynamically at the time program coding and it is called as the Dynamic Cursor
