Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • Informatica: Know These 6 Benefits of Unix Shell Scripts

    The Unix Scripting where in ETL projects will be used explained in easy to understand way. Really a quick refresher for you to gain knowledge quickly.

  • PLI program using DB2 top ideas

    You can write SQL queries in PLI programs. Cursors are mostly being used in almost all mainframe projects. The given awesome DB2 cursor examples really useful to use in your projects readily. Read more.

  • 14 Top PLI Interview Questions

    Top 10 PLI interview questions asked in all Mainframe interviews for all experiences levels. The questions are given in key points, and for you it is ready reference area where you can explore more points.

  • How to create sort card with IKJEFT01 utility?

    The following JCL will help you to create sort card dynamically. //jobname   job (acct info),’srinimf’,notify= //* //Joblib        DD  DSN=abcd.abc.abcd //* //step1  step   exec pgm=IKJEFT01 //* //output     DD    DSN=output dataset //sysin    DD   * select sort_cntl from (cast(‘xxxxxxxxxxx’) as char(70)) as sort_cntl from sysibm.sysdummy1 union all . . . . ) x with UR; This way using CAST…

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