• Facebook
  • twitter
  • Instagram
Search

Srinimf

Tech. Jobs. Biz. Success

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

Tag: DB2 Tips and Solutions

DB2 Special Registers
  • DB2

These are the Special Registers in DB2

  • by Srini
  • Posted on November 24, 2019January 4, 2023

Real time best examples on DB2 special registers.

Read More
SQL queries in db2
  • DB2

Derived Table Vs. Sub-Query – Here are Top Differences

  • by Srini
  • Posted on March 6, 2019October 23, 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: How to Get Month, Day, Year

  • by Srini
  • Posted on January 28, 2019December 30, 2022

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

Read More
  • DB2

Concurrency In DB2: 4 Locking Mechanisms

  • by Srini
  • Posted on December 16, 2018October 15, 2021

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

Read More
  • DB2

DB2 5 Schema Names Where all Catalog Tables Present

  • by Srini
  • Posted on November 18, 2018September 21, 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

What’s the Difference Between Index and Hash in DB2

  • by Srini
  • Posted on November 1, 2018September 3, 2022

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

Read More
  • SQL

SQL: Having Vs WHERE Top Interview Question

  • by Srini
  • Posted on October 21, 2018June 8, 2021

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

Read More
  • Mainframe

Here are Top Questions – Useful for DB2 Certification

  • by Srini
  • Posted on April 19, 2018October 26, 2021

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 Program with DB2

  • by Srini
  • Posted on March 18, 2018May 14, 2022

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

Read More
  • Mainframe

How to Delete a Row: SQL Explained

  • by Srini
  • Posted on March 8, 2018December 30, 2022

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, 2018October 16, 2021

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

Read More
Table Space
  • Mainframe DB2

Logical Storage in DB2 and Its Real Usage

  • by Srini
  • Posted on January 14, 2018November 19, 2022

Table spaces are completely logical in any database. Many developers confused that they always access data from physical storage. But actually that is not correct. So this post clarifies how to define a table with logical storage. Sample SQL really helps you to understand quickly.

Read More

Posts navigation

Page 1 Page 2 … Page 11 Next Page
Advertisements
Udemy UK
Advertisements
Search your dream jobs here
Search your dream jobs here
Advertisements

About Srinimf

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

Blog Stats

  • 2,274,648 hits
© 2010-2023

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

Join 1,958 other subscribers
Naturopathy Doctor
  • AWS
  • CentOS
  • Hadoop
  • IMS DC
  • Quiz
  • Blockchain
  • DB2
  • COBOL
  • Podcast
A WordPress.com Website.
×
  • Follow Following
    • Srinimf
    • Join 234 other followers
    • Already have a WordPress.com account? Log in now.
    • Srinimf
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
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
 

Loading Comments...
 

You must be logged in to post a comment.