Abend An AbEnd (abnormal end) is an exception condition which results in the abnormal termination of a program or software.  Its is a common terminology used in the mainframe world where a JCL terminates with an error code. Following section covers some common abends faced by mainframe developers S0C1 Operation Exception Cause Reading or writing […]
Mainframe JCL Abend Examples Read More »
SQL code -305 SQL code of -305 is the sql error which results on retrieving a null value in a host variable for which there is no null When does Sql code -305 comes? Sqlcode -305 can come if a fetch or embedded SELECT results in assigning a NULL value to a host variable for
Hello. This is Vikas Saxena, the author of mainframewizard.com. Hope you enjoyed the website and have something to take back. If you like the website add it to your bookmarks and suggest others. Any comments. feedback or suggestions are most welcome at mainframewizard@gmail.com
SQL code of -204 comes due to sql involving an object which is not defined. SQLCODE = -204, ERROR:  objectname IS AN UNDEFINED NAME When does Sql code -204 comes? Sqlcode -204 can come if the sql involves an object which is not defined. This could happen with any DB2 object. This sqlcode can also
What is Cloud computing? This article is aimed at giving a general idea for cloud computing. Cloud computing is a term used for the computing in which the services, software, data and other devices are provided by shared servers based on demand. It does not depend on the location of these resources. You may be
What is Cloud computing Read More »
If you wish to skip certain number of records while sorting you can use the following Where n is the number of records which are to be skipped while sorting Example JCL is provided below. ; ; ; ; //SORTIN Â DD DISP=SHR,DSN=USERID.ABC.INPFILE, //SORTOUT Â DD DSN=USERID.ABC.OUTFILE, // Â Â Â SPACE=(TRK,(30,10),RLSE), Â Â Â Â Â
SORT JCL with SKIPREC Read More »
If you wish to stop sorting after say N number of records then you can use the following Where n is the number of records after which sorting is required to be stopped. Example JCL is provided below. ; ; ; ; //SORTIN Â DD DISP=SHR,DSN=USERID.ABC.INPFILE, //SORTOUT Â DD DSN=USERID.ABC.OUTFILE, // Â Â Â SPACE=(TRK,(30,10),RLSE), Â Â
SORT JCL with STOPAFT Read More »
UPDATE DATA IN ONE DB2 TABLE USING DATA IN ANOTHER TABLE There are instances when you wish to add a new column in a table and initialize it with data from a column in another table. SET (A.COLUMN1) = (SELECT B.COLUMN2 FROM TABLE2 B WHERE B.COLUMN_KEY = A.COLUMN_KEY) TABLE1   – Table in which
Update Data in one DB2 table using data in another table Read More »
Reading last record in VSAM file Is it possible to read the last record of a VSAM file directly? I have faced this question in an interview. The vsam file can be accessed sequentially as well as randomly using a key. But how to make sure that we read the last record of the VSAM
Reading last record in VSAM file Read More »
SORT JCL to Split data using OUTFILÂ The following sort card will sort split the input file into two files. First file will have records which have ‘AB’ at 266th position and second file will have records which have ‘AC’ at 266th position. INCLUDE=(266,2,CH,EQ,C’AB’) Â Â Â INCLUDE=(266,2,CH,EQ,C’AC’) Â Â Example JCL is provided below ;
SORT JCL to Split data using OUTFIL Read More »
