stores_demo -  functions -  metadata_2

Description

none

Function properties

name	value
name	metadata_2
created
type	SQL scalar function

Parameters

none

Usage

set @myvar = metadata_2

Code

create function informix.metadata_2(
    out supportsUnion                         integer,  /* 62 */
    out supportsUnionAll                      integer,
    out supportsOpenCursorsAcrossCommit       integer,
    out supportsOpenCursorsAcrossRollback     integer,
    out supportsOpenStatementsAcrossCommit    integer,
    out supportsOpenStatementsAcrossRollback  integer,
    out getMaxBinaryLiteralLength             integer,
    out getMaxCharLiteralLength               integer,
    out getMaxColumnNameLength                integer,   /* 70 */
    out getMaxColumnsInGroupBy                integer,   /* 71 */
    out getMaxColumnsInIndex                  integer,
    out getMaxColumnsInOrderBy                integer,
    out getMaxColumnsInSelect                 integer,
    out getMaxColumnsInTable                  integer,
    out getMaxConnections                     integer,
    out getMaxCursorNameLength                integer,
    out getMaxIndexLength                     integer,
    out getMaxSchemaNameLength                integer,
    out getMaxProcedureNameLength             integer,  /* 80 */
    out getMaxCatalogNameLength               integer,  /* 81 */
    out getMaxRowSize                         integer,
    out doesMaxRowSizeIncludeBlobs            integer,
    out getMaxStatementLength                 integer,
    out getMaxStatements                      integer,
    out getMaxTableNameLength                 integer,
    out getMaxTablesInSelect                  integer,
    out getMaxUserNameLength                  integer,
    out getDefaultTransactionIsolation        integer,
    out supportsTransactions                  integer,   /* 90 */
    out supportsTransactionIsolationLevel     varchar(50),  /* 91 */
    out supportsDataDefinitionAndDataManipulationTransactions   integer,
    out supportsDataManipulationTransactionsOnly     integer,
    out dataDefinitionCausesTransactionCommit        integer,
    out dataDefinitionIgnoredInTransactions          integer,
    out supportsResultSetType                 varchar(50),   /* 96 */
    out supportsResultSetConcurrency          varchar(50),
    out ownUpdatesAreVisible                  varchar(100),
    out ownDeletesAreVisible                  varchar(100),
    out ownInsertsAreVisible                  varchar(100),
    out othersUpdatesAreVisible               varchar(100),
    out othersDeletesAreVisible               varchar(100),
    out othersInsertsAreVisible               varchar(100),
    out updatesAreDetected                    varchar(100),
    out deletesAreDetected                    varchar(100),
    out insertsAreDetected                    varchar(100),  /* 106 */
    out supportsBatchUpdates                  integer,  /* 107 */
    out supportsSavepoints                    integer,
    out supportsGetGeneratedKeys              integer,
    out isANSI                                integer,
    out isLogged                              integer,
    out isBufferedLog                         integer)
returning integer
with ( handlesnulls )
external name '(metadata_2)'
LANGUAGE C;