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.

max number of columns in a db2 table?

6 Answers  

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

What is sqlca?

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,

---

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

What is load replace in db2?

0 Answers  

---

What are the various locks available?

5 Answers   CTS,

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---