VMS Help  —  SQLMOD72  Arguments  data-type
    You can specify the character set of parameters that are defined
    as character data types. SQL assumes the character set of
    parameters based on the following rules:

    o  If a parameter is not qualified by a character set or defined
       as a national character data type, SQL considers the parameter
       to be of the default character set as specified in the DEFAULT
       CHARACTER SET clause.

    o  If a parameter is defined as a national character data type
       (NCHAR, NCHAR VARYING), SQL considers the parameter to be
       of the national character set as specified in the NATIONAL
       CHARACTER SET clause.

    o  If a parameter is defined as a data type qualified by a
       character set, SQL considers the parameter to be of that
       character set.

    See the Oracle Rdb SQL Reference Manual for information about
    data types and qualifying a data type with a character set.
    The Argument INTEGER topic describes the INTEGER data type with
    regard to the SQL module language.

    The SQL data type specified for the formal parameter in a module
    must be equivalent to the data type of the host language variable
    declaration for the actual parameter. If the formal parameter and
    actual parameter are not declared with equivalent data types, SQL
    can give unpredictable results.

    The data type for a database key is CHAR(n),  where n equals
    the number of bytes of the database key. See the Oracle Rdb SQL
    Reference Manual for more information on database keys.
Close Help