jitendraprajapati

• Jan 25th, 2007

Try this --All PK and Constraints Select * from SYSCAT.COLUMNS;--All references (FK)Select * from SYSCAT.REFERENCES;

Regards,
Jitendra

Answer Question  Select Best Answer

SspSsp

 Profile Answers by SspSsp Questions by 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...

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

During precompilation of a COBOL program with SQL queries, the SQL statements and COBOL codes are separated. The timestamp during precompilation helps in identifying the corresponding versions of thes...

Answer Question  Select Best Answer

sainathkb

 Profile Answers by sainathkb Questions by sainathkb

• Jul 25th, 2008

This error related to db2 table access, please check you have access to all?the table which are using in your program.I face this problem in my exp and? i resolved this by communicating with on-site and DBA

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Search for the table name in the DB2 table SYSIBM.SYSINDEXESSELECT * FROM SYSIBM.SYSINDEXES WHERE NAME = 'tablename'  OR CREATOR = 'creator name' ;

Answer Question  Select Best Answer

kalone

 Profile Answers by kalone Questions by 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.

Answer Question  Select Best Answer

a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2.
All the above can access DB2.

sdresh

 Profile Answers by sdresh Questions by sdresh

• Apr 3rd, 2008

All the given environments caln access db2

Answer Question  Select Best Answer

a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor

sdresh

 Profile Answers by sdresh Questions by sdresh

• Apr 11th, 2008

DBD stands for database descriptor

Answer Question  Select Best Answer

a.No rows were selected.b.DB2 not operationalc.SQL completed successfully.d.SQL cannot be executed because program not bound.e.No SQL statements were input.SQL completed successfully.

bittumadhu

 Profile Answers by bittumadhu Questions by bittumadhu

• Mar 6th, 2008

Sql completed successfully

Answer Question  Select Best Answer

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

veluvpv

 Profile Answers by veluvpv Questions by veluvpv

• Apr 16th, 2009

DeadLock

Answer Question  Select Best Answer

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

 Profile Answers by kalone Questions by 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.

Answer Question  Select Best Answer

DB2 is aa.Database/Data Communication Systemb.Databasec.Relational Database Management Systemd.Programming Languagee.Operating systemRelational Database Management System

sumit_tumba

 Profile Answers by sumit_tumba Questions by sumit_tumba

• Jan 16th, 2008

C)Relational Database Management System

Answer Question  Select Best Answer

i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both are True2 i) is only True3 ii) is False Both are True

a_barwa1

 Profile Answers by a_barwa1 Questions by a_barwa1

• Jun 27th, 2008

Both are true.

Answer Question  Select Best Answer

Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree
B - Tree format

sumanthvm

 Profile Answers by sumanthvm Questions by sumanthvm

• May 27th, 2009

B tree by default in DB2 UDB for LUW

Answer Question  Select Best Answer

i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

Both Are False

Answer Question  Select Best Answer

What are memory structures used to handle multiple row selections at a time 1 Cursors2 Host Variables3 Indicator Variable4 SQLCACursors

Mahi

• Apr 6th, 2017

1 Cursors

Answer Question  Select Best Answer

1 Declare / fetch / open / close2 Open / Declare / fetch /close3 Declare / open / fetch /close4 None of the aboveDeclare / open / fetch /close

srinu_ramu

 Profile Answers by srinu_ramu Questions by srinu_ramu

• Dec 18th, 2007

3. Declare/open/fetch/close

Answer Question  Select Best Answer

Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

Yes.All of the Choices

Answer Question  Select Best Answer

ltaylor1

 Profile Answers by ltaylor1 Questions by ltaylor1

• Oct 28th, 2009

Creating a view of the EMPLOYEE table without the phone number.

Answer Question  Select Best Answer

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

 Profile Answers by mkumarshashi Questions by mkumarshashi

• Jan 21st, 2010

DB2 Application Development is required on the client machine to run the stored procedure.

Answer Question  Select Best Answer