| odbc2_createtablefromodbc() | ||
|---|---|---|
 | Chapter 14. The ODBC Client Companion Library |  |
odbc2_createtablefromodbc()
Description
Creates a new table, of a db1table tagged type, based on an ODBC
statement. If the return value is not .nul then the
function has failed and the string contains information describing the
error. After the new table is created, there is no attempt to commit the
base object; that is the responsibility of the caller.
Prototype
odbc2_createtablefromodbc (
type(*) baseconstatementparametersname
Parameters
| Parameter | Default value | Type name | Description |
|---|---|---|---|
| base | None | type(*) | Gives a base which supports the creation of new tables using the interface which is common to types which are tagged as db1table. |
| con | .nul | odbc1connection | Specifies the ODBC connection to be used for executing the provided statement. |
| statement | .nul | string | The ODBC SQL statement whose output columns will be used to define the fields of the new table to be created. |
| parameters | .nul | array |
The parameters, if any, to be passed to ODBC when the statement is
executed. If parameters is provided then the
parameter values must be stored in consecutive elements starting with
parameters[1].
|
| name | .nul | string | The name of the new table to create. |