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.
Truncate and reload the table using ODBC
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What?samsuf2002 wrote:u tryu using after job sub routine where u can truncate the table after the job is processed
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
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.chulett wrote: First select and land the records from the table. Then a separate job to truncate and reload. Two steps.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............