Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to code instream data in a PROC?
Explain the hierarchy levels in jcl?
Explain the purpose of the dd keylen parameter?
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
How do you submit a job for execution?
what happens in execution stage in job processing?
what is the purpose of coding notify parameter in job statement?
How can a fb file convert to vb file using sort program?
How jcl work to handle various input output file operations?
How can values be passed from the job stream to an executable program?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
Is their any set of rules for dd? Explain.
What is the significance of addrspc parameter in exec statement?
Is it possible to define dd statements as you want?
Mention the types of job control statements?
