What's the maximum number of characters that a tablename
can have?
Answers were Sorted based on User's Feedback
Answer / ankit
A TABLE NAME HAVE 1 TO 30 CHARACTERS IN LENGHT AND MUST BE
UNIQUE WITHIN THE TABLE
| Is This Answer Correct ? | 2 Yes | 0 No |
When reorg is used?
What is a system catalog table in db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Can any one tell me about Restart logic in DB2.
Can there be more than one cursor open for any program?
What is the maximum number of columns in a db2 table?
Where besides the DB2 catalog is database object information stored by DB2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
The only place of VSAM KSDS in DB2 is?
What are the benefits of using the db2 database?
What is the function of logging in the db2 database?