Use Procedure Request_Save in the DD. Forward send it and then you can get that value after that.

Is the sequence in the Default for the column in SQL?

I'm doing a presentation at DISD on using Sequences in MS SQL. Hope you are coming?