sequence issue with respect to DB2 database while trying to insert
Hi Team,
My Application was running with Oracle database and need to support application in DB2 database also....so we had altogether 4 tables and sequences for each table.
With oracle database, for each Entity object primary key attribute we had given groovy expression for sequence generating as below
(new oracle.jbo.server.SequenceImpl("SeqName",adf.object.getDBTransaction())).getSequenceNumber()
now for Db2 if i try to use the same groovy expression i am getting lot many issues. Even tried giving differnet EL expressions which are related to DB2 for sequence generating as below
nextval for sequencename and even tried as select nextval for PCP_DOMAIN_SEQ from sysibm.sysdummy1 ; but still no luck.
So what will be the best way to handle this issue with respect to DB2. Please help me out
Thanks in Advance for your help.