View previous topic :: View next topic
|
Author |
Message |
niks_jude Warnings : 1 Active User
Joined: 01 Dec 2006 Posts: 144 Location: Mumbai
|
|
|
|
Hi
Our system has Spufi/QMF but not File-Aid DB2. Was asked the following interview questions wanted to share and see if somebody has the answer (preferably screenshot) -
1) How to see in File-Aid DB2 if column is NULL or not, does it hold any special value or does it appear in different color?
2) The same question on primary key?
Thanks. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
NULL ENTRY Specify the character that, when entered, sets a column to null.
NULL DISPLAY Specify the character that appears for null columns.
SPACES IMPLY NULL Specify ON to have spaces imply nulls for character columns. |
|
Back to top |
|
|
|