Truncate and reload the table using ODBC

[Titto]

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.

[samsuf2002]

u tryu using after job sub routine where u can truncate the table after the job is processed

[ray.wurlod]

You can't truncate the table on which you have an open SELECT cursor!

[chulett]

u tryu using after job sub routine where u can truncate the table after the job is processed

What?

Titto - you need a two step process. First select and land the records from the table. Then a separate job to truncate and reload. Two steps.

[Nageshsunkoji]

First select and land the records from the table. Then a separate job to truncate and reload. Two steps.

Yes, Its a Good Idea, first select the records and land in a dataset in JobA and then IN JobB trunacate those records. It will avoid you all of your problems regarding Truncation.

[Titto]

First select and land the records from the table. Then a separate job to truncate and reload. Two steps.

I did split the job into 2 jobs - one create a load file and the next job to truncate and insert the new load file.

Thanks for the Information.

~Titto