Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can a jobs execution priority be modified?
What are the difference between jcl and jes?
How do you overcome this limitation ?
What is jcl in mainframe?
can any one plzzzzzz tell the jcl code for creating ps using idcams
What is the difference between the positional and keyword parameters? Give examples.
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
Are there any set of rules for the names of the steps used in a job?
What dd statement is used to supply the name of a dataset?
What are the parameter we cannot use in procedure?
what are the statements that are not valid to be included in an include statement?
What is the function of the dd dcb keyword?
Explain the jcl exec statement?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
How can values be passed from the job stream to an executable program?
