Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • 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 about the employees, payroll, or…

  • 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. The table is a system-period…

  • How to Write SQL to Create Global Variables

    Global variables new additions in Db2 v11 and how to create them read today.

  • How to Understand Cashback Rewards Program Quickly

    Benefit to cardholders if they use cashback rewards program. How this program works explained.

  • DB2 SQL Query Performance Tuning (3 of 3)

    SQL performance tuning tips for database developers. Read more.

  • DB2 INSERT’s Performance and What is Newly Added

    In DB2, performance affects on the size of the index. When you create an index, it is useful to exclude one or more values from being indexed – such as values that will never be used in a SQL query. For example NULL, blank, and 0. Improvement in Performance DB2 11 NFM can improve insert…

  • What are Array functions Read today

    Array functions in Db2 explained with how to use.

  • Mainframe ISPF Commands(3 Of 5)

    21) I am not able to delete a dataset that resides on a tape. A. Yes. You cannot delete/rename a tape dataset. Only you can uncatalog it. ISPF Editor 22) How do I see only those lines that contain a particular string? A. Type ‘X all’ then ‘F all ‘search-string’ 23) Now I want to…

  • IMS DB Interview Questions for Beginners

    IMS DB low complex interview questions for less experienced developers.

  • 5 More Frequently Asked DB2 SQL Queries

    Frequently asked SQL queries you need to know. Useful for SQL developer interviews.

  • Mainframe ISPF Commands(2 Of 5)

    In my series of posts, I am giving best ISPF tips to improve productivity. Across the companies following these tips.Mainframe+cobol+db2+jobs+USA+India+UK+ . Read my part-1 tips, if you missed. 11) How do I find out which base cluster does an alternate index file belong to? A. Display information in file aid for the ‘.PATH’ file which will show…

  • Top IMS DC Interview Questions for Experienced

    The best interview questions asked on IMS DC in all big companies in recruiting of IMS DC developers or programmers. Explained the best way and flow about IMS DC. Read more.