I have two tables Item and Price which both have PK's which are identity columns (mssql instance in this case if it matters).
Item has a nullable FK linkage to Price. Here is a rough DDL...
CREATE TABLE item(
[id_itm] identityinteger IDENTITY(1,1) NOT NULL,
[id_price] identityinteger NULL,
... )
CREATE TABLE price(
[id_price] identityinteger IDENTITY(1,1) NOT NULL,
[price_value] integer NOT NULL,
... )
I have done well with inserting data into tables, using relationColumns to introduce FK linkages between tables, transforms, etc...
However, in this case, I have no alternate key (AK) to lookup the PK for a Price row to fill in the item.id_price FK. If I were creating new rows in my java program, I would have access to the results of populating the identity columns from the driver and the transaction instance.
Inside an Octopus importDefinition, I have no clue syntactically how to lookup an inserted Price row so I can map it onto an Item row (without introducing an articial AK)
Is there any concept of "this" or last row or something that is available (perhaps in a transform) to accomplish this?
Thanks,
Brad
--
You receive this message as a subscriber of the
octopus@... mailing list.
To unsubscribe: mailto:
octopus-unsubscribe@...
For general help: mailto:
sympa@...?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws
