Re: Urgent

---- you wrote: > From: "Sarah Jessica" <sarah_jessica@hotmail.com> > > > >I am unloading the data into the test.dat. How can I have the header and > >trailer that having the record count and the total amount. > > > >The Employee table is like this: > >eno smallint > >ename char(20) > >amount money(14,2) > > > >Now when I use the unload command like this > >unload to "/home/sarah/test.dat" delimiter "|" > > select * from employee;> > > >This will only unload all the records; but not have any header or trailer > >showing that; this is having so many records and total amount. > >Hope the group will comeout with positive response. > > Nope. UNLOAD by itself won't do that. But you can try something like: > > unload to "/home/sarah/test.dat" delimiter "|" > select count(*), sum(amount) from employee; > unload to pipe "cat >> /home/sarah/test.dat" delimiter "|" > select * from employee; > unload to pipe "cat >> /home/sarah/test.dat" delimiter "|" > select count(*), sum(amount) from employee; That's cool Dude! Is that in version 9? AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com