Sybase and tempdb

126

Hi, Im working with Sybase central - Adaptive Server Anywhere 9 and I want some examples in the use of de tempDB.

How , for example can I insert some records in a temporary table ? I tried for example: select * into TempDB.dba.#testing from testTable

but I got the followiing error: Syntax error near '.' on line 1

There are two sets of temp tables and you have mixed them up

1) Session related there are access as #table ie

select * into #testing from testTable

This lasts as long as your connection

2) tables in tempdb. These persist until the server gets rebooted.

select * into TempDB.testing from testTable

See sybase docs for more info ASE

Mark 2010-02-09 14:02:47

select * into TempDB.testing from testTable works ! :) but the table testing doesnt exsist it says. I thought that it would create it automatically .

Sjemmie 2010-02-09 14:06:29

It should do - what is the full code you tried

Mark 2010-02-09 14:38:13

I think I made a typo try TempDB..testing

Mark 2010-02-09 14:39:06

unfortunately,i get the following error again: Syntax error near '.' on line 1

Sjemmie 2010-02-09 15:57:04

What ius the code you have?

Mark 2010-02-09 16:34:19

Never mind mark, insert into TempDB.testing(select * from table) also works, thk u very much for the help !!

Sjemmie 2010-02-10 09:06:39

Ah insert into TempDB.testing(select * from table) works if the table already exists select into works if it does not exist

Mark 2010-02-10 12:24:19

ansaurus