Release Notes


10.1 System Temporary Table Schemas

The schema for a system temporary table is determined by the application and authorization ID that create it. When this data is available, the schema in which the table is created is <AUTHID><APPLID>. Under some circumstances, the tables are created using only one of these IDs to determine the schema, and sometimes, none. This can result in a tables such as AUTHID.TEMPTABLENAME, or .TEMPTABLENAME. You can view the schema information for these tables by using the GET SNAPSHOT command. For information on this command, please refer to the Command Reference


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]