PowerBuilder 10.5 allows you to create and edit temporary tables in the Database painter, SQL painter, or DataWindow painter when you use the PowerBuilder SYC native driver to connect to an Adaptive Server Enterprise database. Temporary tables persist for the duration of a database connection, residing in a special database called "tempdb".

You add a temporary table to the tempdb database by assigning a name that starts with the # character when you create a new table in a PowerBuilder 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. Selecting Edit Data from the pop-up menu of a temporary table retrieves data that you store in that table.

For more information

For more information, click the link to go to the section on creating and editing Adaptive Server temporary tables in the User’s Guide.