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
a dd statement has 2 types of parameters. Name them?
which utility is used a dummy utility?
What are the rules employed while naming the steps in a job?
Explain about LMFREE�free data set from its association with data ID
How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you
Is it possible to code instream data in a PROC?
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
What is the function of the dd avgrec keyword in sms datasets?
if the submitter of a job wants to inform another user about the job completion, how can it be done?
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
Can an individual step be restricted from using all the jobs allowed cpu time?
What does a disposition of (new,catlg,keep) for a dsn mean?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
What are the jcl procedures?
When space is allocated for an output dataset, what units can be used?
