1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
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,

2313

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 6466

How to insert more than one record using insert?

Atos Origin, IBM,

7 11880

How to update more then one record using update?

IBM,

5 9597

what are extents?

 5 14325

what is consistency token

 3 18255

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

IBM,

4 9271

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

 4 9343

How can you split a table in to exactly half?

HSBC,

7 13807

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

Cap Gemini,

15 18671

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

Amdocs, HeadStrong,

8 13609

What is a view? Why use it?

2 7049

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,

2038

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 8803

what is the Foreign key? explain?

2 6654

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the reason behind not using select * in embedded sql programs?

593

What is an instance in db2?

552

What is db2? Explain.

593

Give the name of some fields form sqlca.

605

How to find primary key of a table in db2?

596




What is bind package and plan in db2?

578

What are iseries servers?

554

What is difference between alias and synonym in db2?

631

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2676

Why cursor is used in db2?

562

What is the role of union all and union

642

What is a db2 collection?

595

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1222

What are the rules for db2 programming?

634

What is copy pending and check pending in db2?

565

For More Un-Answered { DB2 } Questions Click Here