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

anilsreepad

 Profile Answers by anilsreepad Questions by anilsreepad

• Mar 25th, 2009

Generate DDL [using db2look utility]

Answer Question  Select Best Answer

When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG ODBC DATA SOURCE

betsysam

 Profile Answers by betsysam Questions by betsysam

• Aug 5th, 2008

Catalog Node

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer

What are the flavours of DB2?

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 17th, 2008

Oracle, Siebel like all relational databases are flavours of db2.

Answer Question  Select Best Answer

What is meant by locked space? Describe locking concepts?

vjjammi

 Profile Answers by vjjammi Questions by vjjammi

• Aug 25th, 2010

DB2 Supports Locking mechanism at three levels. 1. Space Level. 2. Table Level. 3. Page Level. The above hierarchy has some significance and in order to lock a page at the higher level, you needn&#...

Answer Question  Select Best Answer

Can we divide it row wise or col wise.?is there any query for this.?

Mohit

• May 28th, 2012

You can table partitioning feature

Answer Question  Select Best Answer

shiv

• May 7th, 2012

4141... in decimal

Answer Question  Select Best Answer

If any DB2 column changed,how impact analysis can be done fo this?

asharm37

 Profile Answers by asharm37 Questions by asharm37

• Sep 20th, 2014

Impact Analysis for DB2 table change: 1.What is changing-If it is column size then find out all the programs using that column in them.ADJUST THE CODE ACCORDINGLY.If working storage value is being po...

Answer Question  Select Best Answer

How and why to use restart checkpoint logic. I am not able to understand the concept of checkpoint restart logic. please anyone explained it to me.

Sai

• Jan 27th, 2016

Check point, we have a check point for each run. or example if we are running some 100 data to be processed and we our job failed. Here in the check point we would have kept a check or every 10, so if...

Answer Question  Select Best Answer

How to find the occurrence of letter A in the name field of a table using SQL?

sudamj

• Apr 20th, 2016

INSTR function will help if you mean to search A in the column value and NOT in table name

Answer Question  Select Best Answer

How to handle a non-matching column (which is NULL) in outer joins. My site standards prevent the use of Null indicator.

Shanthi G

• Jan 29th, 2019

If any column is null we need to declare null indicator of S9(04) comp for that . if you not mention null indicator while fetching record that is null it shows -305 error.

Answer Question  Select Best Answer

An intent lock is at the table level for a segmented tablespace or at the tablespace level for a nonsegmented tablespace. They indicate at the table or tablespace level the kinds of locks at lower levels.

kalyan satya A

• Jun 7th, 2005

How to eliminate duplicate rows from a table leaving one from the duplicates

Answer Question  Select Best Answer

javid

• Mar 20th, 2006

Cascade rule is one of the RI constraint. Which allows deletion of FK from the Dependent table if the PK from the parent is deleted. If we try to delete record from the parent that is not in the child we will see abend code -532.

Answer Question  Select Best Answer

The explain statement provides information about the optimizer's choice of access path of the sql.

Prasanth

• Jun 28th, 2006

The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE ...

Answer Question  Select Best Answer

Referential integrity refers to the consistency that must be maintained between primary and foreign keys, ie every foreign key value must have a corresponding primary key value.

Tapastapu

 Profile Answers by Tapastapu Questions by Tapastapu

• Aug 11th, 2006

The relation of the primary key of  a base table with foreign key of the reference table is known as referential integriety.

Answer Question  Select Best Answer

Nimesh

• Oct 4th, 2005

u can display index in DB2 using syscat.sysindexes & syscat.syskeys system tablesthe common linking columns in the tables being tbname (table name) and tbcreator.

Answer Question  Select Best Answer

anuj32003

 Profile Answers by anuj32003 Questions by anuj32003

• Jan 24th, 2006

Subroutines are generally used when same piece of ode is required in arious pgs It ay or may not have the business logic.

Answer Question  Select Best Answer

Shayer

• Jun 6th, 2005

Index is a mechanism that allows to search data quickly. In SQL Server 2000, two kinds of index are there : 1 : Clustered Index (only one) 2: Non Clustered Index(up to 249)

Answer Question  Select Best Answer

muthukumar.R

• Mar 3rd, 2006

Record will be appeand in the file.

Answer Question  Select Best Answer

Navaneetha krishnan

• Jun 21st, 2006

Do u want the the list of error codes in Cobol or jcl or Vsam of Db2 or cics?

Answer Question  Select Best Answer