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

Answer Posted / ankit.:-)

before embeding check that command in SPUFI and u will get
the sqlcode value , if it is successful means
sqlcode=0 ,then go for embeding into pgm

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is deadlock in db2?

788


Why do we need reorg in db2?

729


What is the meaning concurrency in the db2 database?

837


What is cursor in dbms?

809


What do you mean by storage group (stogroup)?

753


What is null indicator in db2?

822


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8254


Explain about open switch business continuity software?

811


How to find the number of rows in db2 tables?

788


How many types of page locks can be held in db2?

792


What is the maximum No of rows per page?

801


How to execute stored procedures?

825


can all users have the privilage to use the sql statement select * (dml)?

834


Which are the db2 tools to protect integrity of the database?

884


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1840