What do you mean by NOT NULL? When will you use it?
Answer Posted / andank
NOT NULL is the keyword used define columns, when create a
table. When you specify NOT NULL to a column, that column
can not hold NULL values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
Mention the location where the output received from explain statement is stored.
What is meant by dclgen?
What is db2 catalog database?
what is utility for parm lib
What is declare cursor?
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 .....
Why cursor is used in db2?
What is db2 look?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What os does db2 run on?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the meaning concurrency in the db2 database?
what is diffrence b/w file-aid tool and file-aid utility???
What is a system catalog table in db2?