All,
Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate statement to the DB or does it do somekind of Delete logic. I am working with my DBA to get appropriate rights for the user we will be using to run our jobs and this will make a difference. We run SQL Server 2000.
Any help would be apprciated.
Thanks!!
Aaron
Please help me clearify...
Moderators: chulett, rschirm, roy
Re: Please help me clearify...
Aaronej,aaronej wrote: Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate statement to the DB or does it do somekind of Delete logic. I am working with my DBA to get appropriate rights for the user we will be using to run our jobs and this will make a difference. We run SQL Server 2000.
The option "Clear table and Insert Rows" does a Delete From <table>. The option "Truncate table and insert rows" performs a truncate.
Re: Please help me clearify...
Hi
Clear table and Insert Rows uses the Truncate as of my knowledge.
Thanks,
Neena
Clear table and Insert Rows uses the Truncate as of my knowledge.
Thanks,
Neena
Last edited by neena on Tue Dec 16, 2003 3:23 pm, edited 2 times in total.
There is no TRUNCATE on ODBC stages. It is Clear table blah blah blah and that is a delete from statement.
On an OCI stage such as Oracle, you do have both Clear and Truncate options. They are radically different in permissions (Truncate requires you to have alter table permissions where Delete doesn't).
So, everyone sing it together....
On an OCI stage such as Oracle, you do have both Clear and Truncate options. They are radically different in permissions (Truncate requires you to have alter table permissions where Delete doesn't).
So, everyone sing it together....
Truncate is truncate and clear is delete
Now my ETL life is complete...
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Is it me, or is there some weird formatting issues on this particular thread?
I don't have any HTML diagnosis tools here (It've been 4 or 5 years since I did some serious HTML work), but it appears that there's an extra <table> defined.
Man, this tool sure depend heavily on table formatting, instead of CSS.
-T.J.
I don't have any HTML diagnosis tools here (It've been 4 or 5 years since I did some serious HTML work), but it appears that there's an extra <table> defined.
Man, this tool sure depend heavily on table formatting, instead of CSS.
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).