AppLib CREATE TABLE AS

Syntax

CALL APPLIB.CREATE_TABLE_AS( schemaName, tableName, selectStmt, shouldLoad )

Purpose

Creates a table with the same structure as the SQL statement passed in. It optionally loads the table after creating the table. NOTE: It does not do any indexing/analyzing etc.

Parameters

• schemaName: name of schema to create the table in [VARCHAR(128)]
• tableName: name of table to create [VARCHAR(128)]
• selectStmt: the SQL statement that should be used to create define the structure and potentially the contents of the new table [VARCHAR(65535)]
• shouldLoad: false = do NOT load the table after creating. true = do load the new table using the SQL statement after creating. [boolean]