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.

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

What is explain plan in db2?

0 Answers  

---

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?

0 Answers   TATA,

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

What is a base table?

2 Answers  

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

What is collection in db2 bind?

0 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---