Skip to main content
Question

@Scope_identity, @@IDENTITY or similar in FME


Hi,

I have database with very much foreign keys. I need to recover last identity and put him in attached table.

For example:

 

I have table POINT (IDAN identity PK), and table SOME_POINT (IDAN FK).

 

Need to insert part of feature data into POINT and the rest into SOME_POINT. Of cource, I need to give them the same IDAN.

 

Is there a way not to use 'write into identity column' (because then I need to create IDAN by myself in FME), and even then get to PK and FK in these tables be the same?

Thanks!

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings