Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Question about null indicator

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ashok_uddaraju

New User


Joined: 21 Feb 2007
Posts: 74
Location: US

PostPosted: Sun Apr 06, 2008 2:09 am    Post subject: Question about null indicator
Reply with quote

In this thead, MKP stated:
Quote:
Use the NULL-INDICATOR to handle this condition.

move -1 to the indicator if the value is NUll.

In the embedded SQL statements we need to add this indiactor with the data host variable

Can somebody tell the use of null indicator i.e -1 in this cae?
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Apr 06, 2008 2:23 am    Post subject:
Reply with quote

ashok_uddaraju wrote:
Can somebody tell the use of null indicator i.e -1 in this cae?
Try looking it up....
Specify the null value. A negative value of the indicator variable specifies the null value. A -1 value indicates that the value that was selected was the null value.
Back to top
View user's profile Send private message
sri_mf

Active User


Joined: 31 Aug 2006
Posts: 215
Location: India

PostPosted: Sun Apr 06, 2008 11:43 am    Post subject: Re: Question about null indicator
Reply with quote

[/quote]
Can somebody tell the use of null indicator i.e -1 in this cae?[/quote]

Null Indicator:

zero indicates that the value is not null
-1 indicates that the value is null
-2 indicates data truncation..

Please correct me if i am worng
Back to top
View user's profile Send private message
sagard

New User


Joined: 16 May 2007
Posts: 4
Location: Pune

PostPosted: Sun Apr 06, 2008 4:23 pm    Post subject:
Reply with quote

[/quote]
Can somebody tell the use of null indicator i.e -1 in this case?[/quote]

I am a bit confused, can we have a Null indicator for a non-nullable field?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Apr 06, 2008 6:40 pm    Post subject:
Reply with quote

Hello,

Quote:
can we have a Null indicator for a non-nullable field?
No, by the definition of a non-nullable field. . . It will never be null as it will never have an associated null-indicator.

A field may have a value of -1, but that does not make the field null (neither does a value of binary zeros (low-values)). It is only when the null indicator is -1 is the field null.

I'd suggest you look in the db2 manuals (linked to via "IBM Manuals" at the top of the page for more complete info about null.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us