What is the maximum length of a column name in DB2? 18 or
30 or anything other than these?
Answer Posted / roop
30
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do I delete a column in db2?
How do I import a csv file into db2?
How to retrieve rows from a db2 table in embedded sql?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
When do you specify the isolation level?
What is the max length of sqlca?
What is multi row fetch in db2?
What types of tables are there in the db2 database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Are view updateable?
Mention the downsides of page level lock.
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
What is cursor stability in db2?
What is the role of the data page in the db2 database?
How to connect to db2 database from windows command line?