Enumerations

The public enumerations of the Aumerial.Data.Nti namespace, with their values. Numeric values marked "v4 compat" are a contract: they will not change.

NamingConvention

SQL naming convention, carried by the NamingConvention property of NTiConnection and the naming keyword (accepted values: sql, *sql, 0; sys, system, *sys, 1). The EF Core provider requires SQL (clear error otherwise). v4 compat values.

CatalogName

DB2 for i catalog views (under QSYS2) retrievable through GetSchema(CatalogName, restrictions): the member name IS the view name; the numeric value follows declaration order and is not a contract. The ADO.NET collection aliases (Tables, Columns, Schemas, Views, Keys, Fields, Constraints, Procedures, Functions...) map onto these through GetSchema(string) and MapCollection(string). The first restriction filters by object name (schema name for SYSSCHEMAS). On IBM i 7.2, some views do not exist yet and the matching collections are unavailable (7.4 or later recommended).

SYSCATALOGS, SYSCHKCST, SYSCOLAUTH, SYSCOLUMNS, SYSCOLUMNS2, SYSCOLUMNSTAT,
SYSCONTROLS, SYSCONTROLSDEP, SYSCST, SYSCSTCOL, SYSCSTDEP, SYSFIELDS, SYSFUNCS,
SYSINDEXES, SYSINDEXSTAT, SYSJARCONTENTS, SYSJAROBJECTS, SYSKEYCST, SYSKEYS,
SYSMQTSTAT, SYSPACKAGE, SYSPACKAGEAUTH, SYSPACKAGESTAT, SYSPACKAGESTMTSTAT,
SYSPARMS, SYSPARTITIONDISK, SYSPARTITIONINDEXDISK, SYSPARTITIONINDEXES,
SYSPARTITIONINDEXSTAT, SYSPARTITIONMQTS, SYSPARTITIONSTAT, SYSPROCS,
SYSPROGRAMSTAT, SYSPROGRAMSTMTSTAT, SYSREFCST, SYSROUTINEAUTH, SYSROUTINEDEP,
SYSROUTINES, SYSSCHEMAAUTH, SYSSCHEMAS, SYSSEQUENCEAUTH, SYSSEQUENCES,
SYSTABAUTH, SYSTABLEDEP, SYSTABLEINDEXSTAT, SYSTABLES, SYSTABLESTAT, SYSTRIGCOL,
SYSTRIGDEP, SYSTRIGGERS, SYSTRIGUPD, SYSTYPES, SYSUDTAUTH, SYSVARIABLEAUTH,
SYSVARIABLEDEP, SYSVARIABLES, SYSVIEWDEP, SYSVIEWS, SYSXSROBJECTAUTH,
XSRANNOTATIONINFO, XSROBJECTCOMPONENTS, XSROBJECTHIERARCHIES, XSROBJECTS

NTiType

DB2 for i data types, SQLTYPE numbers (v4 compat values). Exposed by NTiParameter.NTiType, derived by the server when the statement is prepared (0 before prepare; v4 threw a NullReferenceException in that case). Decimal is the packed decimal, Numeric the zoned decimal; Float, Real and Double share SQLTYPE 480 (FLOAT).

DecfloatRoundOption

DECFLOAT rounding mode, sent to the server (v4 compat values). DecfloatRoundMode property on the connection; the roundoption keyword takes the NUMERIC value.

NTiServiceProgramReturnFormat

Return value formats of CallServiceProgram/CallServiceProgramAsync; the values are those of the QZRUCLSP system API. Value 2 (pointer return) is deliberately absent: a space pointer only has meaning inside the server job; a procedure returning text fills a caller supplied buffer.

NTiServiceProgramParameterFormat

How a service program procedure parameter is passed, set through the ServiceProgramParameterFormat property of NTiProgramParameter; QZRUCLSP values.

ParameterDirection (System.Data)

Standard ADO.NET enumeration (Microsoft reference); NTi usage on program parameters:

Example

using System;
using System.Data;
using System.Threading.Tasks;
using Aumerial.Data.Nti;

class EnumsDemo
{
    static async Task Main()
    {
        await using var connection = new NTiConnection(
            "server=MYIBMI;user=MYUSER;password=MYPASSWORD;naming=sql;roundoption=0");
        await connection.OpenAsync();                     // Open() remains available for sync code

        // Typed equivalents of the keywords
        Console.WriteLine(connection.NamingConvention);   // NamingConvention.SQL
        Console.WriteLine(connection.DecfloatRoundMode);  // DecfloatRoundOption.HalfEven

        // CatalogName: typed QSYS2 catalog view; first restriction = object name
        DataTable columns = connection.GetSchema(CatalogName.SYSCOLUMNS, new[] { "ORDERS" });
        foreach (DataRow row in columns.Rows)
            Console.WriteLine(row["COLUMN_NAME"]);
    }
}