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