bcp with sybase tempdb db

Kevman has asked for the wisdom of the Perl Monks concerning the following question:

Hi All,

I have a script that bcp's data into a Sybase table in tempdb.
If I set the tablename to be session specific (ie #) the
code bombs.

Is this a bug? (or feature )

Comment on bcp with sybase tempdb db

Replies are listed 'Best First'.
Re: bcp with sybase tempdb db by busunsl (Vicar) on Jun 07, 2001 at 14:49 UTC
It's a feature! Tables beginning with # are only known to a session. To bcp data into a table, the table has to exist. Since bcp creates it's own session it can not see any tables from other sessions and vice versa. Even if it were possible to bcp into #table, you couldn't use the data anywhere else.	[reply]