Answer / sunil1405

SELECT FNAME WHERE FNAME LIKE 'S%';

Answer / 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.

How is a typical DB2 batch program executed ?

1 Answers  

---

What is the function of the Data Manager?

2 Answers  

---

What is cobol db2?

0 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

How many databases are there?

0 Answers  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

what is consistency token

3 Answers  

---

How do I copy a table in db2?

0 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---