-
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.… Read More ⇢
-
Hadoop Ecosystem – MapReduce Internal Process
What is MapReduce in Hadoop. Read now complete Process and its components. Read More ⇢
-
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… Read More ⇢
-
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 ⇢
-
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 ⇢
-
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 ⇢
-
COBOL: How to Code Logic To Insert Multiple Rows
Multiple rows you can insert using arrays in COBOL program into DB2 tables Read More ⇢
-
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 ⇢
-
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 ⇢
Advertisements
Srinimf 