how can u understand the end of the table ?



how can u understand the end of the table ?..

Answer / 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

Post New Answer

More DB2 Interview Questions

pls tell me abt the normalization five types....

2 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,


how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,


What is package versioning? Please give an example.

1 Answers  


in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,






If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,


What are the various data types available in db2?

0 Answers  


How do I connect my db2 database to ibm?

0 Answers  


What is netezza database?

0 Answers  


I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,


What is meant by the attachment facility?

3 Answers  


How many buffer pools are there in DB2?

2 Answers  


Categories