AMBLIST to generate stats about a object load The following JCL can be used to find date when a load was created. If the input member is the object load of a module the date when the load was generated would be listed. If the input is a composite link then the details of all […]
Date and timestamp in load object Read More »
Mainframe Computers Mainframe computers are very large and expensive computers often called as big iron machines used by thousands and even more users simultaneously. These are primarily used by big financial organisations(banks and insurance companies), retail giants, corporate and government organizations for supporting critical applications where data security and bulk processing is a key factor.
mainframe computer 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 »
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 »
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 »
The following COBOL program depicts the use of     01 WS-SUB  PIC 9  VALUE ZEROS.           DISPLAY ‘WS-SUB IS GREATER THAN 4’           DISPLAY ‘WS-SUB IS GREATER THAN 5’           DISPLAY
COBOL EVALUATE FALSE 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 »
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 »
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 »
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
