RE: Urgent
From: "COOPER, Joseph" <Joseph.COOPER@sema.co.uk>
>
>Create a shell script along the lines of
>
>!/bin/ksh
>
>dbaccess joe - <<-EOF
>unload to "/tmp/joe1" delimiter "|"
>select count(*), sum(tabid) from systables;
>unload to "/tmp/joe2"
>select * from tab1;>EOF
>
>cat /tmp/joe1 /tmp/joe2 /tmp/joe1 > /tmp/joefin
>
>echo "Done"
>
>Unfortunately I din't have the employee table at
>hand so you'll have to do some work :)
It's not just me who doesn't read, then...
> > > > >The Employee table is like this:
> > > > >eno smallint
> > > > >ename char(20)
> > > > >amount money(14,2)
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com