Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Sybase Temp Tables
 Login/Join
 
<mkm4>
posted
Does anybody know how to use and retrieve data from Sybase style temp tables?
Everything I've tried has resulted in failures.

Thanks.

-- Kirk
 
Reply With QuoteReport This Post
<Kyle>
posted
What type of temp tables are you talking about?

Last time I worked with Sybase (10/11) there were 3 different types of temp tables all with different persistence/availability options.

1. If you created the table as tempdb..table_name, the table would exist until deleted or until the Sybase instance was restarted. Anybody (with required permissions) could view these tables.

2. If you created the table as #table_name via a SQL statement, the table would only exist as long as your Sybase session was active. As soon as you log out, the table would be deleted. Also, only the session in which the tables was created could query it. If you are creating the table in one request and then trying to report on it in another request, you may be getting disconnected from the server and then reconnecting. This means the table is getting deleted.

3. If you created the tables as #table_name via a stored procedure, the table only exist as long as the stored procedure is running. As soon as the stored procedure finishes, the table is deleted. I don't believe WF (or any other product) cannot access these tables.
 
Reply With QuoteReport This Post
<mkm4>
posted
They are the # style tables. I've tried to do everything within one sql statement and as seperate sql statements within one fex. Nothing works.

I can't create the table within tempdb directly, because multiple users might be running the same report at any one time.
 
Reply With QuoteReport This Post
<pranas>
posted
You can try using HOLD files on reporting server side. It may work with aggregated data nicely.

Pranas
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.