Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • 2 Best Ways to Use COND in JCL

    COND parameter in JCL you can give at STEP, JOB level. Read more details.

  • Where to Use Compiler Options in COBOL and CICS Program

    Compiler options to compile COBOL module or CICS module you can give before identification division. Then, compiler recognize your compiler options. Read more.

  • JCL: How to Skip Steps from Proc

    To skip a step from proc, I have explained the code you need to add in the JCL. So skipping proc steps this solution highly useful.

  • 32 Complex SQL Interview Questions

    Best and complex SQL queries for quick reference to apply in projects and for interviews. Read more.

  • What is Package in Oracle PLSQL

    Here is sample PLSQL package and what it is explained here.

  • Subquery Vs. Correlated Subquery – Top Differences

    Sub Query and Correlated Sub query the real differences and useful for Database or SQL developers

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

  • 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 from all the related tables.…

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