In sybase 12.5, when a temporary table is created it does not exist even for the same session.

eg.

CREATE TABLE #people
(
id INT,
name VARCHAR(32)
) ;


msg : Table created successful.

select *
from
#people

msg #people not found.

Is their any specific setting we need to do using sp_configure.

Are you issuing both queries from the same connection?

Hi,

If the temp table created and selected from the same session defnitely it will work.

For MCrowley:

yes both the queries was fired from the same session.

For erovij:

That is what even I believe. But this is not the case over here in sybase 12.5.
Was shocked !!!. I Strongly feels that there is some settings which needs to be done using sp_configure.

Are you doing it in isql?
After creating the table #people, go to tempdb and select * from sysobjects.
Check if the table exists. And provide the output if possible.

I'd be stunned. I've been using Sybase for decades and have only found one issue in all that time (fixed in one of the very very early versions). Are you absolutely certain you're in the same session?

CREATE TABLE #people
(
id INT,
name VARCHAR(32)
) ;

select *
from
sysobjects;

Both the above query was fired altogher, in a single run. I have got this #people______00000120009549451 table created.


But when both the queries was fired one by one, then even the sysobjects of tempdb does not contain entry for #people table.

Very weird.