DB2-Stored procedures & Triggers
Both are DB2 code. Stored procedures are created and stored in SYSPROC catalogue table. These are static and whenever user wants they can call in th program. How to call stored procedures? Syntax is as follows: SAMPLE is stored procedure name. Exec SQL CALL SAMPLE END-EXEC. Triggers are dynamic. When particular situation happens… Read More ⇢
PL1 mostly used Logical Expressions
PLI program top logical expressions. Like many other top level languages PL/I also has For, While, Do While loops. Read More ⇢
Top JCL The Real Usage of IFTHEN in DFSORT
DFSORT conditional sort best example. Given here step by step explanation for each step. Read more. Read More ⇢
Bind Vs Plan Vs Package in DB2
Bind vs Plan vs Package in DB2 to read today Read More ⇢
JCL: DFSORT, IFTHEN, Overlay,When,HIT
Here is a sample DFSORT JCL on how to use IFTHEN, OVERLAY, WHEN and HIT. How to Use IFTHEN, OVERLAY, WHEN, HIT in DFSORT.. //SYSIN DD * INREC IFTHEN =(WHEN=(10,1,CH,EQ’C’),OVERLAY(10:C’+’),HIT=NEXT), IFTHEN=(WHEN=(27,1,CH,EQ’C’),OVERLAY(27:C’+’),HIT=NEXT), and so on SORT FIELDS=COPY OUTREC FIELDS=(1,3122) // Note: HIT=NEXT, tells that to process next IFTHEN Recent Posts Read More ⇢
DFSORT: OUTFIL,OUTREC,INREC, INCLUDE
There is a simple way that you will become good in DFSORT. Follow these tips to understand keywords present in DFSORT clearly. Read more. Read More ⇢
Become a Senior Developer: A Clear Path to Career Growth
Explore key tips to grow your software development career—from junior roles to leadership—with practical advice on skills, mindset, and smart moves. Read More ⇢
DB2 SQL Error Codes You Always Need
DB2 SQL error codes given for interviews as well as to use in your development or production support project. Read More ⇢
DB2 Rowset to Fetch Multi-rows Easily
WITH ROWSET POSITIONING specifies that the cursor can be used with either row-positioned or rowset-positioned FETCH statements. This cursor can be used to return either a single row or multiple rows, as a rowset, with a single FETCH statement Read More ⇢
You must be logged in to post a comment.