Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • How to Connect CICS to DB2 Top Ideas

    Connect CICS to DB2 top ideas you need

  • DB2 Distributed Systems in Zo/S

    Distributed the term is very big and a lot of information needs to be considered. Although there are many other ways that distributed clients can access DB2, they are entering through other attach types, such as CICS, IMS, MQ, and RRS.  Distributed Systems These are beyond the scope of this presentation since they are subject…

  • How Autoinstall Works In CICS Without PPT Entry

    In CICS with AUTO INSTALL option we no need to define each program/map to PPT entry. If Autoinstall is yes, CICS will dynamically install the definition for program/map when requested. If AUTOINSTALL is active, whenever those programs/maps requested, the definitions will be installed by CICS dynamically. The following scenarios AUTOINSTALL works: EXEC CICS LINK EXEC…

  • CICS: GETMAIN Vs. Load Top Differences

    LOAD vs GETMAIN differences you must read before you start your program

  • RDBMS: Schema Vs Instance Top Differences

    Schema in RDBMS A schema is a collection of named database objects. Schemas provide a way to logically classify objects such as tables, views, triggers, routines, or packages. A schema name is used as the first part of a two-part object name. For example, if the EMPLOYEE table is created under the schema name JENNIFER,…

  • DB2 V11- Analytics and Bigdata Features

    DB2 11 also boasts new features for supporting big data and analytical processing. Probably the biggest is the ability to support Hadoop access. DB2 11 can be used to enable applications to easily and efficiently access Hadoop data sources using the generic table UDF capability to create a variable shape of UDF output table. Doing…

  • How to Use Fetch First ‘n’ Rows Best Examples

    SQL Query On How to Use Fetch SELECT LASTNAME, FIRSTNAME, EMPNO, SALARYFROM EMPORDER BY SALARY DESCFETCH FIRST 20 ROWS ONLY; How To use FETCH FIRST n ROWS ONLY within a subquery. SELECT * FROM EMPWHERE EMPNO IN (SELECT RESPEMP FROM PROJECTORDER BY PROJNO FETCH FIRST 3 ROWS ONLY) Query transformations become most important for complex queries,…

  • DB2 PLAN_Bind Real Concept

    DB2 PLAN bind to execute DB2 programs in more than one sub system

  • DB2 Sub-system Vs. Instance: Top Differences

    DB2 Subsystem In DB2 S/390, a DB2 subsystem provides a separate DB2 environment similar to a DB2 ULWO instance. Several DB2 S/390 subsystems can be installed in the same machine logical partition (LPAR), and they can only communicate with each other through the Distributed Data Facility (DDF). (Data sharing provides another way that DB2 subsystems…

  • SQL: Truncate Vs Delete in DB2

    These 5 key differences in DB2 for TRUNCATE and DELETE help to understand much better of their functionality. A good refresher for DB2 developers.

  • Mainframe: How to Read a Tape File

    Tape files in mainframe are not readable. So this sample JCL you can use to copy to DASD file and you can read.

  • Sample SQL Query: How to Define Identity-Column

    Here are ideas on how to identity-column on a table. Identity column on a new table An identity column provides a way for DB2 to automatically generate a unique numeric value for each row that is added to the table. When creating a table where you know that you need to uniquely identify each row…