Hi all,
I have a question about use of append hint from Oracle Connector.
I configured Connector with insert option and auto generated query.
Is there some properties that can be used to add /*+ append*/ hint?
Thanks for your answer.
Best regards
Sandro
Append Hint in Oracle Insert from Datastage Connector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Set the Table Action property value to Append.
Note that this may use function calls via the OCI to specify to append to an existing table, rather than using hints in the generated SQL.
Note that this may use function calls via the OCI to specify to append to an existing table, rather than using hints in the generated SQL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
so using Oracle Connector Stage, configured as:
is equivalent to:
?
Is it right?
Thanks,
Sandro
so using Oracle Connector Stage, configured as:
Code: Select all
auto-generated query = YES
table = table_name
Table Action = Append
Code: Select all
auto_generated query = NO
query = insert /*+append*/ into table_name ....
Is it right?
Thanks,
Sandro
I don't know... they use the word 'append' in a pretty generic sense which leads me to believe they are not equivalent:
Don't forget that Oracle will happily ignore the hint if you don't meet the requirements it needs as noted here.
This rather than Create, Replace or Truncate. Best to check with your official support provider. Or work with your DBA and run a small test, see if you can confirm/deny yourself. I would think it's more about the Write Mode than Table Action but the only 'direct path' equivalent there would be a Bulk Load.by default the IBM InfoSphere DataStage appends to existing tables, you can also decide to create a new table, replace an existing table, or keep existing table details but replace all the rows.
Don't forget that Oracle will happily ignore the hint if you don't meet the requirements it needs as noted here.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers