• Facebook
  • twitter
  • Instagram
Search

Srinimf

Tech. Jobs. Biz. Success

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

Tag: DB2 Tips and Solutions

DB2 Special Registers
  • DB2

Quick Guide: DB2 Special Registers Best Examples

  • by Srini
  • Posted on November 24, 2019April 17, 2020

Real time best examples on DB2 special registers.

Read More
SQL queries in db2
  • DB2

More on DB2 Derived Table

  • by Srini
  • Posted on March 6, 2019April 1, 2021

Derived Table in DB2 is a solution to avoid complex SQL query. After deriving you use that table whenever you need in that main SQL query.

Read More
db2 date sql
  • SQL

SQL : EXTRACT Function to Get Month, Day, Year

  • by Srini
  • Posted on January 28, 2019July 17, 2020

SQL DATE and Time comparison popular styles and SQL queries useful to read for your project.

Read More
DB2 Load Utility
  • Mainframe DB2

Top DB2 Load Utility Interview Questions

  • by Srini
  • Posted on January 15, 2019April 17, 2021

Load utility in DB2, to load bulk data, very popular. The questions given in this post are useful for interviews.

Read More
Locks vs Concurrency
  • DB2

Locking Vs Concurrency top database mechanism you need to know

  • by Srini
  • Posted on December 16, 2018April 17, 2020

Locks and Concurrency are tricky words. Understand the real purpose of these mechanisms for better use of database.

Read More
Catalog tables DB2 Zos
  • DB2

How DB2 Catalog Tables Update When SQL Query Starts

  • by Srini
  • Posted on November 18, 2018April 1, 2021

SYSIBM catalog tables are base tables defined under this schema. There are many schemas defined in DB2. To your quick reading, I have given all the key points here.

Read More
Index vs Hashing
  • DB2

DB2: Index Vs Hash Top Differences

  • by Srini
  • Posted on November 1, 2018September 13, 2020

Data access is much faster in Hashing compared to the index. Read the differences between Hashing and Index.

Read More
Having Cluase
  • SQL

Everything You Ever Wanted to Know About Sql Having vs Where

  • by Srini
  • Posted on October 21, 2018July 26, 2019

Having Vs Where clause in SQL real usage is to filter rows on aggregate totals. Read more.

Read More
  • Mainframe

DB2 Certification focus more on these questions now

  • by Srini
  • Posted on April 19, 2018April 23, 2018

Mostly asked certification questions in DB2. You need more focus on these areas before you take the test.

Read More
  • Mainframe

How to Write COBOL with DB2 Program

  • by Srini
  • Posted on March 18, 2018April 15, 2021

Steps you need while embedding DB2 in COBOL or PL/I

Read More
Delete SQL Query
  • Mainframe

How to Write Delete SQL Query Correctly

  • by Srini
  • Posted on March 8, 2018February 8, 2020

You need to know these SQL query and rules to delete a row from a Table in DB2 database

Read More
  • DB2

Fetch first 1 Row only real usage in DB2

  • by Srini
  • Posted on February 25, 2018April 2, 2018

In DB2 database there are many ways to achieve performance. I explained one way here. Read more.

Read More

Posts navigation

Page 1 Page 2 … Page 12 Next Page

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,888 other followers

Popular Posts

  • SQL Query: How to Use LOCATE and Substring Correctly

    April 18, 2021
  • How to Answer these 6 Python Questions

    April 11, 2021
  • Python Logic to use tell() and seek()

    April 4, 2021
  • 11 Kafka Admin Interview Questions

    March 27, 2021
  • 10 Top SQL Set Operator Rules

    March 21, 2021
  • How to Install HBase Properly

    March 14, 2021
Consult Naturopathic Doctor
Consult Naturopathic Doctor
Search your dream jobs here
Search your dream jobs here
Learn for your future. Thousands of courses from $11.99
Advertisements

About Srinimf

We share solutions for developer day to day problems and interview questions.

Blog Stats

  • 1,601,026 hits
© 2010-2021, Srinimf.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,888 other followers

Srinimf Top Articles

  • How to Answer these 6 Python Questions
  • Python Logic to use tell() and seek()
  • 11 Kafka Admin Interview Questions
  • SQL Query Examples on Multiple WHERE Conditions
  • AWS
  • CentOS
  • Hadoop
  • IMS DC
  • Quiz
  • Blockchain
  • DB2
  • COBOL
A WordPress.com Website.
×
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
Cancel

You must be logged in to post a comment.

Loading Comments...
Comment
    ×