- Blog
- Blog
- Homepage
- Homepage
-
List of IMS DB Topics for Interviews
The below is the complete list you need to refresh before you take for IMS DB interview: Prepare These Before Your Interview IMS DB Architecture IMS DB DBD declaration. What is PSB and PCB IMS DB DL/I entry. different Calls in IMS DB Tools being used to browse IMS DB database Error handling in IMS…
-
Mastering EXPLAIN PLAN: Improve SQL Performance
Syntax for EXPLAIN PLAN What happens when you issue EXPLAIN PLAN? Explanation for Set Query No SET QUERYNO = integer ==>Associates integer with explainable-sql-statement. The column QUERYNO is given the value integer in every row inserted into the plan table, statement table, or function table by the EXPLAIN statement. If QUERYNO is not specified, DB2…
-
How to Understand SAS Macro Easily
The SAS program explained the syntax rules you need and program rules how to write it. Highly suitable for dummies in SAS. Read more.
-
How to Run a Query in QMF Automatically
Best example to run SQL query automatically in QMF. Useful for mainframe developers.
-
IDCAMS Sort File Skip Header and Trailer
The logic is again in two ways: Method-1 Use IDCAMS utility skip header record and trailer record. IDCAMS Skip record code snippet: // EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=A //SYSIN DD * Skip(1)count(48) /* Method-2 Use IFTHEN in sort on input file, that is INREC. That means you need to reformat input record without header and…
-
10 Killer Tips to Write PLI program Easily
The following are the top 10 tips to write perfect PLI program. Tip#1 Source programs may be written in upper or lower case. There is no difference between the cases, except within strings. Tip#2 Varying strings (declared with the attribute VARYING) are similar to C’s char. For an exact equivalant, in Enterprise PL/I for z/OS…
-
PLI Boolean Operators – Real Purpose
Boolean operators in PLI language. Learn how to use them.
-
12 PLI Phrases to Handle Program Errors
Error handling standard phrases being used in almost all the PLI programs. Read more.
-
How to Run PLI Program in Batch JCL
Batch JCL to run PLI program.
-
How to Convert SQL Error into Text
In this post, I explained SQL logic to convert SQL error into a text message using DSNTIAR.
-
JCL Quiz to refresh the knowledge quickly
The JCL quiz really good to take it multiple times so that you will remember the concepts perfectly. Highly useful for mainframe developer.
-
5 More JCL Interview Questions
The advanced JCL interview complex questions given on GDG, Tape data set and mainframe error codes. A quick refresher and surely boosts your knowledge.
Srinimf 