ShowTempTables – PB Docs 126

ShowTempTables database parameter

Description

Specifies whether temporary tables are displayed when you
request a list of tables from the Database painter or SQL Select painter.

Controls

  • ASE, SYC SAP Adaptive
    Server Enterprise

Syntax

Parameter

Description

value

Specifies whether temporary tables are
displayed when you request a list of tables. Values are:

  • 1

    (Default) Display temporary tables.

  • 0

    Do not display temporary tables.

Default

ShowTempTables=1

Usage

The ShowTempTables database parameter applies only to database connections
from within the development environment. When ShowTempTables=1,
a request for a list of database tables from within a painter causes
both sp_pb100table and sp_pb100temptab to execute.
The union of these two result sets is displayed to the user. If
ShowTempTables=0, only sp_pb100table is executed.
The behavior is the same if the stored procedures are not installed
on the ASE server.

Examples

To specify that you want to display temporary tables,
select the Show Temp Tables check box on the System page in the
Database Profile Setup dialog box.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x