Auto Increment In peoplecode

In my case , I am incrementing the Interview ID



1. Execute this SQL statement 

CREATE SEQUENCE SYSADM.InterviewIDSeqNum    -- this is Your  variable
  START WITH 1
  MAXVALUE 99999999999999999999
  MINVALUE 1
  CYCLE
  CACHE 20 
  NOORDER;

2. Commit;

3. Write this peoplecode 

Local Number &InterviewID;

If %Mode = "A" Then

   SQLExec("SELECT InterviewIDSeqNum.NEXTVAL FROM DUAL", &InterviewID);

   RecordName.FieldName.Value = &InterviewID;

End-If;