Interested to Buy Any Domain ? << Click Here >> for more details...
what is a null indicator in db2?
- 5 Answers
- 22103 Views
- Fiserv, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Hi,
Suppose if the database table has a couloumn empno, it may
or may not null.
to handle these type of values we have to use null
indicator.
It indicates that particular coloumn may contain null
values likewise.
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / shaik
If the Resultant Table value is nulls(Garbage) then
Embedded SQL abends with the SQLCODE -305, even we can
handle this to not abend, but we cann't move the garbage to
target value, so, before moving the data to target field,
we need to make sure whether it has nulls or not, we can
identify the feild holds null or not by checking the Null
indicator(Ned to define with half-ward binary format in ws
section) value with < = 0. if less than then null
available, if 0 then nulls not available. Generally id
nulls are available, we will initializa the value then we
will move this to target.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / poornima.t
NULL INDICATOR IS USED TO FIND OUT WHETHER
THE COLUMN IN THE TABLE IS NULL OR NOT NULL...
IN COLUMN IF THE VALUE IS NOT SPECIFIED THEN IT IS
TREATED AS NULL VALUE...
| Is This Answer Correct ? | 0 Yes | 0 No |
In which table PLAN is registered in ?
Explain the function of the steplib dd statement?
Is automatic restart possible in jcl?
why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?
What are the rules employed while naming the steps in a job?
What parameters can be used to limit the number of records written to a sysout dataset?
How to rename a VSAM file as well as it's index file?
Can anyone tell me the syntax for printing two files at two different destinations in a single step?
when GDG version number get changed ? bcz always Generations only increasing.
How system will identify whether user wants to create PS or PDS? If answer is SPACE parameter then why we need to pass ps or po as dataset organisation while creation
What is Backward Referencing ?
COBOL 
