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

Answers were Sorted based on User's Feedback



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

Answer / ashu

Check your program and make sure that the data you are
passing to this host variable do not contain NON-DECIMAL
value.

Is This Answer Correct ?    28 Yes 1 No

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

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

More DB2 Interview Questions

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,


How do we specify index to include or not during bind process.

0 Answers   Satyam,


What keyword does an SQL SELECT statement use for a string search?

2 Answers  


I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,






How to run db2 command in windows?

0 Answers  


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  


List some fields from sqlca?

0 Answers  


5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


What is CHECK PENDING ?

5 Answers  


Explain about rct.

0 Answers  


Categories