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
Explain the function of dd name parameter with a 2 part structure; audit.report?
Describe the various parameters utilized in the creation of a gdg?
How is the record format of an output dataset specified?
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
Explain the function of dd disp parameter?
Name the statement which can be used to send data to another mvs jes3 node?
what happens in conversion stage in job processing?
How can return codes be tested before execution of a job step?
Why include statement is used in a jcl?
What is the use of disp parameter?
When output dataset space is required, what quantity categories are used?
What are s0c1, s0c4, s0c5, s0c7 and socb?
How do you access an uncatalogued dataset in a jcl?
Explain in DD statement what is the use of DCB parameter?
