Data types in outcome messages

Data types in outcome messages

The possible data types in Outcome Messages are listed below:

Data Source: Profile Feed File
Type of Data	Data Selection Function	Value of Data
Field	(none)	The value contained in the field.

Data Source: Container
Type of Data	Data Selection Function	Value of Data
Total Container contents. Represented by "*"	Count	An integer representing the number of entries in the Container.
Total Container contents. Represented by "*"	Data	The actual data values of every field, in every row in the Container. The number of fields, name of fields, and order of fields in each row is determined by the Type Descriptor defined in the Container.
Field	Average	The average of the values in the Container for the specified field.
Field	Count	An integer representing the number of entries in the Container for the specified field.
Field	Count Distinct	An integer representing the number of unique entries in the Container for the specified field.
Field	Maximum	The actual data value of the highest of the values saved in the Container for the specified field.
Field	Minimum	The actual data value of the lowest of the values saved in the Container for the specified field.
Field	Mode	The actual data value of the most frequently occurring value saved in the Container for the specified field.
Field	Sum	An integer representing a total of the values in the Container for the specified field.
Field	Standard Deviation	A numeric value representing the measure of the scatter of values around the average of the data values saved in the Container for the specified field.
Field	Data	The actual data values for the specified field, in every row in the Container.

Data Source: Select Function
Type of Data	Data Selection Function	Value of Data
All selected rows. Represented by "*"	Count	An integer representing the number of rows returned by the Select function.
All selected rows. Represented by "*"	Data	The actual data values of every field, in every row returned by the Select Function. The number of fields, name of fields, and order of fields in each row is determined by the Type Descriptor defined in the Select Function.
Field	Average	The average of the values returned by the Select Function for the specified field.
Field	Count	An integer representing the number of entries returned by the Select Function for the specified field.
Field	Count Distinct	An integer representing the number of unique entries returned by the Select Function for the specified field.
Field	Maximum	The actual data value of the highest of the values returned by the Select Function for the specified field.
Field	Minimum	The actual data value of the lowest of the values returned by the Select Function for the specified field.
Field	Mode	The actual data value of the most frequently occurring value returned by the Select Function for the specified field.
Field	Sum	An integer representing a total of the values returned by the Select Function for the specified field.
Field	Standard Deviation	A numeric value representing the measure of the scatter of values around the average of the data values returned by the Select Function for the specified field.
Field	Data	The actual data values for the specified field, in every row returned by the Select Function.

Data Source: Join Function
Type of Data	Data Selection Function	Value of Data
All selected rows. Represented by "*"	Count	An integer representing the number of rows returned by the Join function.
All selected rows. Represented by "*"	Data	The actual data values of every field, in every row returned by the Join Function. The number of fields, name of fields, and order of fields in each row is determined by the Type Descriptor defined in the Join Function.
Field	Average	The average of the values returned by the Join Function for the specified field.
Field	Count	An integer representing the number of entries returned by the Join Function for the specified field.
Field	Count Distinct	An integer representing the number of unique entries returned by the Join Function for the specified field.
Field	Maximum	The actual data value of the highest of the values returned by the Join Function for the specified field.
Field	Minimum	The actual data value of the lowest of the values returned by the Join Function for the specified field.
Field	Mode	The actual data value of the most frequently occurring value returned by the Join Function for the specified field.
Field	Sum	An integer representing a total of the values returned by the Join Function for the specified field.
Field	Standard Deviation	A numeric value representing the measure of the scatter of values around the average of the data values returned by the Join Function for the specified field.
Field	Data	The actual data values for the specified field, in every row returned by the Join Function.

Copyright IBM Corporation 2012. All Rights Reserved.