Hello experts,
I have a very simple question, being a new DB2 developer.
I need to assign NEXTVAL of an existing sequence to a variable in my Java program and then run DML statements on multiple tables using this variable. I'm not allowed to use SYSDUMMY1 pseudo table in the current environment.

What is the best way to do this ? If you can show me a sample assignment statement, that would be highly appreciated.

Thanks !

Hi,

You can use select from sysibm.syssequences. Put that in a string

for eg.. String Seq = (returned resultset.next)

This would help.

I dunno much of java, but this is how our guys do it.

HTH

Nitin.

Nitin,
Thanks for taking time to answer my question.
I still don't know whether your solution would solve my problem.

Selecting from sysibm.syssequences will not be equivalent to using NEXTVAL, which actually would increment/decrement the sequence number automatically. Your solution would allow me to find the last generated value, but I can't use it as a method to generate my sequence automatically.

Please help me understand where I am going wrong.

Thanks !

can anyone help me in getting the "Fmpjdbc12.jar" file. I am desperately looking for that.
Please some one help me out in this regard.
Reply me back to pbharath_iitm@yahoo.co.in

Thanks,
Bharath

Bharat,
You have posted your question as a thread to my discussion, which is totally un-related. Please delete it from here and post it as as a new discussion thread, so that people can answer your question.

Thanks !

Does

db2 "VALUES(nextval for sequence1)"

help ?

Cheers
Sathyaram

Sathyaram,
The command works, I know, but how do you assign that value to a variable within your program?

Thanks !

values (nextval for ..) into :hostvariable

This works on DB2 unix/Windows, I'm not sure it will also work on DB2 OS/390 (and don't forget to read the manual ).

Hope this helps.

Thanks for the tip. Eventhough this is not exactly what I was looking for, your answer opened up another possibility for me.

I appreciate your help !!
Thanks to every on who participated in this thread.