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

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

Question Posted / nitin

2 Answers
33638 Views
IBM, Infosys, I also Faced
E-Mail Answers

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

What does an outer join do?

1 Answers CTS,

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers HeadStrong,

How many Buffer pools are there in DB2 and what are they?

1 Answers IBM,

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers IBM, TRD,

What are the 2 sqlcodes that are returned?

0 Answers

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers

can i code union in cobol-db2 pgm ?

4 Answers Patni,

Define buffer pool.

0 Answers

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers Logica CMG,

What is a lock?