- Blog
- Blog
- Homepage
- Homepage
-
IMS DB- SENSEG and SENFLD in PSB
Sensitive Segments: In a PSB maximum of 30,000 SENSEG statements we can code as per IMS V11. In PSB macro; Col…10 Col..16 Col…72 PCB TYPE=DB,DBDNAME=DATABASE, X PROCOPT=A,KEYLEN=22SENSEG NAME=A,PARENT=0,PROCOPT=G So, every PCB refers to a database. The description for each segment is already defined in DBD. So the segments we defined in PSB of PCB statement are called sensitive segments. Sensitive fields:…
-
IMS DB-Command Code ‘D’ and Proc Option ‘P’
Command codes enhances the database search in IMSDB. I want to say here about “D” command code and “P” proc option. Command Code Vs Proc Option We need to give Command code ‘D’ in all the SSAs top to bottom, except for last segment. Proc option-Indirectly acts as exclusive locks. “P” proc option is required PROCOPT=P in…
-
IMS DB: Why PCBs Must Give In Sequence In ENTRY
As we all know, PSB is a database, it represents database view to the application program. And, PSBs are combination of various PCBs. So each PCB represents to one segment. In the PSB generation, we can code in PCB blocks of sensitive segments and sensitive fields. To run each batch program , we need to supply Program-name and PSB-name in JCL thru Parm parameter. PARM=(DLI, Program-name,PSB-name,,,).…
-
SQL Commit Vs Rollback: Syntax to Write in COBOL
COMMIT statement ends the logical unit of work. Commit in SQL ROLLBACK in SQL
-
DB2 Fetch ideas on how to optimize result
DB2 fetch top rules you need to know while using it in your SQL queries.
-
How to make Mentor Networking in current Company
Make network of mentors to advance in career and to achieve your aspirations or goals
-
JCL- Sort ‘PD’ to ‘ZD’ with Length Calculation
The best method to calculate length during conversion of PD to ZD in JCL DFSORT. Highly useful and time saving tip and useful for all mainframe developers.
-
DB2 SQL Functions Count Vs Count_Big
How to use count and count_big in SQL. Explained with examples and differences.
-
SQL CAST Function: How to Convert CHAR to VARCHAR
Cast function in SQL useful to covert one data-type to other,
-
CICS Quiz Part 1
I created a CICS quiz with 11 questions. Your pass score is 80%. Focussed, on important basics. In my next posts, I will give some more quizzes. Topics covered: – Files – MAPS -Frequent Abends – TSQ and TDQ -Subroutines Start here to take Quiz CICS Part 1.
-
ISPF Find Commands
Here is a list of ISPF ‘FIND’ command and its options. These are useful for ISPF editor.
-
DB2- Use of ‘COALESCE’ Function (1 of 2)
The “COALESCE” function is one of the frequently used functions in DB2. Before going into detail, I just want to describe it in layman terms. This function validates for NULL, and secondly, if NULL is there it assumes some value as we give in the function. Syntax: COALESCE(epression1,expression2) It is like decision maker. Its uses are many. Usage-1: CASE WHEN…
Srinimf 