-
PLI program using DB2 top ideas
You can write SQL queries in PLI programs. Cursors are mostly being used in almost all mainframe projects. The given awesome DB2 cursor examples really useful to use in your projects readily. Read more. Read More ⇢
-
14 Top PLI Interview Questions
Top 10 PLI interview questions asked in all Mainframe interviews for all experiences levels. The questions are given in key points, and for you it is ready reference area where you can explore more points. Read More ⇢
-
How to create sort card with IKJEFT01 utility?
The following JCL will help you to create sort card dynamically. //jobname job (acct info),’srinimf’,notify= //* //Joblib DD DSN=abcd.abc.abcd //* //step1 step exec pgm=IKJEFT01 //* //output DD DSN=output dataset //sysin DD * select sort_cntl from (cast(‘xxxxxxxxxxx’) as char(70)) as sort_cntl from sysibm.sysdummy1 union all . . . . ) x with… Read More ⇢
-
2 Best Ways to Use COND in JCL
COND parameter in JCL you can give at STEP, JOB level. Read more details. Read More ⇢
-
Where to Use Compiler Options in COBOL and CICS Program
Compiler options to compile COBOL module or CICS module you can give before identification division. Then, compiler recognize your compiler options. Read more. Read More ⇢
-
JCL: How to Skip Steps from Proc
To skip a step from proc, I have explained the code you need to add in the JCL. So skipping proc steps this solution highly useful. Read More ⇢
-
32 Complex SQL Interview Questions
Best and complex SQL queries for quick reference to apply in projects and for interviews. Read more. Read More ⇢
-
What is Package in Oracle PLSQL
Here is sample PLSQL package and what it is explained here. Read More ⇢
-
Subquery Vs. Correlated Subquery – Top Differences
Sub Query and Correlated Sub query the real differences and useful for Database or SQL developers Read More ⇢
Srinimf 