FETCH is used to retrieve a specific row from a result set of the SELECT

What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?

Question Posted / guest

Answer Posted / guest

FETCH is used to retrieve a specific row from a result set
of the SELECT query and places them into local variables.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I optimize a query in db2?

1049

What are types of indexes?

1006

Name the lockable units in DB2?

1083

What is host variable?

1024

What is the use of db2 optimizer?

1060

What is the information associated with sysibm.syslinks table?

1074

How does a cursor work?

933

What is the role of union all and union

1082

How to access db2 tables in mainframe?

1005

Is db2 a mainframe?

986

What is meant by dclgen?

1071

What r the comman abends in db2, jcl and cobol???????

2215

What are bind parameters in db2?

990

What is a db2 schema?

1186

Mention the definition of cobol in varchar field.

1196