Page 1 of 1
i wnt to truncate the data while reading the from source
Posted: Mon Dec 19, 2005 4:29 am
by sekr
Hi !
my source system is DB2 i have to truncate the records from source while reading source ..
how it can be done
Posted: Mon Dec 19, 2005 6:53 am
by MukundShastri
Can you elaborate what you want to say. Give an example.
Mukund
Posted: Mon Dec 19, 2005 7:28 am
by sekr
I dnt want any data while reading the table from DB3 Table.
example :-
tabel <emp >
dob name
05/05/2005 simi
06/06/2002 rimi
while reading source i dnt wnt this data.
Posted: Mon Dec 19, 2005 7:39 am
by ArndW
Sekr,
my first thought is that if you don't want the data, don't ask for it. Remove the extra columns from your query so that they are not processed. But perhaps I have mistaken your intent on your 2 posts.