Truncate and reload the table using ODBC
Posted: Wed Dec 06, 2006 9:15 am
Hi,
I am trying to select from a Table-A using ODBC section in the process and funnel the records with new records and Truncate and Write the new records to the Table-A.
But when i am tying to select from Table-A, it is not fetching any records as the Table-A has no records - but there are records in that Table-A.
I think in the process before selection it is Truncating the Table-A.
Is there any way not to truncate the Table-A until the end of the process or not before Selecting the data from the Table-A.
Any help is appreciated.
I am trying to select from a Table-A using ODBC section in the process and funnel the records with new records and Truncate and Write the new records to the Table-A.
But when i am tying to select from Table-A, it is not fetching any records as the Table-A has no records - but there are records in that Table-A.
I think in the process before selection it is Truncating the Table-A.
Is there any way not to truncate the Table-A until the end of the process or not before Selecting the data from the Table-A.
Any help is appreciated.