Srinimf

PIVOT vs UNPIVOT: A Guide for PySpark and Pandas Users

Sep 20, 2024

·

PySpark

PLI Program: Process Options Real Usage (1 of 2)

The %PROCESS statement identifies the start of each external procedure and allows compile-time options to be specified for each compilation. The options you specify in adjacent %PROCESS statements apply to the compilation of the source statements to the end of input, or the next %PROCESS statement. To specify options in… Read More ⇢
How to Use REPAIR Utility in DB2

Here is all about REPAIR utility. It fixes data in tables and their related data structures. The data can be of any type, such as data contained in a table or data that is generally not accessed, such as map pages and index entries. DB2 REPAIR Utility REPAIR DBD: Tests… Read More ⇢
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 ⇢