Srini

DB2: Unique-index Vs Clustered-index

Indexes improve the performance of the database tables. However, this post covers differences between clustered index and unique index.

How to Move Decimals to Comp-5 in COBOL

How to use comp-5 data type in COBOL explained. Why it does not support decimals also explained with examples.

Full-auth Vs Partial-auth Reversals Simplified

Explained the differences between Full auth reversal and Partial auth reversals with examples.

How to Fix COBOL Value-clause and UNSTRING Errors

How to find Value clause and Unstring clause errors in COBOL. Explained with examples when you will notice these errors during compilation or execution time.

How to Use Common Table Expression [CTE] in DB2

I have shared the Common Table expression of advanced SQL. You can save a lot of CPU time. And you can improve query performance.

Differences Between Find and Locate in Linux

Explained the quick differences between Linux find and locate commands.

6 Top SQL Aggregate Functions Rules

Explained the complete features of SQL Aggregate functions.

10 DB2 QUIZ Questions

Useful DB2 Quiz questions for your next interview.

How to Call ‘DB2’ from Python

Python code example to connect DB2 database explained with example SQL query.

How to Debug Using ‘pdb’ in Python

Debugging in Python explained the commands you need. And explained the steps you need to start debug session.

How to CREATE and DROP User-defined Function in DB2

In this post you can find how to Create and Delete DB2 user-defined functions.

2 Top AWS Encryption Services: Key, CloudHSM

AWS does support encryption for your applications. You can find a variety of encryption methods in the market. But, AWS supports only two encryption methods. I have given top features of AWS encryption services supports.