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 is ibm db2 used for?

1082

---

How to check sequence on a table in db2?

1064

---

What is plan in cobol db2?

1140

---

How does coalesce work?

1027

---

How do I start db2 in windows?

1097

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1046

---

How to connect to db2 database from windows command line?

1066

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9216

---

What is the difference between spufi and qmf?

1134

---

Name the lockable units in DB2?

1128

---

What do you mean by rollback?

991

---

Why db2 is called db2?

1044

---

What is meant by union and union all?

1012

---

What is the advantage in De-normalizing tables in DB2?

1181

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1273

---