Output Table Model Data Log

Operation Name

Write values of specified columns from table model type input data to execution log at arbitrary log level.

Table model type.

For more details on input/output schema, refer to “Schema”.

For details on use of variables, refer to “Variables”.

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter the name to show on the script canvas.
Input data	Required	Not available	Select a component on the script canvas.

Item name	Required/Optional	Use of variables	Description	Remarks
Output log level	Required	Not available	Select a log level to output in. [NOTICE]: [INFO]: (default) [FINFO]: [FINEST]: [DEBUG]:	Log will be output in the specified log level. Refer to “Log Level” for more details.
Column filter	Optional	Available	Enter the filter for columns to output. For details on filter syntax, refer to “Column filter syntax”.	When column filter is not set, all the columns of input data will be output.

Item name	Required/Optional	Use of variables	Description	Remarks
Data processing method	Required	Not available	Select data processing method. [Apply script settings]: (default) Apply the mass data processing settings of the script property to the adapter. [Do not perform mass data processing]: Mass data processing will not be performed. [Perform mass data processing]: Mass data processing will be performed.

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

You can enter the column filter with the following syntax.

Filter syntax	Example	Description
Single	1	When only column number is entered, the column will be output.
On and after	6-	When a hyphen is entered after column number, the columns on and after the number will be output.
On and before	-3	When a hyphen is entered before column number, the columns on and before the number will be output.
Range	2-5	When column numbers concatenated with a hyphen are entered, it means a range and the columns in the range will be output.

You can specify multiple filters with commas.
- Example:3,4,6-9,12-
When column number is duplicate, the first one will be effective and latter ones will be ignored.

When a column of specified number does not exist in input data, N/A will be output for that column.

Same as the schema of input component.

Same as the schema of input component.

Refer to “Schema of table model type” for more details.

Schema should be loaded manually.
Specify the schema of the data to be read.

Refer to “Edit Schema” for more details.

PSP is supported.

Refer to “Parallel Stream Processing” for more details.

Component variable name	Description	Remarks
message_category	When an error occurs, the corresponding message code's category is stored.	Default value is null.
message_code	When an error occurs, the corresponding message code is stored.	Default value is null.
message_level	When an error occurs, the corresponding message code's severity is stored.	Default value is null.
error_type	When an error occurs, the error type is stored.	Default value is null. The error type will be in the following format. Example: “java.io.FileNotFoundException” The contents that will be stored may vary depending on DataSpider Servista versions.
error_message	When an error occurs, the error message is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions.
error_trace	When an error occurs, the error's trace information is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions and client applications.

Exception name	Cause	Solution
InputDataNotFoundException	[Input data] is not specified.	Specify [Input data] or draw data flow.
InvalidPropertyConfigurationException	The syntax of [Column filter] is invalid.	Check whether the syntax of [Column filter] is wrong.