I have a dbproc that among other things inserts a new row into a table
with an id generated from a sequence.

Now I do:

select owner.seqname.nextval from table;
fetch first into :id;

insert into table
 (id,
  ..
  ..
 ) values (
  :id,
  ..
  ..
 )

ID is declared out, of course.

In Interbase, you can user id = gen_id(seqname, step) in stored procs. Is
something like this possible in sap? It is more convenient and the method
I use now seems like a quick hack. :)

Regards,

Dag Liodden

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to