sumit_tumba

 Profile Answers by sumit_tumba Questions by sumit_tumba

• Jan 16th, 2008

select * from table_name sample nn:1,2...100..that is used in Teradata....

xyz

• Aug 13th, 2007

We write the query as follows:SELECT * from table_namefetch first n rows onlywhere n is an integer value.

Answer Question  Select Best Answer

chanukya

• Aug 19th, 2011

You can write like top 50 percent after sorting.

please correct me if i am wrong...

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

For getting middle of rows for employee table first you should SORT the order of rows in a table after that you can put it skip/count logic on that.Regards,Pradeep

Answer Question  Select Best Answer

davindersingh29

 Profile Answers by davindersingh29 Questions by davindersingh29

• Jun 22nd, 2009

Open cursor is also executable

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

Fetching cursor is the executeble statement in cursor syntax.Regards,pradeep

Answer Question  Select Best Answer

a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL statements cannot be executed unless bind is performed.e.The program should determine the db2 access path before the bind is performed.The program should determine the db2 access path before the bind is performed.

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

The program should determine the db2 access path before the bind is performed.

andraraghu

 Profile Answers by andraraghu Questions by andraraghu

• Jun 12th, 2008

E. access path created by bind command.

Answer Question  Select Best Answer

Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately for user copye.To get data from multiple tables To store data separately for user copy

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

To store data separately for user copy

ambareeshtss

 Profile Answers by ambareeshtss Questions by ambareeshtss

• Oct 19th, 2008

DB2 table may have many fields, All the users are not intended to see some fields. To customise this, Views are created for DB2 tables. A single DB2 tables can have any no.of views.

Answer Question  Select Best Answer

The operating system in which DB2 runs isa.OS/2b.UNIXc.XENIXd.MVSe.None of the above
MVS

deepika

• Dec 18th, 2015

D.MVS

Aravindhan

• Oct 9th, 2015

UNIX,MVS

Answer Question  Select Best Answer

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

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

eat_raj

 Profile Answers by eat_raj Questions by eat_raj

• Jan 3rd, 2008

Only I is true

Answer Question  Select Best Answer

IRLM is a module of DB2 which does1 Logging2 Thread creation3 Concurrency control using locking4 both logging and thread creation

sagar reddy

• Apr 1st, 2015

Concurrency control using locking

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

3. Concurrency control using locking

Answer Question  Select Best Answer

What are the attributes that needs to be defined in order to read & write DB2 file in Cobol program?

shak_techm

 Profile Answers by shak_techm Questions by shak_techm

• May 26th, 2010

To see the attributes of RW DB2 file do the following:Go to DB2 regionSelect 3 admin tool1 - DB2 system catalogT - Tables, views, and aliasesD - DatabaseDIS - Display databaseYou will get screen ...

shyakrish

 Profile Answers by shyakrish Questions by shyakrish

• Dec 8th, 2009

Select, insert and include dclgen

Answer Question  Select Best Answer

Gurumoorthy K

• Jul 3rd, 2014

No, you cant use SUM on char columns. But few other functions can be used like MAX, MIN etc.

daniel.epps

 Profile Answers by daniel.epps Questions by daniel.epps

• Apr 20th, 2012

Yes

Answer Question  Select Best Answer

Difference between char and varchar datatype

lauren

• Aug 26th, 2015

DATE - x(8)
TIME - x(6)
TIMESTAMP - X(26)
INT
SMALLINT

Surya Pemasane

• Mar 27th, 2015

VARCHAR is variable-length.

CHAR is fixed length.

Answer Question  Select Best Answer

In the process of DB2 compilation after bind process will packages be created first or plan?

Rudresh

• Aug 3rd, 2015

Package

abhi_siddu

 Profile Answers by abhi_siddu Questions by abhi_siddu

• Aug 3rd, 2015

* Preparing executable from DB2 side is bind.
* Either directly bind DBRM in to plan or indirectly bind DBRM into package or plan
* Bind package is recommanded

Answer Question  Select Best Answer

Explain what is - 530 DB2 return code? How will you resolve it?

supriya

• Sep 21st, 2017

Constraint name is invalid.

abhilasha

• Apr 30th, 2017

THE INSERT OR UPDATE VALUE OF FOREIGN KEY constraint-name IS INVALID

Answer Question  Select Best Answer

The FREE command can be used to delete plans and/or packages no longer needed.

burelamanohar

• Feb 6th, 2007

PCTFREE : It allows for insertion of new records and for expansion of variable length fields.

FREEPAGE : The number of pages to be loaded between each page left free. It is useful for finding a near page for inserting a new record.

JAVID

• Mar 27th, 2006

Free Command is meant for the deletion of plans. A single free command can delete max. of 12 packages.welcome for feed back

Answer Question  Select Best Answer

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.

burelamanohar

 Profile Answers by burelamanohar Questions by burelamanohar

• Feb 7th, 2007

Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index

Amol

• Sep 2nd, 2006

Partitioned table is clustered by clustering index

Answer Question  Select Best Answer

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

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

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

Answer Question  Select Best Answer

An application plan or package is generated by the bind to define an access path.

Ramya

• Sep 22nd, 2011

The optimized access path is called plan.... plan contains multiple packages / access path's. plan is a optimized access

path to extract the data from the tables.

Narender

• Aug 29th, 2006

DB2 plan is executable form of sql staements(DBRM).you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths.

Answer Question  Select Best Answer

Srinivas17738

 Profile Answers by Srinivas17738 Questions by Srinivas17738

• Aug 17th, 2010

1. WHERE clause is used to filter the result set records with different predicates like -- BETWEEN, =, = and many more....2. WHERE Clause is used to Isolate rows.

mahadev mahajan

• Sep 30th, 2005

 where clause is use to extrct only one record.it is used with GROUP BY CLAUSE.     EG:-SELECT DNO FROM EMP WHERE SAL=4200         ...

Answer Question  Select Best Answer

hemant

• Apr 18th, 2006

i think only one clustering index ll be created for any table in DB2. This clustering index is created on the primary key of the table. for all other index(es) created on the table they ll be nonclustering index(es) .

pradipta

• Feb 3rd, 2006

As many no of column's that table is having that many no. of indexs we can pass.

Answer Question  Select Best Answer

prasata

• Feb 2nd, 2006

Go to spool and in the command prompt give owner  '@XXXX' and pre * then you will able to see all the job status for the user XXXX. where XXXX is the mainframe id of other person.

yogaraj

• Dec 27th, 2005

But.. if  and only that person mention your id in their program(NOTIFY=&UR ID)... you can view the status of  that person 's job otherwise you can't .. i think it may be right...

Answer Question  Select Best Answer