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
What is the format of comment statement?
What is catelog procedure and how many catelog procedure to use in one job?
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
Can an individual step be restricted from using all the jobs allowed cpu time?
What are some jcl statements that are not allowed in procedures?
Name the parameters which can be used to limit the number of records written to a sysout dataset?
How does jcl specify the job to the operating system?
What do you understand by the term job time – out and how can you overcome that?
How does jcl act on code(if you take a cobol program)?
what are the statements that are not valid to be included in an include statement?
What does a disposition of (new,catlg,keep) for a dsn mean?
How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY
What is the difference between run mode and addressing mode?
The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The disp in the JCL is SHR and the pgm opens the file in EXTEND mode. What happens ?
how you will the direct the data to spool using sysout option?
