-
Can anyone tell me when do we need a COLLECTION? I know the concept of PLAN and PACKAGE, but unable to understand about COLLECTION.
sethy.pradeep
- Nov 18th, 2008
Collection is generally used for grouping of db2 packages.For each collection there is one collection id should be created.
-
What is the difference between package and plan?
kamalbasha
- Nov 26th, 2015
The main difference between the plan and package is in db2+cobol pogramm we undergo precompilation because the compiler could not understand the statements are in between EXEC and END-EXEC so we go fo...
Mandar Dindorkar
- Jul 27th, 2012
the difference is that a Package is at a more granular level. If a module is bound to a Package, any change in module requires only the Package to be re-bound, without the necessity to re-bind the ent...
-
What happens when more than one row satisfies a Select statement that is executed outside of any cursor processing?
pawan_singh
- May 14th, 2010
If you using just a simple select SQL statement and it is giving you more than one row as output than you will get a SQL code retrun -811. To avaoid this depending your requirement you can modify your query or if you need more than one row than just use cursor.ThanksPawan
-
DB2 control structure
A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String
Thread -
What is the full form of DBRM ?
a.Database Restrict Modelb.Database Resurrect Modelc.Database Request Moduled.Database Reference Modulee.Database Restrict ModuleDatabase Request Module
-
DB2 Index Space
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space
Single index only -
What is the result of the following statement?
Given the following transaction in an embedded SQL application: CREATE TABLE dwaine.mytab (col1 INT, col2 INT) INSERT INTO dwaine.mytab VALUES (1,2) INSERT INTO dwaine.mytab VALUES (4,3) ROLLBACK What is the result of issuing the following statement? SELECT * FROM dwaine.mytab
-
DB2 Large Objects (LOB) Columns
In DB2, Large Objects (LOB) Columns are used to store large objects (Documents, pictures, voice, and mixed media) in database. Which of the following clauses can't be used on LOB columns?a) GROUP BYb) HAVINGc) ORDER BYd) NONE OF THE ABOVE
kris mohan
- Sep 13th, 2011
None of the above
-
Bind process
What happens during pre-compilation and finally bind process?
naga1126
- Jun 16th, 2010
Bind process is mainly for two processes:1. To syntax check the Query (To see the Columns and tables referred are actually present etc. )2. To find the efficient access path.Result of Bind is an Executable form of the DBRM.
yuvaevergreen
- Apr 11th, 2010
Precompilation:Separates out the SQL statements in the COBOL program and creates the DBRM.BIND:Creates the executable format of DBRMs.
-
Exec sql and End exec
why do we declare include in between exec sql and end exec and why cant we declare copybook in place of include. Is their any reason why we declare include only
ABSS1981
- Sep 18th, 2009
In addition to the answers posted one of the additional things to have an INCLUDE between EXEC SQL and END-EXEC is that:You INCLUDE most likely will be a DCLGEN and it is going to have non COBOL langu...
memays
- Apr 30th, 2009
It all has to do with the sequence of compiling a program with imbedded SQL. It is important to understand that a COBOL program with SQL statements will actually go through 2 steps in the ...
-
Referential Integrity
Which one of the following does not help to maintain referential integrity?a. Unique constraintsb. Primary keysc. Cascading actions d. Foreign keys
-
What is DCLGEN?
DCLGEN stands for declarations generator; it is a facility to generate DB2 sql data structures in COBOL or PL/I programs.
-
I have 1000 records in vsam,I want to read records 500 to 900?
prasenjit_in
- Sep 2nd, 2008
last 2 who answered the query didnt you see that its a VSAM based question...dont just put up anything and everything.
-
What is a DB2 bind?
A DB2 bind is a process that builds an access path to DB2 tables.
-
How to read last record in vsam file.,I don't know how many records are there?
BrantleyL1
- Jul 27th, 2011
This only works in CICS. Batch programs do not have the read previous record option.
-
Suppose there is cobol-db2 program.I made changes only in the cobol program.Is there need recompile the DBRM again?why?
mail_mathewsonyc
- Sep 1st, 2007
Hi,when you first compile a cobol-db2 program the cobol precompiler seperates all your cobol statements and DB2 statements into two seperate modules.The module containing the DB2 statements is ca...
-
-
DB2 Cursor Stablity
i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency1 Both are True2 i) Is Only True3 ii) is only True4 Neither is TrueBoth are True
-
Given a read-only application that requires consistent data for every query, which isolation levels should it use to provide the most concurrency with other applications doing updates?
Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates? A. Read Stability B. Repeatable Read C. Cursor Stability D. Uncommitted Read
-
Db2 pre-compiler
What is a db2 precompiler?
veluvpv
- Apr 16th, 2009
I would like to add few points to it, during pre-compilation process it creates an consistency token (not time-stamp) between bind package and load module.
DB2 Interview Questions
Ans