Srinimf

DB2- Date and Timestamp-Timezone

How to use DATE, TIME and TIMEZONE in DB2 SQL you can learn and apply in your projects. Read More ⇢
CEMT INQUIRE TRANSACTION

Why you need Inquire transaction in CICS and when to use it explained with example. Read More ⇢
DB2 SQL Error Codes For Job Interviews

SQL Error codes frequently occur in DB2 projects listed in this post. This list is useful for all job interviews. Read More ⇢
My Achievements

Srinimf achievements and popularity among readers and software developers across the world. Read More ⇢
JCL IF/ELSE/THEN/ENDIF logic to Use in Job Steps

JCL how to use IF ELSE and END-IF logic to control execution of job steps Read More ⇢
CICS DFHAID, Here are Screen Navigation Commands

The following DFHAID list we will use in the navigation of CICS Screens in the CICS-COBOL program. CICS Screen Navigation Commands List DFHENTER: ENTER key. DFHCLEAR: CLEAR key. DFHPA1– DFHPA3 (Mapping Keys): PA1–PA3 keys. DFHPF1– DFHPF24: PF1–PF24 keys. DFHOPID: OPERID or MSR. DFHMSRE: Extended (standard) MSR. DFHTRIG: Trigger field. DFHPEN:… Read More ⇢
DB2 – Fetch 1 Row Vs Optimize 1 Row Top Differences

Optimize and Fetch in DB2 why and when to use these clauses explained. Read More ⇢
SQL Query To Get EmpIDs Department Wise

SQL query to get employee id in department wise. Read More ⇢
SQL-PLSQL GURU

SQL tips and example queries to your practice. Read More ⇢