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

Join 1,909 other subscribers

Srinimf

Srinimf

  • DISTINCT Vs. COLLECT_SET: Top Differences

    Sep 22, 2024

    ·

    PySpark, SQL
    DISTINCT Vs. COLLECT_SET: Top Differences
  • 3 Free Python Downloads – Here’re Links

    Ipython you complete open source software. You can download quickly to start learning. Read More ⇢

    3 Free Python Downloads – Here’re Links
  • Unix: Top Editor Commands to Schedule Job and More

    Unix cron top commands to use in scheduling jobs Read More ⇢

    Unix: Top Editor Commands to Schedule Job and More
  • Mainframe ISPF Commands (5 Of 5)

    How do I make columns 1-6 disappear from my ISPF editor screen?   A. Type ‘NUM ON COB’. These are the ‘COBOL numbers’ columns and the screen display will be from Col 9-80. 42. How do I make the numbers on Col 1-6 contiguous, i.e., the COBOL numbers A. Type ‘RENUM’. ISPF sometimes… Read More ⇢

  • 2 More Ideas on COBOL Debugging

    Here’s a way how to debug COBOL program Read More ⇢

    2 More Ideas on COBOL Debugging
  • Mainframe ISPF Commands(4 Of 5)

    1). How do I find for any non-numeric character? A. Use picture string ‘-’. 2). How do I find for any alphabetic character? A. Use picture string ‘@’. 3). How do I find for any uppercase alphabetic character? A. Use picture string ‘>’. 4). How do I find for any lowercase alphabetic character? A. Use picture… Read More ⇢

    Mainframe ISPF Commands(4 Of 5)
  • Grouping Sets: How to Simplify SQL Query

    THE GROUPING SETS option’s real usage is to make the union of two or more groups of rows into a single result set. Introduced in DB2V11. The best example given and explained to use it and improve your SQL Query. Grouping Sets in DB2 It is logically equivalent to the… Read More ⇢

    Grouping Sets: How to Simplify SQL Query
  • What is EIB Storage Area in CICS

    The EIB is also called executive interface block. The name tells that it is a interface to calling module. So the every action will be updated in EIB fields in CICS. I have given the most frequently used fields to execute CICS programs for your ready reference. Read More ⇢

    What is EIB Storage Area in CICS
  • Writing Transaction File to Master File in COBOL- 8 Tips

    COBOL-Master file-Transaction file. Many interviews these questions are asked in COBOL, transaction file and master file. Easy ideas I have given for your sure success in your interviews. MASTER FILE Master files contain the entire data of a particular application. For example, a master file may contain the entire data… Read More ⇢

    Writing Transaction File to Master File in COBOL- 8 Tips
  • SQL Before Drop a Column Here are The Conditions to Check

    ALTER statement we can use in DB2 SQL query to drop a column. ALTER TABLE table_nameDROP COLUMN column_name But, there are lot other conditions involved, which column we can drop or not. The containing table space is not a universal table space. The table is a created global temporary table.… Read More ⇢

«Prev
1 … 155 156 157 158 159 … 235
Next»

About Srinimf

We share solutions for software developers and interview questions.

2,745,807 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 268 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