-
What is the difference between IN subselects and EXISTS subselect?
If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN. (IN for index is the mnemonic).
nlarsensmith
- Feb 22nd, 2011
***IN***IN subselects perform search on a list of values returned by the subquery.ex)select * from table1 where col1 IN(select col1 from table2 where <some condition>)-Based on the range of...
-
What is a DB2 access path?
An access path is the method used to access data specified in DB2 sql statements.
Mandar Dindorkar
- Jul 27th, 2012
DB2 Access path is (in most cases) the path which results in the most optimized execution of an SQL query. Whenever any Static SQL (Embedded SQL) is bound to a package/plan, the DB2 optimizer creates...
jzmoonrock56
- Aug 31st, 2011
The access path is determined by DB2 during the bind process. This determines what indexes will be used.
-
What is SPUFI?
SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.
Read Best Answer
Editorial / Best Answer
Answered by: burelamanohar
- Feb 6th, 2007
SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal
vineeta bachani
- Oct 17th, 2019
In SPUFI: we can store and write multiple queries but will execute only one at a time. here we mention user-defined input and output datasets
IN QMF: every time we open it we have to write the SQL query again. we dont give input and output datasets -
-
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 Interview Questions
Read Best Answer
Ans