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
Name what parameter directs the output of the job log dataset?
what sort card you will use to copy the data from one dataset to another dataset?
How does jcl specify the job to the operating system?
What are hierarchy levels in jcl?
Explain how can the attributes of one sms dataset be copied to another dataset?
What do you know about jcl?
what are the various stages of job processing?
How can an in-stream dataset be terminated?
What is concatenating?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
Explain how can the disposition of sysout datasets be set for an entire jobstream?
Describe the various parameters utilized in the creation of a gdg?
How does the jcl specify the job to os?
What is the purpose of disp parameter?
How do you create a temporary dataset?