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

Name what parameter directs the output of the job log dataset?

1102


what sort card you will use to copy the data from one dataset to another dataset?

1295


How does jcl specify the job to the operating system?

1307


What are hierarchy levels in jcl?

1569


Explain how can the attributes of one sms dataset be copied to another dataset?

1260


What do you know about jcl?

1195


what are the various stages of job processing?

1345


How can an in-stream dataset be terminated?

1392


What is concatenating?

1138


why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.

2497


Explain how can the disposition of sysout datasets be set for an entire jobstream?

1147


Describe the various parameters utilized in the creation of a gdg?

1209


How does the jcl specify the job to os?

1209


What is the purpose of disp parameter?

1171


How do you create a temporary dataset?

1241