Re: Urgent

From: a_blonde@mindless.com > > ---- 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? I said you could try it. I (still) have no idea whether or not it will work... :-) That's a lie. I tried it. It doesn't work (in 7.31, anyway). Sorry. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com