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 to run cobol program using jcl?
how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?
what is the use of JCL?
What are the 2 types of parameters in dd statement?
What is the function of the dd avgrec keyword in sms datasets?
How is the record format of an output dataset specified?
What are steplib and joblib? What for they are used?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
what is the use of IEBGENER utility?
Is condition checking possible in jcl?
Mainframes gets a text file that contains the name of the file. Now using JCL i want to locate that file name in the mainframe system and perform further processing. Please tell how to proceed