How to resolve SQL Code -310. The db table feild is
declared as Decimal(7,2).

Answer Posted / satty

its just like your soc7 error... check your decimal data... whether it is decimal or not

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1820


How to find the number of rows in db2 tables?

617


Explain package in db2 and its advantages?

598


What do you mean by between and in? Is between inclusive of specified range values?

669


What is the use of reorg in db2?

608






What is query_cache_limit?

545


Name the various locking levels available?

637


Explain what are the various isolation levels possible?

610


When do you specify the isolation level?

609


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1628


Which component is responsible for db2 startup and shutdown?

630


What is the cobol picture clause of the db2 data types date, time, timestamp?

619


What is the syntax for FETCH in DB2 ?

676


What is with ur in db2?

760


If I have a view which is a join of two or more tables, can this view be updateable?

694