Skip to content
  • About Srini
  • Jobs
  • Amazon
  • Udemy
  • Contact us

Join 1,899 other subscribers

Srinimf

Srinimf

  • SQL Query: Extracting Employees Sal > Avg Salary

    Apr 6, 2024

    ·

    PySpark
    SQL Query: Extracting Employees Sal > Avg Salary
  • 5 TSO Cmmands You Need to Know

    Top TSO commands mostly used by all the programmers in their day to day job. Read More ⇢

  • IMS DB: Top Proc Options to Use in PSB

    PROCOPT in PSB of IMS DB Read More ⇢

    IMS DB: Top Proc Options to Use in PSB
  • 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- SENSEG and SENFLD in PSB
  • 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-Command Code ‘D’ and Proc Option ‘P’
  • 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 ⇢

    IMS DB: Why PCBs Must Give In Sequence In ENTRY
  • 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 ⇢

    SQL Commit Vs Rollback: Syntax to Write in COBOL
  • 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 ⇢

    DB2 Fetch ideas on how to optimize result
  • 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 ⇢

    How to make Mentor Networking in current Company
  • 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 ⇢

    JCL- Sort ‘PD’ to ‘ZD’ with Length Calculation
«Prev
1 … 212 213 214 215 216 … 236
Next»

About Srinimf

We share solutions for software developers and interview questions.

2,753,877 hits

Subscribe for DAILY TIPS

Join our mailing list to stay notified about new blog posts. No spam, we guarantee.

  • Tumblr
  • Facebook
  • Instagram
  • WordPress
  • X

Srinimf

Designed with WordPress

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Srinimf
    • Join 266 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Srinimf
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar