ddlCreateTempTable() - create a new temporary table at run-time

ddlCreatesTempTable() create one or more temporary tables at run-time

Prototype:

   void ddlCreateTempTable(
      CONTROL *ctl,
      char *OptnStr,
      char *ArgList,           /* command argument list */
      char *DbdImage);

Permitted values in OptnStr:

/D - if temp table with same name exists, replace it

Form of ArgList:

<TempTableHandle> represents the Temp-Table handle; the <TempTableHandle> is used with ddlDestroyTempTable() to destroy the temp table; it also appears in the INFO display as the ATTACHed data base name for this table.

Description of Parameter DbdImage:

char *DbdImage is a memory block that contains the ascii image of a symbolic Database Definition (DBD). Each line of ascii text is terminated by "\r\n" or "\n".

The symbolic DBD must be a complete DBD; that is, it must contain a DATA BASE NAME IS Statement plus at least one table definition (TD). But the symbolic DBD is also subject to considerable restrictions; in particular:
. the DATA BASE NAME IS Statement must contain a valid Database name; but that name is superseded by the <TempTableHandle>;
. all tables definitions must include the TEMP qualifier;
. there can be no KEYed fields;

The symbolic DBD may include both the external name and internal name for tables and columns. The form for the modified table definition (TD) statement is:
TD ["<External-Table-Name>" AS] <Internal-Table-Name> nnn RECORDS TEMP
In this form,
. "s are required around the <External-Table-Name>;
. the <External-Table-Name> may optionally include a schema name;
The form for the modified data definition is:
["<External-Column-Name>" AS] <Internal-Column-Name>
In this form,
. "s are required around the <External-Column-Name>;
. the <External-Column-Name> must include the <External-Table-Name> [and the schema name, if applicable];

Description:

Notes:

This API function can be called via the ddlCommand() function with the command:
CREATETEMPTABLE/<Options> <TempTableHandle> <DbdImage>
In this context, the <DbdImage> can be expressed as an ascii string with the forward slash character ('/') being used in place of the conventional line delimiter.

Value returned in Control.Ans1:
If the command succeeds, %Answer1 contains "1".

Examples of Using ddlCreateTempTable()