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.

What is sqlca’s maximum length?

0 Answers  

---

What is cursor stability?

1 Answers  

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

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

8 Answers   Amdocs, HeadStrong,

---

Define predicate?

0 Answers  

---

List some fields from sqlca?

0 Answers  

---

What is the FREE command?

1 Answers  

---

What is schema in db2?

0 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

How to run db2 command in windows?

0 Answers  

---

what is datacom db?

2 Answers   CSC,

---

Write a query to retrive partial string.

2 Answers  

---