| Tags |
Description |
Optional |
Possible values |
| INPUT |
|
|
|
Root Tag |
Mandatory |
|
| |
USERID |
|
|
CDH User Id |
Mandatory |
User id, used for logging in
to CDH. |
| |
PASSWORD |
|
|
CDH Password for the above
User Id |
Mandatory |
This will be the encrypted
password of the User. This can be viewed at CDH "My Account" page
after logging in. |
| |
FILE_ATTACHMENT |
|
|
YES: Attach the output as a
file attachment. |
Optional |
YES
NO
Incase of huge results, the response will be sent only as
attachments. |
| |
FK_DECODE |
|
|
Decode the description value of the foreign key constraint & display the description as the value. |
Optional |
YES: The decoded description value will be returned in the column VALUE tag
NO: The original foreign key reference value set in this object will be returned in the VALUE tag
Incase this tag is not defined the original foreign key reference value will be returned in the VALUE tag & the decoded description will be returned in the DESCRIPTION tag(default). |
| |
FILE_TYPE |
|
|
Output File Type |
Optional |
Default Type will be XML
& XML content will be sent as SOAP message. |
| |
|
TYPE |
|
File
Type Value of the supported Output Format |
Optional |
Currently supported values:
1
2
1 stands for XML & 2 for Delimited Text File |
| |
|
DELIMITER |
|
Delimiter
for the file if the output file format is Text.
Note:Special characters which would break the document structure
if not specified inside the CDATA must be wrapped inside a CDATA
section. eg: > , < ..
CDH recommendeds to use CDATA
|
Optional |
Supported values:
1)Any special character wrapped in CDATA or
2)"TAB" for tab space as delimiter or
3)"SPACE" for a single space as delimiter.
Eg: Delimiter comma( , ) is specified as <![CDATA[,]]>
Default delimiter is comma [ , ] |
| |
|
TEXT_QUALIFIER |
|
Text
Qualifier for the string values in the Output file.
Note:Special characters which would break the document structure
if not specified inside the CDATA must be wrapped inside a CDATA
section. eg: > , <... |
Optional |
Any
special character wrapped in CDATA.
Eg: Delimiter single quote( ' ) is specified as
<![CDATA[']]>
No default value. |
| |
DATASETID |
|
|
Specifies the dataset Id of
the Table. |
Mandatory |
Any valid dataset id. |
| |
SELECTALLCOLUMNS |
|
|
If the
value is set to yes then all the columns are included in the
output |
Mandatory
if SELECTCOLUMNLIST tag is not specified.
|
YES
NO
Default: SELECTALLCOLUMNS tag will be set to YES
|
| |
SELECTCOLUMNLIST
|
|
|
Set the
names of columns to be returned. |
Mandatory
if SELECTALLCOLUMNS tag is not specified.
|
Default:
SELECTALLCOLUMNS tag will be set to YES |
| |
|
NAME |
|
Physical
column name |
Mandatory |
Any valid column name |
| |
FILTERLIST |
|
|
Specifies one or more filter condition |
Optional
|
|
| |
|
CONDITION |
|
Specifies a condition |
Optional |
Default operator between
the conditions will be 'AND' |
| |
|
|
NAME |
The
column name |
Mandatory
if CONDITION tag is specified. |
Any valid
column name |
| |
|
|
VALUE |
The
filter value. There can be any number of value tags depending on
the filter operator specified |
Mandatory
if CONDITION tag is specified. |
Any valid
value |
| |
|
|
FORMAT |
Specifies
the format in which the date value is entered for a Date Column. |
Mandatory
if the VALUE is Date. |
Any valid
Oracle date format. The date value entered must be in this format.
eg: Format:MM/DD/YYYY Value:12/31/2007
Format:DD/MM/YYYY Value:31/12/2007 |
| |
|
|
OPERATOR |
Specifies
the filter operator |
Optional |
Possible
values are
IN
NOT IN
BETWEEN
EQUALS
NOT EQUALS
GREATER THAN
LESS THAN
GREATER THAN EQUALS
LESS THAN EQUALS
IS NULL
IS NOT NULL
Default value : EQUALS |