Srinimf

How to Work With DATE FORMAT: Top MySQL Examples

Oct 3, 2024

·

mysql

MQSeries Tutorial for Mainframe Programmers (1 of 5)

MQSeries is most popular in case of mainframe environment to interface with the Open system applications. So that mainframe is capable to interact with modern front end applications. MQSeries is the best tools and this tutorial really good to all the developers. Read More ⇢
SQL code -180 DATE, TIME, OR TIMESTAMP Value is Invalid

SQL error code -180 reason and quick resolution. Read More ⇢
Top DB2 Concurrency Issues Lost Updates, Dirty Reads, Phantoms

When transactions are not serializable (which is often the case in multi-user environments). Lost Updates: This event occurs when two transactions read the same data and both attempt to update that data, resulting in the loss of one of the updates. For example: Transaction 1 and Transaction 2 read the… Read More ⇢
COBOL: How to Initialize Pointer Variable an Example

COBOL pointer variable is one kind of data type. Initialization and how to use them you will know in this post. Read More ⇢
How to find a member in list of datasets

If you want to find a member but you don’t know the PDS to which it belongs and you only know the High level qualifier of the PDS. For example: Let’s consider High level qualifier as RF01.pp258c.* and member as RG57TDLT. Go to 3.4 and list all PDS with RF01.pp258c.*… Read More ⇢
How to keep command does not disappear in TSO command line

Any command entered in the COMMAND LINE disappears after the successful execution of its intended function. If you want to repeat the same command , you got to re-type it or use some PF key to retrieve the last command entered. But here is a cool method the make the… Read More ⇢
DB2 Bind Option ACQUIRE – The Real Purpose

ACQUIRE bind tetrameter real usages Read More ⇢
How to know Your Version of DB2 in Mainframe

DB2 Version in Mainframe Read More ⇢
DB2 CHECK DATA Utility, Here’re Top Features

Utilities in DB2 checks data consistency while loading data into Tables. CHECKDATA utility has two top functionalities. It checks for referential integrity and Data validation constraints. Features of CHECKDATA Utility 2 Top Features The CHECK DATA option checks the violation of the referential integrity rules between two tables. It also… Read More ⇢