- Blog
- Blog
- Homepage
- Homepage
-
How to Debug COBOL Program in Xpediter
The best and really good tips that a programmer need handy of these tips while working on XPEDITER of debugging tool in Mainframe projects, Best for COBOL projects. Read more.
-
DB2V10-Temporal data System Time & Business Time
In any big business like Insurance,Finance and Banking, the need of data happened in particular time period is required. The business time indicates the period during which the data is accurate with respect to the world. The system time indicates the period during which the data is stored in the database. Business Time:Business time is applicable…
-
Hadoop Ecosystem – MapReduce Internal Process
What is MapReduce in Hadoop. Read now complete Process and its components.
-
DB2 v10 Onine Schema Changes
The term on-line schema means, we can alter the table with out dropping it: Changes made in Db2 v10. Altering a table space’s page size, data set size, segment size, and/or MEMBER CLUSTER structure Altering a simple table space with only one table to a partition-by-growth Universal table space Altering a segmented table space with only one…
-
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.
-
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 Cobol-Data Challenges(1 of 2) (srinimf.com)…
-
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 the VSAM data set will be…
-
COBOL: How to Code Logic To Insert Multiple Rows
Multiple rows you can insert using arrays in COBOL program into DB2 tables
-
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.
-
DFSORT: Convert Lower to Upper Case
DFSORT Overlay command to change input dataset values to desired format. Read more on how to use it.
-
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
-
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.
Srinimf 