Urgent

Hi, 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. Thanks Sarah ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Hi! You will have to use either Unix tools (wc and awk) or add more statements writing to separate files and combine these together or if you have ISQL, just write a report that will write to a file that looks like output from unload command. HTH Michael Sarah Jessica wrote: > Hi, > 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. > Thanks > Sarah > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com