- Blog
- Blog
- Homepage
- Homepage
-
DFSORT: How to Use FIELDS and BUILD to Delete Fields
Let us take an example and see, how we can delete fields with FILEDS or BUILD The SORT, SUM and OUTREC statements are as follows Here is an example to use outrec fields in jcl. So, in the OUTREC statement after writing OUTREC give one space and write either FIELDS or BUILD So, in the…
-
10 DB2 Tricky Interview Questions on Isolation Levels
Isolation levels in DB2 explained possible interview questions. You can prepare these questions before you attend interviews.
-
15 Precious Uses of INREC,OUTREC and OUTFIL in JCL DFSORT
The super best advantages what you can do with DFSORT using sort utility in JCL. Read more.
-
How to Code SORT Logic in COBOL Program
Sort Logic in COBOL best example Related Posts
-
Tricky CICS Interview Question on Updating VSAM records
Interview question on updating or re-writing records, in CICS. from one file type to another file type.
-
IDCAMS: Copy VSAM to Non VSAM dataset
JCL to copy VSAM dataset to non-vsam dataset using IDCAMS utility.
-
COBOL List of Top Date Functions
COBOL default date format is YYYYMMDD. Below is the list of COBOL intrinsic functions that help you get various Date related things. COBOL List of DATE Functions CURRENT-DATE None Alphanumeric Current date and time DATE-OF-INTEGER 1 integer Integer Standard date equivalent (YYYYMMDD) of integer date 5 DATE-TO-YYYYMMDD 1 or 2 integer Integer YYYYMMDD date converted…
-
5 Power Thoughts on DB2 V11 Date Subtraction
Subtracting dates: Idea-1 The result of subtracting one date (DATE2) from another (DATE1) is a date duration that specifies the number of years, months, and days between the two dates. Idea-2 The data type of the result is DECIMAL(8,0). If DATE1 is greater than or equal to DATE2, DATE2 is subtracted from DATE1. If DATE1…
-
COBOL Date Logic to Find Number of Days
Here is COBOL logic you can use for the calculation of DATEs.
-
DB2 Alternate Isolation Level Option for ‘UR’
The isolation level option usually improves performance compared to other options. This reads all uncommitted data. No need to wait for till lock is released on the page or row. The other option is SKIP LOCKED DATA Example: SELECT ELEMENT FROM WORKQUEUE WHERE PRIORITY = ‘1’ AND STATUS=’OPEN’ SKIP LOCKED DATA; What is SKIP…
-
Creating a VSAM AIX Using the BLDINDEX Example
Sample JCL to create alternate index in VSAM using BLDINDEX utility. The examples are explained to understand easily
Srinimf 