Srini

How to Create Webservice in CICS

Here is a helpful list of steps to develop web services in CICS explained in this article.

How to Print N numbers in a List in Python

Here is a Python logic that prints N numbers as per user input. Useful for interviews and written tests

Basic Training: CICS and IMS DB Books You need

Here are the two best books useful for CICS and IMS DB learners.

How to Set Environment Variables in Linux

Linux programmer’s handy information on local and global variables, and the commands needed to view those.

Everything You Need to Know [About] Alter Index in DB2

Here is an SQL query to alter an index in DB2. When to drop the index and when not required while altering the index, added guidelines for your reference.

How to Search Oracle Database for Column

Here is a helpful SQL query to find a Table name in the database for a column. Useful for error fixing or bug fixing.

7 Need to Know Python pdb Debugger Commands

Here are the seven top python pdb commands. Helpful to use these commands at the pdb command line. Each one is explained with the result.

How to get DATE Only From DATETIME Column

Here is an SQL query to get only Date from the Datetime column. This is tested in Oracle. Also, added SQL query to get both Date and Time.

Understand Flashback Table in Oracle to Recover Deleted Data

Flashback table is an advanced concept in Oracle. With which you can recover data till a specific point in time. Here are the basic architecture and handy SQL queries that you need.

How to Slice a String [Substring] in Python

String slicing examples in python. The methods are positive, negative slicing, with single and double colon operators.

7 Daily Use Python String Functions

In Python, string manipulation methods include find, validate, concatenate, change case, split, replace, and strip.

How to Use Merge Statement in SQL Query: Best Examples

In SQL, MERGE is the latest statement. You can include all UPDATE, INSERT and DELETE statement in single query. Major RDBMS databases support this statement.