Insert Error

ratheeshknair · #1 (**permalink**) 07-02-09, 10:50

Hi Experts,

I am gettig error when i tried to insert data.

Could not obtain sequence value; nested exception is java.sql.SQLException: [SQL0029] INTO clause missing from embedded statement.

Please help

TIA

sathyaram_s · #2 (**permalink**) 07-02-09, 11:02

Can you post the code that is causing the error ?

ratheeshknair · #3 (**permalink**) 07-06-09, 01:34

Actullay I am getting error from the application

Peter.Vanroose · #4 (**permalink**) 07-06-09, 06:17

Quote:

Originally Posted by ratheeshknair

[SQL0029] INTO clause missing from embedded statement.

I assume this is SQLJ.
Try adding "INTO :varname" between your SELECT and FROM clauses,
where "varname" is the name of the Java variable into which you want the data to be returned.
If you SELECT clause contains multiple columns, you will need multiple variables:

Code:

#sql {
SELECT col1, col2
INTO :var1, :var2
FROM mytable
WHERE ...
};

See e.g. Example 3 on page 882 of the SQL Reference, Volume 2, for DB2 9.5 LUW.

Internet Services

Web Development

Digital Marketing

Consumer Tech