-
How to Call SQL in PL/I Program
Here is sample logic to call SQL in PL/I program. Read More ⇢
-
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. Read More ⇢
-
IDCAMS: Copy VSAM to Non VSAM dataset
JCL to copy VSAM dataset to non-vsam dataset using IDCAMS utility. Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
COBOL Date Logic to Find Number of Days
Here is COBOL logic you can use for the calculation of DATEs. Read More ⇢
-
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… Read More ⇢
-
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 Read More ⇢
-
5 Top Limitations of COBOL SEARCH ALL
The condition following the word WHEN can test only for equality: Valid: WHEN T-CUSTOMER-NO (X1) = CUST-NO-IN Invalid: WHEN T-WEIGHT-MAX (X1) < WEIGHT-MAILED If the condition following the word WHEN is a compound conditional: The OCCURS item and its index, which define the table argument, must appear to the left… Read More ⇢
Srinimf 