Home > Contents > Index >
ICS.SQLEXP
Allows building of the components of a SQL where clause without direct knowledge of the data type of a column and the database-specific rules for specifying a literal for that column.
Syntax
<ICS.SQLEXP COLUMN="column name" OUTPUT="variable name" STRING="string" TABLE="table name" [TYPE="logical operator"] VERB="comparison operator" [EXPRESSION="expression"]/>Parameters
COLUMN (required)
- Name of the column in the table.
OUTPUT (required)
- Name of the output variable.
STRING (required)
- Value or values to compare against.
TABLE (required)
- Name of the table.
TYPE (optional)
- Logical operator to use between. Default is
AND
.
VERB (required)
- Comparison operator.
EXPRESSION (optional)
- Column expression to be used instead of the column name.
Error Numbers
The possible values of
errno
include:
Value Description -100 Exception error -103 Invalid table name -106 Bad parameter value -406 Bad parameter value -10004 Missing required attributeRelease Introduced
This tag was introduced in CS release 5.0.
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.