-
What are db2 pre compilers?
kalone
- Jan 31st, 2010
DB2 pre-compiler extracts all the SQL stmnts from the appln prg and keeps them in DBRM and comments those SQL stmnts (in the appln prg) and replaces them with a CALL.
-
DB2 Table Delete Question
Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is deleted, the corresponding row from T2 also be deleted. Which option can be used? a.ON DELETE RESTRICTb.ON DELETE CASCADEc.ON DELETE SET NULLd.ON DELETE CHILDe.ON DELETE MATCHON DELETE CASCADE
kalone
- Jan 31st, 2010
ON DELETE CASCADE: If a row in the parent table is deleted, all the corresponding row in child tables will automatically be deleted.ON DELETE RESTRICT: The delete operation on parent table is restricted if there is a matching row in child table.So, ans to the above query should be ON DELETE CASCADE.
-
DB2 Index Space
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space
Single index only -
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure? A. DB2 Runtime Client B. DB2 Personal Edition C. DB2 Administration Client D. DB2 Application Development Client
mkumarshashi
- Jan 21st, 2010
DB2 Application Development is required on the client machine to run the stored procedure.
-
How to increase table space in db2?
Raghunathan Asari
- Jul 23rd, 2007
User ALTER command to change the PRIQTY and SECQTY of the Tablespace.Eg. ALTER TABLESPACE db.ts PRIQTY 50 SECQTY 50.Here PRIQTY => primary quantity in 50 KB and ...
-
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
-
What is the difference between DB2 and DB2 UDB?
SspSsp
- Oct 28th, 2009
The main difference between DB2 and DB2 UDB is that DB2 UDB has open DBMS connectivity to other open systems. I.e., though on a mainframe system, it can connect to Java, Unix and a variety of other op...
-
What is a cursor and what is its function?
An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row.
nnina
- Oct 12th, 2009
Cursor is a programming device. If you want to fetch more than one record from DB2 table it can be easily done with the help of cursor because single DB2 query fetch at a time one record if it find more than one records (Duplicate) it will gives -811 (trying to retrieve more than one row).
-
What is an alias and how does it differ from a synonym?
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
greeshmavarghese
- Oct 7th, 2009
Sysnonym can be used for the user who created it. But alias can be used for any users. Synonym is dropped when base table got dropped but alias will not get dropped.? Synonym is recorded in the sys.synonym table and alias is recorded in sys.tables.
sithusithu
- Jan 27th, 2006
An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu
-
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 ...
-
Which statements are executable in cursor syntax?
sethy.pradeep
- Nov 19th, 2008
Fetching cursor is the executeble statement in cursor syntax.Regards,pradeep
-
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 Index Storate Format
Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree
B - Tree format -
DB2 Index and Table Space
I) Index Space are created automatically when Index are created. II) Table Space are created automatically when Tables are created. Of the above statementBoth are True( I ) is Only True( II) is only TrueBoth are False( I ) is Only True
sumanthvm
- May 27th, 2009
You need tablespace created when you want to create index or Table.We cant create the table/Index in the table Spaces, thus both are false
-
DB2 transactions
Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is calleda.Lost Updateuncommitted dependencyinfinite loopd.Deadlocke.With holdDeadlock
-
Which can duplicate the structure and related objects of a DB2 database table?
Which of the following can duplicate the structure and related objects of a database table? A. Copy table B. Alter table C. Export table D. Generate DDL
-
DB2 plans
How many DB2 plans can be connected to CICS region at a time? a). Infinite b). 1 c). Depends on CICS region definitions d). 255 e). None of the above
sravanthivajpaee
- Jan 28th, 2009
Plans are allocated to transactions rather than regions. For every transaction there exsists an entry for the Plan in the RCT table.In a region multiple transactions can be present so multiple Plans can be holded to each region.
-
Explain difference between sys.cat and sys.ibm?
ruth suganya sebastian
- Jan 6th, 2009
sysibm is a default schema which has all the base tables and syscat is also a default schema which has the tables and views of sysibm objects...
uma
- Jan 23rd, 2007
hi, sys cat will give all data sets that are catalogged ang sys ibm will give all data sets.
-
What is isolation level?
SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.
ramanatcs
- Dec 24th, 2008
Isolation Level determines the duration of the lock over a page.3 level are there.1. Cursor Stability : lock is retained when untill the cursor moves from one record in one page to the next reco...
-
What are some sql aggregates and other built-in functions?
The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.
ramanatcs
- Dec 24th, 2008
STDDEV ( Standard Deviation )VARIANCE These are used in stastical calculations.
DB2 Interview Questions
Ans