Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • DB2-Stored Procedures – Examples

    Complete resources on DB2 stored procedures: http://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html http://solutions.devx.com/ibm/skillbuilding/archives/walkthrough-creating-stored-procedures-in-db2.html http://www.toadworld.com/platforms/ibmdb2/w/wiki/7467.creating-stored-procedures.aspx http://www.quest.com/quest_central_for_db2/pdfs/db2storedprocsandudfs.pdf There are two types of stored procedures: External stored procedures – It is written other than SQL language. For example C, JAVA. After compiling stored procedure we need to register it to DB2 Internal Stored procedure –  It is written in SQL, and it is…

  • Mainfrmae MVS Abend Codes

    Top abend codes popular in Mainframe MVS

  • DB2 – How to Bind a Package in Remote System

    The local and Remote binding in DB2 is a real time concept. It occurs when you deal with remote packages created elsewhere not in your local region.

  • JCL Mainframe Advanced Tips on Procedures or Procs

    The JCL quick tips to implement in mainframe projects and highly useful for senior developers.

  • 5 Tips to Become Expert in SQL

    Follow these tips to learn SQL quickly. These are proven tips. Read more.

  • 10 Most Popular Analytics Applications Trending Now

    Big data and analytics is a trending skill. There are many kinds of analytics applications being used in business. This is one kind of interview question.

  • Excel Tutorials for Business Analytics

    Microsoft Excel analytics of step-by-step guide [http://www.ictlounge.com/work/practical_workbooks/data_analysis_step_by_step_booklet.pdf] Excel for data analysis [http://www.sagepub.com/bachmanfrccj2e/study/resources/Appendix_f.pdf] Data analysis using SQL and Excel [http://www.temida.si/~bojan/MPS/materials/Data%20Analysis%20Using%20SQL%20and%20Excel.pdf] Excel analysis tools [http://home.business.utah.edu/mgtdgw/stat5969/Analysis_Tools.pdf] Excel analytics and Statistics [http://www.casact.org/education/annual/2011/handouts/c15-16-statistics.pdf]

  • JCL Mandatory Parameters in JOB Card

    Here are the JCL parameters that you need to use in Job card. 1. Positional parameters //jobname job (acctinfo),programmer-name The above are Positional parameters, they must be coded in the sequence. //Stepname Exec PGM=abcd or Proc-name//Stepname DD DSN=ABCD//Stepname DD SYSOUT=* 2. Additional Points More than one job can be submitted from the same JCL. After…

  • 6 Must Read DB2 PLAN Interview Questions

    What is DB2 PLAN, and why do we need it? Below, you will find detailed answers. These are helpful for your interviews. DB2 PLAN Interview Questions PLAN –  Is an executable DB2 object. A DBRM you can bind directly to a PLAN or a PACKAGE you can bind it to a plan. In the BIND cards,…

  • DB2 Training by Themis inc | Review

    DB2 top training for you a review

  • Three Tips for Responding to Failure

    Really good article on how to respond to failure. Read more here.

  • IMS DB Accessing Databases: DLI Vs. DEDB

    DL/1 databases provide a hierarchically structured database, that can be accessed by record or sequentially. These are the ways to selected correct database for IMS DB.