Name some fields from SQLCA.
Answers were Sorted based on User's Feedback
What do you need to do before you do EXPLAIN?
How to view db2 table structure?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is catalog database in db2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Describe the elements of the SELECT query syntax?
What is normalization and what are the five normal forms?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is performance tuning db2?
what is the use of commit ? and what is the syntax?
What is query_cache_limit?
What does an outer join do?