That Host Variable contain the Truncated value when Null 
Indicator conatin value -2.

get error code "-407"

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the 
object column defined as NOT NULL values.

Sorry for the above answer :(

Please see the Correct answer, we will get the SQL error -
305

-305:- The NULL value cannot be assigned to output host 
variable number because no indicator variable is specified.

it will retrive the garbage value.

Please correct the above error defintation :-

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the 
object column defiend as NOT NULL values.

we will get the sql error code "-407"

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the 
object column cannot contain the NULL values.

in DROP TABLE command it will remove the table containts as 
well as table structure from the database catalog, also it 
release all the storage space it has acquired previously.
we can't rollback it as it is a ddl command.

but in case of DELETE TABLE command it just delete all the 
records but not relaese the spaces it acquires .it can be 
rollback as it is a dml command.

DROP TABLe deletes the entire Structure of the TABLE from 
the database with all the datas it contain, DELETE TABLE 
deletes only the rows of the TABLE.

drop table deletes the entire structure from the database 
and it also removes entry from syscat.tables. but where as 
delete table  only deletes the rows in the table.

we will get the sql code "-305".

-305:- The NULL value cannot be assigned to output host 
variable number because no indicator variable is specified.

Hi,

    Lets consider the name the calling prg. as PROG1 and 
called prg. as PROG2, Pgm PROG1 should be compiled as a 
normal CBL pgm, and Pgm. PROG2 should be compiled as a 
CoBoL-DB2 pgm. And the Run JCL should call the PGM PROG1, 
using IKJEFT01 pgm, since it calls pgm PROG2 with SQL 
statements. For the JCL u can refer to the JCLS link in the 
same website

Thanks Santy for all the answers .

Thanks Debu & Santy

u will get -811 error code.

this will b solve in different way. first u have to find 
out y this error comes.
exmple :- 
    If u r selecting the address of the emp with help of 
Name key, then may b same name contain 2 different address, 
as per the business need, it may contain 1 defualt address 
and other is alternet address. 
    So as per the business need find out that which address 
u want to select, and as per this need u can use one flag 
veriable to differentiate these 2 address. make the change 
as per above in ur table. with the help of solution u can 
solve the above problem without using the cursor.

-811 ERROR CODE