Enabling users to create tables in the database

A QMF user can create a table using any of these methods:

• SQL CREATE TABLE statement

  Enter the SQL CREATE TABLE statement from a QMF SQL query panel or run it from a saved query.

• QMF DISPLAY TABLE (or DISPLAY viewname) command, followed by the SAVE DATA command

  All SQL privileges on the underlying table or view are required. If the name you specify on the SAVE DATA command is the name of an existing table, QMF replaces or appends the existing data object. The SAVE command might be rejected if the table attributes do not match. For more information on the SAVE DATA command, see the QMF Reference manual and the online help.

• QMF IMPORT TABLE or IMPORT VIEW command

  All SQL privileges on the table or view being imported are required. If the name the user specifies on the IMPORT command is the name of a table that already exists, QMF replaces or appends the data in the existing table. The IMPORT command might be rejected if the table attributes do not match. For more information on the IMPORT command, see the QMF Reference manual and the online help.

Depending on the needs of your installation, you might need to create tables for your users or enable them to create their own tables.