Name some fields from SQLCA.
Answers were Sorted based on User's Feedback
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
How to fetch the uncommited data from table ?
wht displays the number of times a query modified ?
Can SQL statements/queries be included in a copybook?
What is release/acquire in bind?
What is concurrency?
Explain the contention situations caused by locks?
How to resolve -407 sql code in DB2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Can I use LOCK TABLE on a view?
What is a view? Why use it?