Programming with Reflection

$image\rwnprg32.gif$ Xfr400HavingString property

Syntax	object.Xfr400HavingString object.Xfr400HavingString = Value
Data type	String

Description

Returns (first syntax line) or specifies (second syntax line) a string that imposes a condition on a function of the Select statement. You can only create a Having statement after you create a select statement using Xfr400SelectString. Note: SQL query options can also be set using the SetSQLStatement method. Transfer options set using the method supersede any transfer options entered using this property.

This property affects AS/400 data transfer and is only relevant to 5250 sessions.

Values

The default is "".

This string can be up to 220 characters long and should use the following syntax:

<function>(field name)<test><value>

$image\jump.gif$ Keyword Index

$image\popup.gif$ Related Topics

$image\popup.gif$ Reflection products that use this property