Quick Links to SQL Extended Functions

CONNX Data Integration Suite 14.8.0 | Reference Guide | SQL Grammar | SQL Extended Functions | Quick Links to SQL Extended Functions

Quick Links to SQL Extended Functions

Extended Functions in {}

{adabasfdtfname <adabas_fdt_file_name>}

{adabasfilename <adabas_file_name>}

{bsearchtempkey}

{autobulkinserton}

{autobulkinsertoff}

{caseinsensitive}

{casesensitive}

{fn enableservertrace}

{fn disableservertrace}

{fn flushopenfilecache <tablename>}

{fn refreshcdd}

{fn updatestatistics}

{fn setfilename <SQL Table Name>, <New File Name>}

{fn unsetfilename <File Name>}

{forceadanonukey}

{forceadanukey}

{ignoretimestampfraction}

{killstatement <statementID>}

{maxrows #[, offset]}

{multidbfilter <catalog name> <dbid>,<dbid2>,<dbid3>}

{nativetypemode}

{nopassthrough}

{nosqloptimize}

{nooptimizeoperator}

{recordmismatch}

{setadapassword}

{startconnectionpooling}

{startwiththistable}

{stopconnectionpooling}

{transactmode readonly}

{transactmode readwrite}

"A" to "B"

BIBXREF(field, prefix, index)

"C"

cnxclientcodepage()

cnxclientdefaultcodepage()

cnxcurrentconnections()

cnxcurrentstatements()

CNXFORCEBINARY (string_exp)

CNXFORCECHAR (binary_exp)

cnxpeakconnections()

cnxpeakstatements()

cnxsetfilename()

CNXSLEEP(numeric_exp)

cnxtotalconnections()

cnxtotalstatements()

"I" to "S"

ILIKE

SLIKE