Srini

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.

NEXT_DAY Vs DAYNAME Top SQL Examples

DATE calculation in SQL is tricky. Sometimes you need to find Day name, Day of the week, and Next Day Date. These example SQL queries useful for you.

SQL: How to Use Sub-query to Delete a Row

This post covers how to use WHERE and DELETE in sub-queries. Useful examples to refer to quickly.

How to Use TO_CHAR Function to Convert DATE

I have explained how to format DATE by using views.

The Ultimate Guide To Aws Shared Responsibility

Cloud computing is popular among the software services. AWS plays top role in the field of cloud computing. Explained AWS shared responsibility model in a way dummies can understand it quickly.

3 Neat SQL Queries to View Table Structure in DB2

Three top SQL queries you need to get Table metadata. Metadata means Table structure. That means to know indexes and columns of a Table in question.

Exclusive AWS ElasticCache Memory

I have explained how to implement Cache memory in AWS. It also explained in-memory data store Redis and its benefits.

SQL Inner JOIN By Two Columns Tricky Example

Simple ideas and quickly what you need to find to write a query for joining of two tables explained.

SQL Views: Tricky Interview Question Asked in Many Companies

In this post, I have answered one tricky SQL-view interview question. Views availability after the base table modified confuses many developers. I provided an answer to this.

How to Decode ISO 8583 Bitmap Message

How to calculate or decode which ISO Bits are present or not present in ISO 8583 message. I have explained in easy to understand method.

COBOL ‘EVALUATE ALSO’ Best Examples

Examples for COBOL Evaluate statement for multiple conditions.