Problem in getting the next value from DB2 Sequence...

[kaps]

Hi

In serer edition, Before writing to Dimension table, we use a DB2 stage and write the SQL in that to get the next value from the DB2 sequencer.Reason for this is we wanted to generate the SK's before inserting to the table and we pass that also to a file so that we can bypass doing lookup to a dimension table during the fact load.

In Parallel edition, same approach did not work. We get the following error :

Lookup_66,1: Could not find input field "NEXTVALUE".

We have tried with DB2 API stage and lookup stage which resulted in the above error. When we use DB2 enterprise stage with sparse lookup on, multiple record gets the same next value.

Can anyone explain what am I doing wrong ?

Thanks

[ray.wurlod]

Show us the actual SQL - you should be able to find it in the job log. I suspect a syntax error.