Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is a null indicator in db2?

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


Please Help Members By Posting Answers For Below Questions

How to run cobol program using jcl?

1172


how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?

1237


What is jcl in mainframe, and how many types of jcl statements are there for a job?

1118


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?

2235


When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?

1188


what is the use of JCL?

1116


What are the 2 types of parameters in dd statement?

1107


What is the function of the dd avgrec keyword in sms datasets?

1296


How is the record format of an output dataset specified?

1120


What are steplib and joblib? What for they are used?

1149


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

2394


by using cond parameter maximum 8 cond can be coded in single cond means ?explain

1403


what is the use of IEBGENER utility?

1122


Is condition checking possible in jcl?

1156


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

2515