Interested to Buy Any Domain ? << Click Here >> for more details...
how to u check the query is executing or not ?where will u check for sqlcode ?
- 6 Answers
- 12501 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lu
OH man...everytime, you execute a sql statement, u have to
check you SQLCODE = 0 or not = 0....this a basic using DB2,
Oracle....
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / arun
If you want to check from DBA point of view.
I would suggest if the query is taking longer time you can
use any of the tools like detector and check how long the
query is running and how much cpu has been allocated to
this thread and how many get pages has been done how many
rows has been selected or inserted or updated.
We have tools to know the current status of the query.
If the query is simple and completes quickly SQL RC = 0 is
for the normal completion of the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anjireddy vintha
RUNTIME SUPERVISER WIL MONITER THE SQL QUERY'S AND IT WILL
GENERATE SQLCODE FOR EVERY EXEUTION OF SQL QUERY.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nithinbalaji mariappan
You need to display SQL-ERR-D variable from SQL CA on your program. It will write a sql error code
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is cursor stability?
When do you specify the isolation level? How?
What is the difference between Where and Having Clause
can any one give the list of some important sql abend codes which r frequently asked in interviews?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
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,
How to resolve -818 sql code in DB2?
What is the maximum size of varchar data type in db2?
how to resolve -811 sqlcode .give clear explaination
Why do chiropractors use drop table?
what are extents?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
COBOL 
