Where can I find the reference manual about creating existing table?
Would you mind to give me some examples on creating the table?

Thanks

BJ


Michael Peppler 寫道：

> On Fri, 12 Aug 2005 21:09:32 -0700, BJ wrote:
>
> > Hello all
> >
> > I can use bcp command to output database views to text file. My statement
> > is:
> > bcp database_name..viewname out output_filename.txt -Uusername
> > -Sservername -Ppassword -c
> >
> > However, an error occurs when I use the same statment to output stored
> > procedure result. I typed:
> > bcp database_name..stored_procedure_name out output_filename.txt
> > -Uusername -Sservername -Ppassword -c
> >
> > Could anyone give me some suggestions?
>
> You can probably create a proxy table that maps to the stored procedure,
> and then bcp out from the proxy table. Take a look at the "create existing
> table" command in the reference manual.
>
> Michael
> --
> Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
> Sybase DBA/Developer
> Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html