what is a null indicator in db2?
- 5 Answers
- 21087 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 |
WHAT WILL HAPPEN TO A FILE IF DISP=(MOD,DELETE,DELETE)
What is the use of symbol // in jcl?
THERE IS ONE STEP AS BELOW: //STEPJS060 EXEC PGM=XYX, COND=((200,EQ,JS010),(0,NE,JS020.C),EVEN) COULD ANY ONE EXPLAIN HOW COND PARAMETER WORKS HERE? I AM CONFUSED BECOZ OF "EVEN".
What do you understand by the terms: joblib and steplib?
What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ?
How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.
How can I override a dsn that is contained in a proc called by another proc? I need to do the override in the calling JCL.
What is STEPLIB, JOBLIB? What is it used for?
can we copy a file from fixed block to variable block and vice versa ....asap
Does jcl support automatic restart?
i have 10steps and i want run step3 and based on step3 i want execute step7,8,9,10?in jcl
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u
COBOL 
