-
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… Read More ⇢
-
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.… Read More ⇢
-
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… Read More ⇢
-
SQL Commit Vs Rollback: Syntax to Write in COBOL
COMMIT statement ends the logical unit of work. Commit in SQL ROLLBACK in SQL Read More ⇢
-
DB2 Fetch ideas on how to optimize result
DB2 fetch top rules you need to know while using it in your SQL queries. Read More ⇢
-
How to make Mentor Networking in current Company
Make network of mentors to advance in career and to achieve your aspirations or goals Read More ⇢
-
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. Read More ⇢
-
DB2 SQL Functions Count Vs Count_Big
How to use count and count_big in SQL. Explained with examples and differences. Read More ⇢








