javid

 Profile Answers by javid Questions by javid

• Apr 3rd, 2006

Thank u for clearing me this.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 28th, 2006

Remember: dedicated threads are dedicated to a particular application. This information is in a table called the Resource Control Table. It's not a CICS table and it's not a DB2 table.The RCT is owned...

Answer Question  Select Best Answer

manasa

• Nov 4th, 2011

When we load data with LOG NO then the table goes to copy pending status and is not available for updating..
It can be accessed for read only.

So,we need to take a image copy which will change the copy pending status to RW.

This IC will be used as a backup and thus durability can be achieved.

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

REORG LOG YES or REPAIR SET with NOCOPYPEND

Answer Question  Select Best Answer

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

It is a DB2 facility for static SQL statements - it replaces these statements with calls to the DB2 language interface module.

Raghuram

• Jul 17th, 2007

During Pre-compilation : 1. The embedded SQL statements are stripped out.  In the source code they are commented out and instead CALL statements are inserted.2. Based on the DECLARE TABLE st...

Sukanya Srinivas

• Apr 20th, 2007

Precompiler: 1) Checks for SQL syntax in application prgram 2) Copies all the?SQL statements into a sepearte member known as DBRM(DataBase Request Module) 3) Comment all the SQL statements 4)...

Answer Question  Select Best Answer

DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE and UPDATE.

Rishu

• Aug 10th, 2014

DDL:- Create, Alter, Drop etc...
DML:- Select, Insert, Update, Delete, Declare, Open, Fetch, Close etc...

Srinivas17738

 Profile Answers by Srinivas17738 Questions by Srinivas17738

• Aug 17th, 2010

DDL - Data Definition Language - Used to create/alter/delete Database objects DML- Data Manipulation Language - Used to insert/delete/update/select the data in the database obects(table/views...)

Answer Question  Select Best Answer

An outer join includes rows from tables when there are no matching values in the tables.

lrsantosh

 Profile Answers by lrsantosh Questions by lrsantosh

• Aug 18th, 2011

Outer Join is a type of join where the matching rows from the given tables are selected for sure and it follows following criteria to select unmatched rows. 1. LEFT OUTER JOIN it will give All Matchin...

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• Sep 2nd, 2008

3 types. Left outer Join----left table unmatched valyes are included.Right Outer Join---right table unmatched values are included.Full outer Join----Both table unmatched values are selected.

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You will declare the Cursor with "WITH HOLD " Option when you?want the cursor to be pointing to the next row even after the fetch from the db2 table and you exit from the program until expilicit commit is performed to updated to Db2 and Close cursor command is executed.

subbu

• Feb 20th, 2006

 hi,We use cursor only when we updating existing records or Inserting Some Records to the Table.When you Using commit, in DB2 every single row will be commited after the process. If abend oc...

Answer Question  Select Best Answer

sita

• Feb 26th, 2007

Yes, We can see the Comp-3 Data by pressing Hex On In the File-AID

Bibhu

• Mar 31st, 2006

What I think we cannot see the comp-3 value by USAGE verbwe have to type HEX ON in the command prompt of that particular file to see the numberExample:        &...

Answer Question  Select Best Answer