AS/400 conversion of IBM UDB 7.2.2

Posted on 2004-12-01
Medium Priority
Last Modified: 2008-01-09
I have a simple sequence in DB2 and I get the next number with the SQL: 'VALUES NEXTVAL FOR TABLE'.

On the AS/400, however, I get this error message: java.sql.SQLException: [SQL0029] INTO clause missing from embedded statement.

It seems that the AS/400 wants me to use the value in a nested insert and won't give me the value directly.

How can I get the value of the sequence without actually inserting a record into another table?
Question by:jerelw
1 Comment
LVL 33

Accepted Solution

shalomc earned 200 total points
ID: 12787453
AS400 does not support sequences until version 5.3 which came out this year, and even now I am not sure if your syntax will pass.


Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month16 days, 9 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question