InfoMaker 10.2.1 allows you to create and edit temporary tables when you use the InfoMaker SYC native driver to connect to an Adaptive Server database. You can create temporary tables in the Database painter, SQL painter, or Report painter. Temporary tables persist for the duration of a database connection, residing in a special database called “tempdb”.
Add a temporary table to the tempdb database by assigning a name that starts with the # character when you create a new table in an InfoMaker painter. Temporary tables must start with the # character.
After you create a temporary table, you can create indexes and a primary key for the table. If you define a unique index or primary key, you can execute INSERT, UPDATE, and DELETE statements for a temporary table. Select Edit Data from the pop-up menu of a temporary table to retrieve data that you store in that table.
Standard catalog query limitations
When you click Refresh from the pop-up menu for the Tables
node in the Database painter or the Objects view of the Report painter,
the list of tables displays temporary tables even though they exist
only in the tempdb database. However, once
you refresh table definitions from the database, the Objects views
can no longer list the index or primary key information of the temporary tables
and the Layout view can no longer display that information graphically.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
