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.

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

what is sql abend code -801,-802?

2 Answers  

---

---

Name some fields from SQLCA.

2 Answers  

---

What is the function of buffer manager?

1 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

Name some fields from SQLCA

1 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---