-
SQL -904 Top Reasons to Get This Error
Resolution for DB2 SQL error -904 and real reason and fix on how to resolve error given in a way easy to understand by beginner to professionals. Read More ⇢
-
Joins and Their Types in DB2 SQL
Joins is a one of the key concept in SQL. In an RDBMS we have tables with one-one, one-many and many-many relationships. So the concept of RDBMS depends on relationship. Why do you need Joins In a Realtime environment, database architect will design relation between various tables. User needs collective data… Read More ⇢
-
How to Create VB File in COBOL
One of the best method to create VB files in COBOL. Really good stuff to and highly useful for all COBOL programmers. Read More ⇢
-
COBOL and SQL – Replace Command
Replace is most common in the production environment. There are many occasions we need to do data manipulation in the application programs. In Cobol: SOURCE-STRING: ‘HARE KRISH NARADA’ INSPECT SOURCE-STRING REPLACING ALL ‘H’ BY ‘#’ Result: ‘#ARE KRIS# NARADA’, similarly you can do for REPLACING BEFORE and REPLACING AFTER. In SQL: SELECT… Read More ⇢
-
DB2 SQL: LTRIM, RTRIM and TRIM best examples
The SQL functions are highly beneficial for SQL developers and ETL developers. Read best examples on TRIM, LTRIM and RTRIM. Read More ⇢
-
The Quick Thoughts on Data Warehousing Tool Cognos
In the present Global world data analysis is a leading job, and it helps business managers to take strategic decisions. Cognos is a tool; it helps to analyze corporate data, and to take ad-hoc reports from it (Source: Search CIO) Cognos is IBM’s business intelligence (BI) and performance management software suite.… Read More ⇢
-
SQL INSTR Function Real Usage
Syntax for INSTR function to extract index of position of sub-string from main string. Read More ⇢
-
6 Exclusive Cognos Tools to Know Where They Use in Data Analytics
Here is a list of Cognos data analytics tools available fin the market Read More ⇢
-
SQL Make Sure These in Your Course Curriculum
Source: It career coach SQL QUERY DEVELOPMENT MODULE 1: THE SELECT STATEMENT What is the SELECT statement? How to eliminate duplicate rows in SELECT statements How to sort or order results in SELECT statements FROM clause WHERE clause GROUP BY clause HAVING clause WHERE clause NULL, NOT NULL AND, OR… Read More ⇢
Srinimf 