TABLESTREAM

The TABLESTREAM function returns the data from a stream stored in a request or a session associated with the specified key.

The stream stored by StreamPut component can be used.

Multiple key and multiple output is available.

Input/Output

Number of Connections: Min: 1/Max:Unlimited

Input	Data Type	Description
InputN	String	The key.

Output	Data Type	Description
OutputN	String	The data associated with the specified key.

Property

Name	Property Type	Description
Scope	choice	Specifies the scope where a stream is stored. request - Current request session - Current session
StreamName	string	Specifies a name of stream stored by StreamPut component
KeyColumn	string	Specifies the columns used as a key. If you specifies multiple columns as keys, specify the concatenated string with comma. The first column is indexed as 1.
ValueColumn	string	Specifies the columns used as a value. If you specifies multiple columns as values, specify the concatenated string with comma. The first column is indexed as 1.
IllegalKey	choice	Defines what is to be output if no data exists for the specified key. Null [Null] An empty String ("") is output. Multiple columns are selected as vakye columns, all columns are set to null. Key [Key] The input key is passed directly as output. Multiple keys or columns are selected, a value correspond order is set. DefaultValue [DefaultValue] The DefaultValue is output. If FileType is "CSV" and the multiple value columns are defined, all value of columns are set to DefaultValue. Exception [Exception] An Exception is thrown.
DefaultValue	string	IllegalKeyが「DefaultValue」の場合の出力値を指定します。

Error

Case

• When the key column's index is invalid
• When the value column's index is invalid

Topic

For this function use, the stream is stored by StreamPut component before this function is used.