Srinimf

Advertisements

PySpark When Check Numeric of Column [Tested]

Jul 20, 2024

·

PySpark

DB2 SQL Join: Here are Best Practices

Top performance tuning tips you need to follow while writing SQL queries using JOINS. Read more. Read More ⇢
Teradata best utility Active Load

These methods exercise such Teradata Database features as queue tables and triggers, and use FastLoad, MultiLoad, TPump, standalone utilities, and Teradata Parallel Transporter Read More ⇢
M204 – Model 204 Database

The complete tutorial for M204 also called model 204 database. Model 204 is a database management system for IBM and compatible mainframe computers, “born” 1965 October 13, and first deployed in 1972. Read More ⇢
How to Use Multiple Joins in SQL: Best Example

Here is the best example of writing an SQL query with multiple JOIN statements. SQL Query with multiple Join Statements Related Read More ⇢
COBOL – SQLCA is Not Mandatory- Why

SQLCA – Also called SQL communication is area, is not mandatory in COBOL Program. 01 SQLCA. 05 SQLCAID PIC X(8). 05 SQLCABC PIC S9(9) BINARY. 05 SQLCODE PIC S9(9) BINARY. 05 SQLERRM. 49 SQLERRML PIC S9(4) BINARY. 49 SQLERRMC PIC X(70). 05 SQLERRP PIC X(8). 05 SQLERRD OCCURS 6 TIMES… Read More ⇢
List of Mainframe User Companies Worldwide

http://www.sysed.com/tech_assessments/leader/mainframe_legacy_systems.asp Read More ⇢
How to Rank the Output Using Over Partition By DB2 SQL

How to rank the data in the output using partition by statement in DB2 SQL query Read More ⇢
Best JCL Interview Questions – Splitting Input File

Sample JCL for SORT and more interview questions. Read More ⇢
DB2 Functions POSSTR Alternative to LOCATE

LOCATE and POSSTR string functions in DB2 Read More ⇢