IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

not NULL with Default
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
dilpreet

New User


Joined: 18 Mar 2008
Posts: 34
Location: INDIA
PostPosted: Mon Mar 02, 2009 6:54 pm
 Reply with quote
why do we give NOT NULL WITH DEFAULT while declaring variables in DB2
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
PostPosted: Mon Mar 02, 2009 7:00 pm
 Reply with quote
Quote:
...declaring variables in DB2

Does this refer to mentioning a column and its data type in CREATE table?

So, that column shouldn't be null and if it is omitted while inserting, it would have the default value based on its data type...
Back to top
View user's profile Send private message
dilpreet

New User


Joined: 18 Mar 2008
Posts: 34
Location: INDIA
PostPosted: Mon Mar 02, 2009 7:05 pm
 Reply with quote
Gnanas

this declaration is given to variable while creating db2 tables.

Could you please xplain it further
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
PostPosted: Mon Mar 02, 2009 7:46 pm
 Reply with quote
Hi,

You might like to check this link: www.ibmmainframes.com/about11461.html
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Running a Job with the Default User ID JCL & VSAM 2
No new posts Change Default Scroll Setting TSO/ISPF 1
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
No new posts Define default volume for DSN storage... JCL & VSAM 8
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us