Srinimf

  • DB2 V10-New Access Method~Hashing (1 of 2)

    The very basics about how hash access functionality works in DB2. This is simple and explained in better way. Read more. Read More ⇢

    DB2 V10-New Access Method~Hashing (1 of 2)

  • How to Use BPXWDYN Utility to Allocate File

    BPXWDYN is IBM supplied utility. The main use of it is we can dynamically allocate a file in the COBOL/PLi program. Cobol Program: 01 WS-TEXT     PIC X(55) VALUE   “ALLOC FI(OUT) DS(‘WORK.TAPE’) NEW KEEP UNIT(TAPE) REUSE”   After this, CALL BPXWDYN USING WS-TEXT. After calling this program, the said file will be allocated. Related articles… Read More ⇢

    How to Use BPXWDYN Utility to Allocate File

  • VSAM Quiz Questions Part-1

    All are latest questions. Check Quiz here. How to check VSAM dataset? EXAMINEYou can use the EXAMINE IDCAMS command to analyze and report on the structural integrity of the index and data components of a key-sequenced data set cluster (KSDS) and of a variable-length relative record data set cluster (VRRDS). Any problems with… Read More ⇢

    VSAM Quiz Questions Part-1

  • COBOL: How to Code Logic To Insert Multiple Rows

    Multiple rows you can insert using arrays in COBOL program into DB2 tables Read More ⇢

    COBOL: How to Code Logic To Insert Multiple Rows

  • DB2 Connect: How DB2 to Use as Distributed

    DB2 Connect’s purpose in life is to connect applications to data, not one database to another database. Read more. Read More ⇢

    DB2 Connect: How DB2 to Use as Distributed

  • DFSORT: Convert Lower to Upper Case

    DFSORT Overlay command to change input dataset values to desired format. Read more on how to use it. Read More ⇢

    DFSORT: Convert Lower to Upper Case

  • DB2- 5 Types of Utilities

    There are 5 kinds of Db2 utilities: Data Consistency utility: Check,Repair,Report,Diagnose Backup and Recovery Utility: Copy,CopytoCopy,Mergecopy,Quiesce,Recover,Rebuid index,Repair,Report recovery Data movement and Organization utility: Load,Unlod,Reorg Catologue manipulation utility: CATENFM, ATMAINT, DSNJCNVB, MODIFY RECOVERY, MODIFY STATISTICS, RUNSTATS,  STOSPACE Stand-alone utility:DSNJLOGF, DSNJU003,DSNJU004, DSN1CHKR, DSN1COMP, DSN1COPY,DSN1SDMP,DSN1LOGP,DSN1PRNT Read More ⇢

  • SQL Query Raise_Error Function- Here’s Best Example

    Raise error function secrets given in this post. It tells how to use Raise error function inside of Case statement in DB2 SQL query. Read More ⇢

    SQL Query Raise_Error Function- Here’s Best Example

  • 2 Ways to Earn Money in Software Job

    Basically software is a service based industry. Lot of brilliance and IQ not required. An average person can easily survive in this industry. Read more to earn money from IT job. Read More ⇢

    2 Ways to Earn Money in Software Job