Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

DB2 Interview Questions
Questions Answers Views Company eMail

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

IBM,

2721

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

IBM,

3 8017

How to insert more than one record using insert?

Atos Origin, IBM,

7 14061

How to update more then one record using update?

IBM,

5 11547

what are extents?

5 16657

what is consistency token

3 19580

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

IBM,

4 10677

what is the input to PLAN? what is the input to DBRM?

4 10713

How can you split a table in to exactly half?

HSBC,

7 16119

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

Cap Gemini,

15 24093

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

Amdocs, HeadStrong,

8 16200

What is a view? Why use it?

2 7974

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

TATA,

2531

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

Wipro,

6 10876

what is the Foreign key? explain?

2 7669


Post New DB2 Questions

Un-Answered Questions { DB2 }

How to check sequence on a table in db2?

1056


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1235


Which isolation level provides highest data integrity?

1114


What is performance tuning db2?

1058


what is db2 restart?

2149


What is the maximum number of columns in a db2 table?

1279


What is the latest version of ibm db2?

1267


How do I optimize a query in db2?

1095


Define check constraint.

1076


Highlight all the advantages that are attached to a package.

1113


What does reorg do in db2?

1026


What is plan in cobol db2?

1133


What is the difference between db2 and oracle?

1127


What is syscat in db2?

1001


What is sqlca?

1066