Answer / guest

Hi,
Suppose if the database table has a couloumn empno, it may
or may not null.
to handle these type of values we have to use null
indicator.
It indicates that particular coloumn may contain null
values likewise.

Answer / 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.

Answer / chiru the master

-1 is the null indicator

Answer / poornima.t

NULL INDICATOR IS USED TO FIND OUT WHETHER
THE COLUMN IN THE TABLE IS NULL OR NOT NULL...

IN COLUMN IF THE VALUE IS NOT SPECIFIED THEN IT IS
TREATED AS NULL VALUE...

Answer / shaik

Null is unknown information (garbage)

what is the use of temporary files?

5 Answers   Hexaware,

MOD, DELETE; What does a disposition of (,DELETE) mean ?

3 Answers  

Which storage devices are grouped under DASD and SYSDA ?

1 Answers   IBM,

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

0 Answers  

restart logic ?

2 Answers   TCS,

how to identify a vasam dataset by seeing in 3.4(browse)

5 Answers   Cap Gemini,

How can I override a dsn that is contained in a proc called by another proc? I need to do the override in the calling JCL.

3 Answers  

Differentiate between addressing mode and run mode.

0 Answers  

what type of version is we r using now real time in all modules(cobol, jcl, cics, db2, vsam)?

1 Answers   Accenture,

I have a file in which I have 20 records. I want my first record to go into file 1 and second record to go in second file. I want to copy the alternate records like this in the two output files. How can I do this using JCL?

4 Answers  

what is pupose and meaning of the REGION keyword and what jcl statement is it associated with?

1 Answers  

Can we find specific member without knowing the name of PDS or can we search a member to which PDS it belongs to? if so how?

6 Answers