RE: Creating and using temporary tables

["Ray Ontko" <rayo>]

>      Howard Hartsfield has run into a problem which he posted to the
> Comp.Databases.Sybase Usenet group.  He wants to create a temporary
> table in a program and use it.  Of course the parser complains at
> compile time that the table doesn't exist.  Is his only recourse to make
> it a permanent table?

>From a system administration and efficiency standpoint, it may make sense to
create the table permanently.  If the table needs to be separate for each
user or session, you may want to add a column identifying the user and
have periodic batch jobs to clean up any old data that gets left around.

If he's generating an SQT file, it is possible to create the table,
compile the program, and then drop the table (assuming of course that
the program creates the table and drops it during its execution.)

If he's not generating an SQT file, I can't think of any other work
around besides a permanent table.

Ray
-----------------------------------------------------------------------
Ray Ontko       rayo@ontko.com  "Ask me about Database Illustrator(tm)"
Ray Ontko & Co  info@ontko.com   ftp.ontko.com:/users/ontko (anon ftp)