I'm using an Oracle connector and am trying to use one of the incoming columns as part of the after SQL statement within the connector.
Oracle Table being written to: TableA
After SQL table being written to:TableB
Incoming column to be written to TableA and also used in the after SQL table TableB:ColumnA
Since it's an incoming column to the connector does it have to include ORCHESTRATE as part of the name? What is the correct syntax?
Example:
UPDATE TableB SET MyField = ORCHESTRATE.ColumnA
Oracle Stage after SQL
Moderators: chulett, rschirm, roy
Re: Oracle Stage after SQL
You can't. The before and after areas are not aware of nor have any access to data on the link.wjblack74 wrote:I'm using an Oracle connector and am trying to use one of the incoming columns as part of the after SQL statement within the connector.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Oracle Stage after SQL
OK. if you don't have access to the incoming schema and what you need could be pulled from what you just wrote to TableA could you do something like
Example:
UPDATE TableB SET MyField = (select MAX(ORCHESTRATE.ColumnA) from TableA)
Example:
UPDATE TableB SET MyField = (select MAX(ORCHESTRATE.ColumnA) from TableA)
William Black