What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?
Answer / amarnadh reddy
Hi,
-305 is Null Indicator is needed. The null value cannot be
assigned to output host variable. Because no Indicator
variable is specified. (to fetch or select operation
resulted in the retrieval of a null value to be inserted
into the output host vaariable)
-407 is An update or insert value is null. but the object
column name cannot contain null values.(the update or insert
value was null. But the object column was declared as not
nullin the table)
Is This Answer Correct ? | 11 Yes | 0 No |
What is the physical storage length of the data types date, time, and timestamp?
What is consistency token in db2?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
How would you find out the total number of rows in a db2 table?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is load replace in db2?
What are data types?
What is a Cartesian product?
How can you count the number of rows from a table tab?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
How can you quickly find out the number of rows updated after an update statement?