If we set SQLCODE=100 means end of the table. EX: if sqlcode=100

how can u understand the end of the table ?

Question Posted / amarnadh reddy

Answer Posted / amarnadh reddy

If we set SQLCODE=100 means end of the table.

EX: if sqlcode=100
Display end of the table
end-if.

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we update view in db2?

983

How do I add a column to an existing table in db2?

1012

Mention the location where the output received from explain statement is stored.

1109

Which component is responsible for processing sql statements and selecting access paths?

1116

what is the role of the cursor in db2?

1051

What is the cobol picture clause of the db2 data types date, time, timestamp?

1044

What is page size in db2?

959

What is scrollable cursor in db2?

1042

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11663

What is db2 catalog database?

1021

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1263

Which isolation level provides maximum concurrency?

1141

What is the usage of open cursor command?

1084

Explain what are the various isolation levels possible?

1029

How to find the maximum value in a column in the db2 database?

1061