CREATE_TEMP_TABLE

Syntax

CREATE_TEMP_TABLE {record | *}

Description

Creates temporary table images for use with PeopleSoft Application Engine programs. To customize the number of temporary tables, you need to modify the PeopleTools Options page or updated the PSOPTIONS table using the following SQL:

UPDATE PSOPTIONS SET TEMPTBLINSTANCES = number

You also need to review the number of temporary tables allotted for PeopleSoft Application Engine programs

Note:

For security reasons, this command is disabled for z/OS.DMS scripts generated by the Database Setup utility.