Skip to main content
Question

@Scope_identity, @@IDENTITY or similar in FME

  • August 8, 2014
  • 0 replies
  • 29 views
A

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!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,662
Posts
123,959
Replies
41,098
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.