Answer / gopinath

select <column name(s)>,<column name(s)> from <table name>
where <column name> <condition>

Answer / sunil1405

SELECT * FROM <TABLE NAME> WHERE COLNAME=<PARAMETERS>;

Answer / guest

The select command is used SELECT the data from the
database.

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

How does one remove entries from the SCT02 table?

1 Answers  

---

How to take backup of table in db2?

0 Answers  

---

How do I delete a table in database?

0 Answers  

---

What is page size in db2?

0 Answers  

---

What is sqlcode -922 ?

2 Answers  

---

What is ibm db2 connect?

0 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---