• 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.

  • 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 REPLACE(‘222A55′,’2′,’3’)  FROM SYSIBM.SYSDUMMY1 RESULT: ‘333A55’…

  • 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.

  • 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. The software is designed to…

  • SQL INSTR Function Real Usage

    Syntax for INSTR function to extract index of position of sub-string from main string.

  • 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

  • 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 NOT TOP clause Identity /…

  • Start Up of You

    How do you survive and thrive in this fiercely competitive economy? You need a whole new entrepreneurial mindset and skill set. Drawing on the best of Silicon Valley, The Start-Up of You helps you accelerate your career and take control of your future–no matter your profession.                                       –Reid Halfman   By the book at discount…

  • 12 Data Mining Tools Helpful to Get Insights

    Here is a list of data mining tools help you know their key features

  • DB2 Large Object Data Types LOB

    Large objects datatype in DB2 are 3 types. Those are BLOB, CLOB, and DBCLOB

  • SQL- Functions and Return Code +100

    The four different types of SQL functions to read quickly and to get knowledge instantly.

  • Must Read Books to Start a Business

    Originally posted on Srinibiz: Everyone has a dream. Some people want to start business. Some want to get top position in the Job. Some want to become  expert in investing. But to make reality you need information. The question is where to get ? “Jerry Rao” founder of a Software company once told in an…