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 |
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is db2 optimizer?
What is the difference between using bind () and rebind () methods of naming class?
How does db2 sample database connect?
How can you count the number of rows from a table tab?
How to update more then one record using update?
Define buffer pool.
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
How can we retrieve the total number of records in RPG & CLLE?
Is db2 a database?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
Is there any advantage to denormalizing DB2 tables?