Skip to Content
0
Former Member
Jul 28, 2007 at 09:42 AM

doubts in spool

12 Views

hi guys,

i am writing some program which updates an db table by reading

from one table and updateing into 2nd table by comapring with some

already existing vlaues in it,if its not already there it will update

the 2nd one .If there is some update failure, program has to terminates

and it should write an <b>log </b> which shows how many records

have been deleted of how many read.In this program user has an option

'no-update' in which case no update will occur instead just an

written <b>output to the spool</b> of which field will be deleted when it runs with update mode.

can some one give me some sample code of this.

point wil be rewarded

ravi