Answer Posted / kirtish srivastava

Like is used with where clause to search,update, and delete a record using wild cards.

Example:-
To Search;-

select * from Employee where Name like 'a%'

Note;- Search all records whose employee name is stared from a character.

To Update:-

update Employee set Name='amit' where Name like 'a%'

update all records with name amit whose employee name is started from a character.

To Delete:-

delete from Employee where Name like 'a%'

Delete all records whose employee name is started from a Character.

What r the comman abends in db2, jcl and cobol???????

1818

---

What is bufferpool in db2?

576

---

what is the role of the cursor in db2?

639

---

What is check constraint. Explain with example.

642

---

How to find the number of rows in db2 tables?

613

---

---

What is null indicator in db2?

602

---

What is the role of the data page in the db2 database?

585

---

List down the data types in the db2 database.

632

---

What is reorg?

617

---

What is the use of dclgen in db2?

588

---

How to resolve deadlock issue

17961

---

What is database alias db2?

600

---

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?

2044

---

What is db2 purescale?

544

---

What does db2 mean?

581

---